rcozens at pon.net
Sun Oct 23 10:34:42 CDT 2005
Hi again Pascal,
>I have scripted a hierarchical, binary-tree database in Transcript which
>is open-source and royalty-free. Relational indexes are NOT built in, but
>must be created and maintained individually.
SDB could be made relational by:
* Adding a list of inverted key field names or ordinals to the arguments
passed to the changeSDBRecord, deleteSDBRecord, and fileSDBRecord commands
and modifying the underlying logic to maintain inverted indexes.
Note: this could be implemented more transparently by tagging inverted key
fields in the data dictionary; but most of SDB's features can be accessed
without setting up a data dictionary description of the record, and I
desire to maintain that option for this feature.
* Adding support for an inverted key field name or ordinal argument in the
findSDBRecord and getSDBRecord commands.
Conceptually this is not difficult, and I'm willing to find the time to do
the scripting if anyone is interested enough to test it. Please contact me
privately if this interests you.
Rob Cozens CCW
Serendipity Software Company
"And I, which was two fooles, do so grow three;
Who are a little wise, the best fooles bee."
from "The Triple Foole" by John Donne (1572-1631)
More information about the use-livecode