Recent SQLite News

2020-12-01 - Release 3.34.0

SQLite version 3.34.0 is a routine maintenance release. This release adds incremental improvements to performance and features, including enhancements to the query planner, multiple recursive SELECTS in recursive common table expressions, and better error messages from CHECK constraint failures. See the change log for details.

2020-08-14 - Release 3.33.0

SQLite version 3.33.0 is a routine maintenance release. This release features added support for "UPDATE FROM" following the PostgreSQL syntax, and a doubling of the maximum database size to 281 TB, as well as many other improvements. See the change log for details.

2020-06-18 - Release 3.32.3

The 3.32.3 release is a patch release that contains fixes for various issues discovered by fuzzers. None of the issues fixed are likely to be encountered by applications that use SQLite in ordinary ways, though upgrading never hurts.

Map of all changes since the 3.32.0 release:

2020-06-04 - Release 3.32.2

The 3.32.2 release is a one-line change relative to 3.32.1 that fixes a long-standing bug in the COMMIT command. Since , if you were to retry a COMMIT command over and over after it returns , it might eventually report success, even though it was still blocked. This patch fixes the problem.

2020-05-25 - Release 3.32.1

published information about two SQLite bugs approximately 24 hours after the release of version 3.32.0. These bugs enable maliciously crafted SQL to crash the process that is running SQLite. Both bugs are long-standing problems that affect releases prior to 3.32.0. The 3.32.1 release fixes both problems.

2020-05-22 - Release 3.32.0

Version 3.32.0 is an ordinary maintenance release of SQLite. This release features the ability to run an to gather database statistics for use by the query planner, without having to scan every row of every index. See the for additional enhancements and improvements.

2020-01-27 - Release 3.31.1

Applications that use SQLite should only interface with SQLite through the officially published APIs. Applications should not depend upon or use the internal data structures of SQLite as those structures might change from one release to another. However, there is a popular application that does depend on the details of the internal layout of data in an internal SQLite data structure, and those details changed in version 3.31.0, breaking the application. This is, technically, a bug in the application, not in SQLite. But it is within the power of SQLite to fix it, by reverting the internal data structure change, and so that is what we have done for the 3.31.1 release.

2020-01-22 - Release 3.31.0

Version 3.31.0 is an ordinary maintenance release of SQLite. This release features the ability to define for tables as well as many other enhancements. See the for additional information.

2019-10-11 - Release 3.30.1

Version 3.30.1 is a bug-fix release that addresses a problem that can occur when an aggregate function in a nested query makes use of the new FILTER clause capability. Some addition patches for various obscure issues are also included, for completeness.

2019-10-04 - Release 3.30.0

Version 3.30.0 is a regularly scheduled maintenance release of SQLite containing miscellaneous performance and feature enhancements. This release adds support fo the NULLS FIRST and NULLS LAST clauses on ORDER BY statements and the addition of FILTER clauses on all aggregate functions. See the for details.

2019-07-10 - Release 3.29.0

Version 3.29.0 is a regularly scheduled maintenance release of SQLite containing miscellaneous performance and feature enhancements. See the for details.

Beginning with this release, the misfeature is deprecated. The misfeature is still enabled by default, for legacy compatibility, however developers are encouraged to disable it at compile-time using the option, or at run-time using the and actions to the interface. This is especially true for double-quoted string literals in CREATE TABLE and CREATE INDEX statements, as those elements can cause unexpected problems following an ALTER TABLE. See ticket for an example.

2019-04-16 - Release 3.28.0

Version 3.28.0 is a regularly scheduled maintenance release of SQLite containing miscellaneous performance and feature enhancements. See the for details.

This release fixes an obscure security issue. Applications using older versions of SQLite may be vulnerable if

  1. SQLite is compiled with certain optional extensions enabled, and
  2. the attacker is able to inject arbitrary SQL.
