Small. Fast. Reliable.
Choose any three.

SQLite Release 3.5.3 On 2007-11-27

  1. Move website and documentation files out of the source tree into a separate CM system.
  2. Fix a long-standing bug in INSERT INTO ... SELECT ... statements where the SELECT is compound.
  3. Fix a long-standing bug in RAISE(IGNORE) as used in BEFORE triggers.
  4. Fixed the operator precedence for the ~ operator.
  5. On Win32, do not return an error when attempting to delete a file that does not exist.
  6. Allow collating sequence names to be quoted.
  7. Modify the TCL interface to use sqlite3_prepare_v2().
  8. Fix multiple bugs that can occur following a malloc() failure.
  9. sqlite3_step() returns SQLITE_MISUSE instead of crashing when called with a NULL parameter.
  10. FTS3 now uses the SQLite memory allocator exclusively. The FTS3 amalgamation can now be appended to the SQLite amalgamation to generate a super-amalgamation containing both.
  11. The DISTINCT keyword now will sometimes use an INDEX if an appropriate index is available and the optimizer thinks its use might be advantageous.

A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.