SQLite

3.8.9

Released on 8 Apr 2015
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.8.9 Changelog
  • Add VxWorks-7 as an officially supported and tested platform.
  • Added the sqlite3_status64() interface.
  • Fix memory size tracking so that it works even if SQLite uses more than 2GiB of memory.
  • Added the PRAGMA index_xinfo command.
  • Fix a potential 32-bit integer overflow problem in the sqlite3_blob_read() and sqlite3_blob_write() interfaces.
  • Ensure that prepared statements automatically reset on extended error codes of SQLITE_BUSY and SQLITE_LOCKED even when compiled using SQLITE_OMIT_AUTORESET.
  • Correct miscounts in the sqlite3_analyzer.exe utility related to WITHOUT ROWID tables.
  • Added the ".dbinfo" command to the command-line shell.
  • Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function.
  • Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the first token in a column.
  • SQLITE_SOURCE_ID: "2015-04-08 12:16:33 8a8ffc862e96f57aa698f93de10dee28e69f6e09"
  • SHA1 for sqlite3.c: 49f1c3ae347e1327b5aaa6c7f76126bdf09c6f42