We are not aware of any applications that are vulnerable to this problem. On the other hand, we do not know about every application that uses SQLite. If your application allows unauthenticated users on the internet (and hence potential attackers) to run arbitrary SQL and if you build SQLite with any of the optional extensions enabled, then you should take this upgrade at your earliest opportunity.

For further information about improving SQLite's robustness in internet-facing applications, see the our .

2019-02-25 - Release 3.27.2

Version 3.27.2 is a patch release that fixes a two bugs and various documentation errors found in the version 3.27.1. The changes from version 3.27.1 and 3.27.0 are minimal.

2019-02-08 - Release 3.27.1

After release 3.27.0 was tagged, but before the build could be completed and uploaded, a in the query optimizer was reported via System.Data.SQLite. Since people will be upgrading anyhow, we decided publish the fix for this newly discovered problems right away. Hence, 3.27.1 was released less than 24 hours after 3.27.0.

It would have been better if the query optimizer bug had come to our attention one day earlier, so that we could have incorporated a fix into 3.27.0, but sometimes that's the way things go.

2019-02-07 - Release 3.27.0

SQLite is a routine maintenance release with various performance and feature enhancements. See the for details.

2018-12-01 - Release 3.26.0

SQLite is a routine maintenance release with various performance and feature enhancements. See the for details.

2018-11-05 - Release 3.25.3

SQLite is a third patch against 3.25.0 that fixes various problems that have come to light and which seem serious enough to justify a patch.

2018-09-25 - Release 3.25.2

SQLite is another patch against 3.25.0 that fixes still more problems associated with the new feature and the enhancements. Of particular note is the new command, which causes the ALTER TABLE RENAME command to behave in the same goofy way that it did before the enhancements found in version 3.25.0 → references to renamed tables that are inside the bodies of triggers and views are not updated. The legacy behavior is arguably a bug, but some programs depend on the older buggy behavior. The 3.25.2 release also contains a fix to processing for VIEWs. There also a slew of other minor fixes that affect obscure compile-time options. See the for details.

2018-09-18 - Release 3.25.1

SQLite is a patch against version 3.25.0 that contains two one-line fixes for bug that were introduced in version 3.25.0. See the change log for details. Upgrading from 3.25.0 is recommended.

2018-09-15 - Release 3.25.0

SQLite is a regularly scheduled maintenance release. Two big enhancements in this release:
  1. Support for was added, using the PostgreSQL documentation as the baseline.
  2. The command was enhanced to support renaming of columns, and so that column and table renames are propagated into trigger bodies and views.

In addition, there are various performance enhancements and minor fixes.

One bug of note is which describes a hard-to-reach condition where the ORDER BY LIMIT optimization might cause an infinite loop during query evaluation. This ticket raised a lot of concern on and , probably due to my choice of the ticket title. "Infinite Loop" sounds scary. But I argue that the bug isn't really all that bad in that it is very difficult to reach, will show up during testing (rather than magically appearing after a product is deployed), does not cause any data loss, and does not return an incorrect result. It was an important error, but not nearly as dire as many people interpreted it to be. And, in any event, it is fixed now.

2018-06-04 - Release 3.24.0

SQLite is a regularly scheduled maintenance release. Highlights of this release include support for PostgreSQL-style UPSERT and improved performance, especially for ORDER BY LIMIT queries.

2018-04-10 - Release 3.23.1

The release fixes a bug in the new added to version 3.23.0. A few other minor and obscure fixes were also inserted, as well as a small performance optimization. Code changes relative to version 3.23.0 are minimal.

2018-04-02 - Release 3.23.0

The release is a regularly scheduled maintenance release. See the for a list of enhancements and bug fixes.

2018-01-22 - Release 3.22.0

The release is a regularly scheduled maintenance release. There are many minor, though interesting, enhancements in this release. See the for details.

2017-10-24 - Release 3.21.0

The release is a regularly scheduled maintenance release. There are lots of enhancements in this release. See the for details.

2017-08-24 - Release 3.20.1

