[geeks] SQLite

[Joshua D Boyd]

On Thu, Nov 21, 2002 at 05:31:30PM -0600, Jonathan C Patschke wrote:
> On Thursday, Nov 21, 2002, at 11:17 US/Central, Joshua D Boyd wrote:
> 
> >Also, SQL Lite isn't a server, it is a library,
> 
> Hmmm!  That alone makes me want to play with it.  Embedded SQL is a 
> wonderful thing for tiny installations of programs that you'd later 
> want to scale to something bigger like PostgreSQL.  How ANSI-compliant 
> is it?

See http://www.sqlite.org/

Specifically, they implement all of SQL92, except what they list on this
page: http://www.sqlite.org/omitted.html

The most significant loss to me is that RIGHT OUTER JOIN and FULL OUTER
JOIN are missing.  Other people might be upset by the incomplete
triggers or no nested transactions.  It looks pretty easy to extend the
SQL language, but I suspect those particular missing items would be
thorny, otherwise, why wouldn't someone have done it already?

BTW, I have it installed.  See ~/src/sqlite-2.7.3/bld, where ~ is my
home directory.  If you want to actually install it, you will need to
recompile thanks to the way that SQLite links itself, it seems to be
tied to that specific location.  You can fiddle with it by running the
sqlite exectutable to create, populate, and query databases that can the
also be used by what ever program you link against sqlite.  I only
installed it today, so I haven't done a lot with it yet, other than
screw around in the sqlite example program.

-- 
Joshua D. Boyd