SQLite

3.5.9

Released on 14 May 2008
Project description.

SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format.

SQLite 3.5.9 Changelog
  • Added experimental support for the journal_mode PRAGMA and persistent journal.
  • Journal mode PERSIST is the default behavior in exclusive locking mode.
  • Fix a performance regression on LEFT JOIN (see ticket #3015) that was mistakenly introduced in version 3.5.8.
  • Performance enhancement: Reengineer the internal routines used to interpret and render variable-length integers.
  • Fix a buffer-overrun problem in sqlite3_mprintf() which occurs when a string without a zero-terminator is passed to "%.*s".
  • Always convert IEEE floating point NaN values into NULL during processing. (Ticket #3060)
  • Make sure that when a connection blocks on a RESERVED lock that it is able to continue after the lock is released. (Ticket #3093)
  • The "configure" scripts should now automatically configure Unix systems for large file support. Improved error messages for when large files are encountered and large file support is disabled.
  • Avoid cache pages leaks following disk-full or I/O errors
  • And, many more minor bug fixes and performance enhancements....