Release Notes: This release adds the sqlite3_create_function_v2() interface, which includes a destructor callback. It adds support for custom r-tree queries using application-supplied callback routines to define the boundary of the query region. The default page cache strives more diligently to avoid using memory beyond what is allocated to it by SQLITE_CONFIG_PAGECACHE. Or if using page cache is allocating from the heap, it strives to avoid going over the sqlite3_soft_heap_limit64(), even if SQLITE_ENABLE_MEMORY_MANAGEMENT is not set.
Release Notes: This release fixes a bug that caused a segfault when running a count(*) on the sqlite_master table of an empty database, a bug that caused a segfault when inserting into a table using a DEFAULT value when there was a function as part of the DEFAULT value expression, data structure alignment issues on Sparc, and other minor problems.
Release Notes: This release fixes a bug that could cause database corruption when a multi-processor system attempted to rollback an incomplete transaction following a system crash. It also fixes various other less severe bugs and enhances the query optimizer.
Release Notes: Support has been added for CHECK constraints, DESC indices, IF [NOT] EXISTS clauses on CREATE and DROP statements, a more efficient on-disk encoding for boolean values, and the ability to share the page and schema cache between database connections in the same thread. This is the first stable release in the 3.3 series.
Release Notes: An obscure bug was fixed that can cause database corruption under the following unusual circumstances: a large INSERT or UPDATE statement which is part of an even larger transaction fails due to a uniqueness contraint but the containing transaction commits.
Release Notes: A bug was fixed that might cause database corruption if a VACUUM failed and rolled back while processing a file larger than 1GiB. Optimizer improvements were made and support for COUNT(DISTINCT) was added.
Release Notes: Support for ALTER TABLE ADD COLUMN has been added.