OpenEuphoria

EuSQL 0.7

• Posted by Matthew Lewis <matthewwalkerlewis at YAHOO.COM> May 13, 2002
• 353 views

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