MySQL without MySQL
by Volker Weber
Note to self: Need to test SQLite
SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process. The 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.
SQLite is not a client library used to connect to a big database server. SQLite is the server. The SQLite library reads and writes directly to and from the database files on disk.
Comments
Fantastic. Just built on FreeBSD and tested on WinXP. Works like a charm and databases are cross-platform capable (no byte-ordering problems). It really does seem to very fast, and the sqlite utility offers just about anything the admin/developer would desire. No license to be seen anywhere, but the *.[ch] files contain a copyright disclaimer.
Jan-Piet Mens, 2003-04-23