Small. Fast. Reliable.
Choose any three.

About Sitemap Documentation Download License News Developers Support

## Recent News

### 2008-May-12 - Version 3.5.9

Version 3.5.9 adds a new experimental PRAGMA: journal_mode. Setting the journal mode to PERSIST can provide performance improvement on systems where deleting a file is expective. The PERSIST journal mode is still considered experimental and should be used with caution pending further testing.

Version 3.5.9 is intended to be the last stable release prior to version 3.6.0. Version 3.6.0 will make incompatible changes to the sqlite3_vfs VFS layer in order to address deficiencies in the original design. These incompatibilities will only effect programmers who write their own custom VFS layers (typically embedded device builders). The planned VFS changes will be much smaller than the changes that occurred on the 3.4.2 to 3.5.0 transaction that occurred last September.

This release of SQLite is considered stable and ready for production use.

### 2008-Apr-16 - Version 3.5.8

Version 3.5.8 includes some important new performance optimizations in the virtual machine code generator, including constant subexpression factoring and common subexpression elimination. This release also creates new public interfaces: sqlite3_randomness() provides access to SQLite's internal pseudo-random number generator, sqlite3_limit() allows size limits to be set at run-time on a per-connection basis, and sqlite3_context_db_handle() is a convenience routine that allows an application-defined SQL function implementation to retrieve its database connection handle.

This release of SQLite is considered stable and ready for production use.

### 2008-Mar-17 - Version 3.5.7

Version 3.5.7 fixes several minor and obscure bugs, especially in the autoconf-generated makefile. Upgrading is optional. This release of SQLite is considered stable and ready for production use.

### 2008-Feb-6 - Version 3.5.6

Version 3.5.6 fixes a minor regression in 3.5.5 - a regression that had nothing to do with the massive change ove the virtual machine to a register-based design. No problems have been reported with the new virtual machine. This release of SQLite is considered stable and ready for production use.

### 2008-Jan-31 - Version 3.5.5

Version 3.5.5 changes over 8% of the core source code of SQLite in order to convert the internal virtual machine from a stack-based design into a register-based design. This change will allow future optimizations and will avoid an entire class of stack overflow bugs that have caused problems in the past. Even though this change is large, extensive testing has found zero errors in the new virtual machine and so we believe this to be a very stable release.

### 2007-Dec-14 - Version 3.5.4

Version 3.5.4 fixes an long-standing but obscure bug in UPDATE and DELETE which might cause database corruption. (See ticket #2832.) Upgrading is recommended for all users.

This release also brings the processing of ORDER BY statements into compliance with standard SQL. This could, in theory, cause problems for existing applications that depend on the older, buggy behavior. See ticket #2822 for additional information.

### 2007-Dec-12 - SQLite Consortium Announced

The SQLite Consortium was launched today with Mozilla and Symbian as charter members. As noted in the press release, the Consortium's goal is to promote the continuing vitality and independence of SQLite.

### 2007-Nov-27 - Version 3.5.3

This is an incremental release that fixes several minor problems. Upgrading is optional. If Version 3.5.2 or 3.5.1 is working fine for you, then there is no pressing need to change to 3.5.3.

The prebuilt binaries and the amalgamation found on the download page include the FTS3 fulltext search extension module. We are doing this on an experimental basis and are not promising to provide prebuilt binaries with FTS3 in the future.

Old news...

This page last modified 2008/05/12 13:22:34 UTC