The patch release changes two lines of code in the interface in order to fix a rare memory leak. There are no other changes relative to .

2017-08-01 - Release 3.20.0

SQLite is a regularly scheduled maintenance release of SQLite.

This release contains many minor enhancements, including:

See the for more information.

2017-06-17 - Release 3.18.2

SQLite is another backport of a bug fix found in SQLite , specifically the fix for ticket . Changes against are minimal.

2017-06-16 - Release 3.18.1

SQLite is a bug-fix release against that fixes the corruption bug described in ticket . This release was created for users who need that bug fix but do not yet want to upgrade to .

2017-06-08 - Release 3.19.3

is an emergency patch release to fix a in logic that can lead to database corruption. The bug was introduced in (2017-01-02). Though the bug is obscure and rarely encountered, upgrading is recommended for all users, and especially for users who turn on .

2017-05-25 - Release 3.19.2

Still more problems have been found in the LEFT JOIN optimization that was added in the 3.19.0 release. This patch release fixes all known issues with that optimization and adds new test cases. Hopefully this will be the last patch.

2017-05-24 - Release 3.19.1

One of the new query planner optimizations in the 3.19.0 release contained bugs. The 3.19.1 patch release fixes them.

Beginning with 3.19.0, subqueries and views on the right-hand side of a LEFT JOIN operator could sometimes be into the main query. The new optimization worked well for all of the test cases that the developers devised, and for millions of legacy test cases, but once 3.19.0 was released, users found some other cases where the optimization failed. Ticket contains examples.

These problems exist only in 3.19.0. Users of SQLite 3.19.0 should upgrade, but users of all prior versions of SQLite are safe.

2017-05-22 - Release 3.19.0

SQLite is a regularly scheduled maintenance release.

The emphasis on this release is improvements to the query planner. There are also some obscure bug fixes. There is no reason to upgrade unless you are having problems with a prior release.

2017-03-30 - Release 3.18.0

SQLite is a regularly scheduled maintenance release.

This release features an initial implementation the "" command. This command can now be used to cause to be run on an as-needed basis. Applications should invoke "PRAGMA optimize" just before closing the . The "PRAGMA optimize" statement will likely be enhanced to do other kinds of automated database maintenance in future releases.

The version control system that is used to manage the SQLite project has been upgraded to use SHA3-256 hashes instead of SHA1. Therefore, the version identifications for SQLite now show a 64-hex-digit SHA3-256 hash rather than the 40-hex-digit SHA1 hash.

See the for other enhancements and optimizations in this release.

2017-02-13 - Release 3.17.0

SQLite is a regularly scheduled maintenance release.

Most of the changes in this release are performance optimizations. Optimizations to the are especially noticeable.

In this release, the default size of the allocated for each database connection is increased from 64,000 to 120,000 bytes. This provides improved performance on many common workloads in exchange for a small increase in memory usage. Applications that value a small memory footprint over raw speed can change the lookaside buffer size back to its old value (or to zero) using the compile-time option, or the start-time setting, or the run-time setting.

2017-01-06 - Release 3.16.2

One of the performance optimizations added in 3.16.0 caused triggers and foreign keys to malfunction for the statement on tables that lack secondary indexes. This patch release fixes the problem. See ticket for details.

2017-01-03 - Release 3.16.1

SQLite fixes a bug in the row-value logic for UPDATE statements inside of triggers. The bug has been there since row-values were added by release 3.15.0, but was not discovered until just a few minutes after the 3.16.0 release was published, and so it was not fixed by 3.16.0. This patch release is version 3.16.0 with the row-value bug fix.

2017-01-02 - Release 3.16.0

SQLite is a regularly schedule maintenance release.

This release includes many that collectively reduce the CPU cycle count by about 9%, add there have been important enhancements to the .

Support for is added, so that many pragma statements can be used as part of a larger SQL query. This is considered an experimental feature. We do not anticipate any changes to the interface, but will keep continue to call this interface "experimental" for a few release cycles in case unforeseen issues arise.

