Small. Fast. Reliable.
Choose any three.

About Sitemap Documentation Download License News Developers Support

## Recent News

### 2009-Jan-12 - Version 3.6.8

SQLite version 3.6.8 adds support for nested transactions and improved optimization of WHERE clauses with OR-connected terms. There is also a new compile-time option that changes the way full-text search patterns are parsed so that they can contain nested paratheses.

These are substantial changes. Even so, the release testing for SQLite has become so extensive that the developers have high confidence that this release is stable and ready for production use.

### 2008-Dec-16 - Version 3.6.7

SQLite version 3.6.7 contains a major cleanup of the Unix driver, and support for the new Proxy Locking mechanism on MacOSX. Though the Unix driver is reorganized, its functionality is the same and so applications should not notice a difference.

### 2008-Nov-26 - Version 3.6.6.2

This release fixes a bug that was introduced into SQLite version 3.6.6 and which seems like it might be able to cause database corruption. This bug was detected during stress testing. It has not been seen in the wild. An analysis of the problem suggests that the bug might be able to cause database corruption, however focused efforts to find a real-world test cases that actually causes database corruption have so far been unsuccessful. Hence, the likelihood of this bug causing problems is low. Nevertheless, we have decided to do an emergency branch release out of an abundance of caution.

The version 3.6.6.2 release also fixes a obscure memory leak that can occur following a disk I/O error.

### 2008-Nov-22 - Version 3.6.6.1

This release fixes a bug that was introduced into SQLite version 3.6.4 and that can cause database corruption in obscure cases. This bug has never been seen in the wild; it was first detected by internal stress tests and required substantial analysis before it could be shown to potentially lead to corruption. So we feel that SQLite versions 3.6.4, 3.6.5, and 3.6.6 are safe to use for development work. But upgrading to this patch release or later is recommented prior to deploying products that incorporate SQLite.

We have taken the unusual step of issuing a patch release in order to get the fix for this bug into circulation quickly. SQLite version 3.6.7 will continue on its normal path of development with an anticipated release in mid December.

### 2008-Nov-19 - Version 3.6.6

SQLite version 3.6.5 is released. This is a quick turn-around release that fixes a bug in virtual tables and FTS3 that snuck into version 3.6.5. This release also adds the new application-defined page cache mechanism.

### 2008-Nov-12 - Version 3.6.5

SQLite version 3.6.5 is released. There are various minor feature enhancements and numerous obscure bug fixes. The change log contains the details. Upgrading is optional.

### 2008-Nov-01 - Bloomberg Joins SQLite Consortium

The SQLite developers are honored to announce that Bloomberg has joined the SQLite Consortium.

### 2008-Oct-15 - Version 3.6.4

SQLite version 3.6.4 adds new features designed to help applications detect when indices are not being used on query. There are also some important performance improvements. Upgrading is optional.

### 2008-Sep-22 - Version 3.6.3

SQLite version 3.6.3 fixes a bug in SELECT DISTINCT that was introduced by the previous version. No new features are added. Upgrading is recommended for all applications that make use of DISTINCT.

### 2008-Aug-30 - Version 3.6.2

SQLite version 3.6.2 contains rewrites of the page-cache subsystem and the procedures for matching identifiers to table columns in SQL statements. These changes are designed to better modularize the code and make it more maintainable and reliable moving forward. Nearly 5000 non-comment lines of core code (about 11.3%) have changed from the previous release. Nevertheless, there should be no application-visible changes, other than bug fixes.

### 2008-Aug-06 - Version 3.6.1

SQLite version 3.6.1 is a stabilization and performance enhancement release.

Old news...

This page last modified 2009/01/12 13:19:06 UTC