1. EuSQL 0.7
I've just posted my latest release of EuSQL (0.7) at
http://www14.brinkster.com/matthewlewis/projects.html
*********** New in v0.7 ***********
* Multiple joins
* EUSQLRESULT type created for automated error handling
* Can create [non-unique] index on fields
* Full boolean conditional statements supported
* Literals now case-sensitive
* insert_record2() created for bulk inserts
* blank_record() created to get blank records easier
* Enforce datatypes on insert/update record
I apologize to those who have emailed that it took so long to get this out.
I only know of one bug (but I'm sure there are lots more!): LEFT/RIGHT
joins don't work right. Basically, it won't return all of the records that
it should. I have a plan to fix this, but its a very big fix/enhancement.
My next move will be to actually use indexed fields, and do some real query
optimization. If you have to do any large joins, I recommend that you use
some conditions to pare things down a bit, since the join logic is still all
brute force.
The demo has been completely rewritten. It's now in two parts. The first,
sql.ex, converts archive.edb (included) into sql.edb, a EuSQL version of
archive.edb. sqldemo.ex runs some queries on sql.edb.
Matt Lewis