See the for other enhancements.

2016-11-28 - Release 3.15.2

SQLite is a bug-fix patch release that fixes several minor issues in the 3.15.0 and 3.15.1 releases.

2016-11-04 - Release 3.15.1

SQLite is a bug-fix patch release that fixes some minor issues in the 3.15.0 release.

2016-10-14 - Release 3.15.0

SQLite is a regularly scheduled maintenance release. The key feature in this release is the added support for . There are also other enhancements and fixes for a number of obscure bugs.

The 3.15.0 release uses about 7% fewer CPU cycles than 3.14.2. Most of the improvement in this release is in the SQL parser, query planner, and byte-code generator (the front-end) corresponding to the interface. Overall, version 3.15.0 uses about half as much CPU time as version 3.8.1 (2013-10-17). These performance measurements are made using the "speedtest1.c" workload on x64 compiled with gcc and -Os. Performance improvements may vary with different platforms and workloads.

2016-09-12 - Release 3.14.2

SQLite fixes several obscure bugs and adds improved support for building SQLite using the STDCALL calling convention on 32-bit windows systems. Upgrading from versions 3.14 and 3.14.1 is optional.

2016-08-11 - Release 3.14.1

SQLite adds a small patch to improve the performance of the pcache1TruncateUnsafe() routine for cases when the only a few pages on the end of the cache are being removed. This causes COMMITs to run faster when there is a very large page cache. Upgrading from version 3.14 is optional.

2016-08-08 - Release 3.14

SQLite (the "π" release) is a regularly scheduled maintenance release containing performance enhancements, new features, and fixes for obscure bugs.

2016-05-18 - Release 3.13.0

SQLite is a regularly schedule maintenance release containing performance enhancements and fixes for obscure bugs.

2016-04-18 - Release 3.12.2

Yikes! The 3.12.0 and 3.12.1 releases contain a backwards compatibility bug! Tables that declare a column with type "INTEGER" PRIMARY KEY (where the datatype name INTEGER is quoted) generate an incompatible database file. The mistake came about because the developers have never thought to put a typename in quotes before, and so there was no documentation of that capability nor any tests. (There are tests now, though, of course.) Instances of quoting the datatype name are probably infrequent in the wild, so we do not expect the impact of this bug to be too severe. Upgrading is still strongly recommended.

Fixes for three other minor issues were included in this patch release. The other issues would have normally been deferred until the next scheduled release, but since a patch release is being issued anyhow, they might as well be included.

2016-04-08 - Release 3.12.1

SQLite is an emergency patch release to address a that snuck into . Upgrading from version 3.12.0 is highly recommended.

Another minor problem involving datatypes on columns, and a query planner deficiency are fixed at the same time. These two issues did not justify a new release on their own, but since a release is being issued to deal with the crash bug, we included these other fixes for good measure.

2016-03-29 - Release 3.12.0

SQLite is a regularly scheduled maintenance release. A notable change in this release is an for newly created database files. There are also various performance improvements. See the for details.

2016-03-03 - Release 3.11.1

SQLite is a patch release that fixes problems in the new extension and increases a default setting in the extension, and implements enhancements to some of the Windows makefiles. The SQLite core is unchanged from 3.11.0. Upgrading is optional.

2016-02-15 - Release 3.11.0

SQLite is a regularly scheduled maintenance release.

2016-01-20 - Release 3.10.2

Yikes! An optimization attempt gone bad resulted in a which is fixed by this patch release. Three other minor but low-risk fixes are also included in the patch.

2016-01-14 - Release 3.10.1

SQLite is a bug-fix release primarily targeting the fix for the query planner bug discovered by Mapscape. Also included is a minor API enhancement requested by the Firefox developers at Mozilla. The differences from version 3.10.0 are minimal.

2016-01-06 - Release 3.10.0

SQLite is a regularly scheduled maintenance release.