This is a collection of my tools and code for working with SQLite, a free open source, light-weight, fast, portable database library which implements an increasingly large subset of SQL92.
All of the code is distributed under the "SQLite license" -- enjoy!
** The author disclaims copyright to this material. ** In place of a legal notice, here is a blessing: ** ** May you do good and not evil. ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give.
| sqlite | SQLite home site |
| yahoo | yahoo group -- active discussion list, file archive |
| lang | SQL language version understood by SQLite |
| timeline | timeline of recent changes generated by CVSTrac |
| download | download page for source and prebuilt binaries for Linux and Win32 |
| bugs | list of open bugs (add new) |
| cvs | browse the current source tree in CVS |
| wiki | wiki pages -- user maintained documentation web |
| sqlite | alternative home page for sqlite (under construction) |
| style | coding style of the SQLite library (unofficial) |
| speed | FAQ on optimizing use of SQLite for speed (preliminary) |
| API | documentation of the SQLite API (preliminary) |
| SQL92 | SQL92 draft specification |
Disclaimer:
Some of this code only works with specific older versions of sqlite (2.4.x or 2.7.x).
Some of the code may be untested, or broken. Use at your own risk. Hopefully it will be useful, at least as a guide.
| enctest | C sample: demonstrates using sqlite_encode_binary() and sqlite_decode_binary(). |
| freepages | C utility: counts free and total pages in an SQLite database |
| sqtables | C sample: outputs list of tables and views in an SQLite database |
The sqaux library is a collection of functions and sub-libraries which extend the main SQLite library.
These should compile against the SQLite library without the need to modify it.
All sqaux functions were recently renamed to start with the sqaux_ prefix.
Some of the functions rely on the zlib compression library.
| base | C header: interface for the main sqaux library |
| base | C library: implementation of the main sqaux library |
| user fns | C library: useful user functions for use with SQLite |
| user vars | C library: implements user variabless using user fns |
| cursors | C library: functions to iterate through the results of a query |