New REBOL Database Engine

[btiffin]

TRETBASE is out.  http://tretbase.com

Paul Tretter has done an excellent job of creating a REBOL database manager.  Fast, simple and very very REBOL.  Along with the Create Update Retrieve and Delete, the key function is db/search.   Search accepts simple data, which scans the database returning any matches, or block data where the real REBOL power starts to show.   Inside the block is a search criteria code block and a results return control block.

Code:

>> db/search people [[age > 40] [name]]

Will return names of all entries of people over 40 (for example).

Code:

>> db/search trial [[print n  true] [r/1 r/3]]

Using TRETBASE's builtin  R record keyword, the above search returns all records (the first and third fields), in a nicely formatted block of data.  I added the print n to show off the builtin N keyword and to highlight that the search criteria can be pretty much any REBOL code.  All search blocks that return true trigger the result return control block.   Result control can include computations, fields by path notation, fields by name, literals, much more.

Too many features to list.  And like REBOL itself, all in a small package;  30K source for version 1 posted in April 2008.

Do yourself a favour and check out this extremely powerful database engine.   http://www.tretbase.com