Bugs for Sorcery are reported here

[bugzilla-daemon AT bugs.sourcemage.org]

http://bugs.sourcemage.org/show_bug.cgi?id=8325

           Summary: Optional database for indexing
           Product: Sorcery
           Version: Untargetted future release
          Platform: All
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Feature Request
        AssignedTo: sm-sorcery-bugs AT lists.ibiblio.org
        ReportedBy: eric AT sandall.us


We could add an INDEX_DB menu option in the Features menu which has (e.g. and
defaults to what we use now: flat files):
   [X]   FLAT_FILE
   [ ]   DB
   [ ]   SQLITE
   [ ]   MYSQL
...

You could only select one of these for use by `scribe index` (and gaze, cast,
etc.; anything that uses whatever `scribe index` does). Then, when someone
selects anything other than FLAT_FILE Sorcery will now "depend" on it (e.g. 
the
SORCERY_SOUND menu). Now indexing can be fast if the user wants to install/use
db, sqlite (both of which don't need a daemon), mysql, postgresql, etc.

Sorcery would then also need to setup the tables depending on what they 
choose.
Sorcery will also have to do the migration of data (e.g. if you use FLAT_FILE
for a while, then switch to DB, all your data from FLAT_FILE should be 
migrated
into DB. Then if you switch back or to another [e.g. SQLITE] then the data
should be migrated there).

Switching to a database should wipe the target INDEX_DB as the data there will
at least be the same information (if you didn't change anything between
switching), but almost always older (if you did any changes while using the
prior INDEX_DB) and checking tables for authenticity in the new INDEX_DB would
be more cumbersome than a wipe and copy (IMO).

This is mostly an idea we thought of that would speed up the
indexing/search/etc. for people who are worried about it without making it
required for the rest of us (not everyone wants to install sqlite or db nor do
we all want it required in basesystem).

-- 
Configure bugmail: http://bugs.sourcemage.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.