SQLite

3.2.3

Released on 21 Aug 2005
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.2.3 Changelog
  • Added support for the CAST operator
  • Tcl interface allows BLOB values to be transferred to user-definedfunctions
  • Added the "transaction" method to the Tcl interface
  • Allow the DEFAULT value of a column to call functions that have constantoperands
  • Added the ANALYZE command for gathering statistics on indices andusing those statistics when picking an index in the optimizer
  • Remove the limit (formerly 100) on the number of terms in theWHERE clause
  • The right-hand side of the IN operator can now be a list of expressionsinstead of just a list of constants
  • Rework the optimizer so that it is able to make better use of indices
  • The order of tables in a join is adjusted automatically to makebetter use of indices
  • The IN operator is now a candidate for optimization even if the left-handside is not the left-most term of the index. Multiple IN operators can beused with the same index.
  • WHERE clause expressions using BETWEEN and OR are now candidatesfor optimization
  • Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKEcompile-time option to set its default value to "on".
  • Use indices to help with GLOB expressions and LIKE expressions toowhen the case_sensitive_like pragma is enabled
  • Added support for grave-accent quoting for compatibility with MySQL
  • Improved test coverage
  • Dozens of minor bug fixes