Project 33


Sqlite (sqlite3) was chosen because it is a free public domain database. It's small, embeddable and requires very little administration for its use, yet it's also SQL (and not just key/value pairs, etc.).

From www.sqlite.org:

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. Features include:

The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.

ACID Compliance

In addition to their data model, most practical databases ("transactional databases") attempt to enforce a database transaction . Ideally, the database software should enforce the ACID rules, summarized here:

Xql3 sqlite3 class

The Xql3 class used in these examples comes from sqlite3 stuff from Neurillion ...