database

Rob Cozens rcozens at pon.net
Sun Oct 23 11:34:42 EDT 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 mailing list