Creating DB of stories from documents for a website
I want to create and maintain a database for a personal library; if it works, I would like to make it available online. I know there are several already available but I’m trying to set up something specific – something for the fanfiction community. (For those not in the know, ‘fanfiction’ is simply fiction written by fans of a variety of media including movies, books, television and etc.)
For example:
If you’ll look at this site, you’ll note that you can only search for ‘story,’ ‘author,’ ‘forum,’ ‘community,’ or, by using the ‘advanced’ option, you can then search for ‘title’ and ‘summary.’
I am looking for a way to actually be able to look within the story or document itself. Such as, if one can only remember bits and pieces of the work like ‘in the dead of night, the moon appeared as a hazy gray orb.’ This information can’t be found anywhere other than within the narrative itself.
While my knowledge of databases is small and I’ve worked with Access to build client DBs for a marketing department and another for an employment agency, I would think it would be possible, although probably difficult.
Is there any way of creating something this specific/intense?
Thank you :)


Software/Hardware used:
Any that will do the job
ASKED: August 24, 2010  5:55 AM
UPDATED: January 13, 2012  7:16 AM

Answer Wiki:
I would recommend the Open Source Drupal content management (www.drupal.org) platform to create a searchable fanfiction database/website as all content is stored and searchable in the database which can be MySQL, Oracle, or SQL Server.
Last Wiki Answer Submitted:  January 13, 2012  7:16 am  by  TechTalker   2,280 pts.
All Answer Wiki Contributors:  TechTalker   2,280 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _