[Chicken-users] sql-de-lite integrated SQLite3 library

[Arthur Maciel]

Jim, that's a perfect solution to a personal common problem and worry! What an awesome idea!

Thank you very much!
Arthur

Message: 1
Date: Thu, 12 Aug 2010 00:21:43 -0500
From: Jim Ursetto <address@hidden>
Subject: [Chicken-users] sql-de-lite integrated SQLite3 library
To: chicken-users users <address@hidden>
Message-ID:
       <AANLkTi=okTLtneMYGaB9JaBO=BhGoDMfwnWnC=address@hidden>
Content-Type: text/plain; charset=ISO-8859-1

Hi there.

SQLite3 is a great, lightweight database, but I have hesitated to use
it in Chicken applications because it's not guaranteed to be installed
or recent enough on a user's machine -- especially if they're on
Windows or OS X.  Installing it can be an annoying extra step for your
users.

To that end, I've updated the sql-de-lite egg to include an integrated
SQLite3 library, currently 3.7.0.1.  At installation time, the egg
will auto-detect whether your system library is present and recent
enough.  If so, it links against your system library; if not, it links
against the built-in library.  It's also possible to override the
auto-detection if desired.

The goal is to allow you to just depend on sql-de-lite in your
application and not worry about whether the library is installed or
too old.  SQLite3 is a great replacement for ad-hoc file formats and,
even if you are not a fan of SQL, the underlying database tech is
top-notch.

Integrated build has been tested on OS X 10.5, mingw32, and Ubuntu
10.04.  Just run `chicken-install -test sql-de-lite` if you would like
to test it out, and please report back any bugs or successes.

For more details, see http://3e8.org/chickadee/sql-de-lite#sec:Installation.

Jim