Skip to Content.
Sympa Menu

sm-sorcery-bugs - [SM-Sorcery-Bugs] [Bug 8325] New: Optional database for indexing

sm-sorcery-bugs AT lists.ibiblio.org

Subject: Bugs for Sorcery are reported here

List archive

Chronological Thread  
  • From: bugzilla-daemon AT bugs.sourcemage.org
  • To: sm-sorcery-bugs AT lists.ibiblio.org
  • Subject: [SM-Sorcery-Bugs] [Bug 8325] New: Optional database for indexing
  • Date: Sat, 26 Feb 2005 14:34:50 -0800 (PST)

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.



  • [SM-Sorcery-Bugs] [Bug 8325] New: Optional database for indexing, bugzilla-daemon, 02/26/2005

Archive powered by MHonArc 2.6.24.

Top of Page