SQLite 3.7.0 adds Write-Ahead Logging
The SQLite development team has announced the arrival of version 3.7.0 of its embedded relational SQL database management system. According to the developers, compared to the previous 126.96.36.199 update from March, the major new release includes a number of bug fixes and features performance improvements.
SQLite 3.7.0 features several query planner enhancements and a new transaction control mechanism that uses a Write-Ahead Log, also known as a WAL, instead of a rollback journal. Advantages to WAL include significantly faster performance in most situations, more concurrency, and more sequential disk I/O operations. The developers note that the traditional rollback-journal is still used by default, "so there should be no visible change for legacy programs". All users are encouraged to upgrade to the latest release.
SQLite is developed and maintained by the SQLite Consortium, who's members include Mozilla, Adobe, Oracle and Adobe. The embedded SQL database is used in a number of well-known applications, such as Adobe's Lightroom, Apple's Mac OS X operating system and Mozilla's Firefox and Thunderbird.
More details on the release can be found in the release log. SQLite 3.7.0 is available to download from the project's site and documentation is provided. SQLite source code is in the public domain, so it can be freely used for any commercial or private purpose, although it is possible to purchase a licence for those jurisdictions that do not recognise public domain.