Small. Fast. Reliable.
Choose any three.
SQLite Release 3.2.3 On 2005-08-21
- Added support for the CAST operator
- Tcl interface allows BLOB values to be transferred to user-defined
- Added the "transaction" method to the Tcl interface
- Allow the DEFAULT value of a column to call functions that have constant
- Added the ANALYZE command for gathering statistics on indices and
using those statistics when picking an index in the optimizer
- Remove the limit (formerly 100) on the number of terms in the
- The right-hand side of the IN operator can now be a list of expressions
instead 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 make
better use of indices
- The IN operator is now a candidate for optimization even if the left-hand
side is not the left-most term of the index. Multiple IN operators can be
used with the same index.
- WHERE clause expressions using BETWEEN and OR are now candidates
- Added the "case_sensitive_like" pragma and the SQLITE_CASE_SENSITIVE_LIKE
compile-time option to set its default value to "on".
- Use indices to help with GLOB expressions and LIKE expressions too
when 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
A complete list of SQLite releases
in a single page is also available. A detailed history of every
check-in is available at