Today the next major version of SQLite was released, and below the dashed line
is a copy of D. Richard Hipp's release announcement.
I have committed that version into the DBD::SQLite Subversion repository, so
when you svn-up you should have that version.
From my own testing, the simple substitution of 3.7.0 for the previous 22.214.171.124
broke a couple of our tests:
t/08_busy.t (Wstat: 512 Tests: 23 Failed: 2)
Failed tests: 11, 22
Non-zero exit status: 2
t/28_schemachange.t (Wstat: 512 Tests: 9 Failed: 2)
Failed tests: 7-8
Non-zero exit status: 2
... and these cite 'disk I/O error' as the problem.
I did not debug the problem aside from that I tested both with the Subversion
head plus the latest CPAN release 1.30_03; for both, the above 2 errors occur
with 3.7.0 and not with the prior SQLite version.
Separately, Subversion head had a few other failures in "make test" on my system
while the pristine 1.30_03 had no errors; those would just be related to
Given the major changes in 3.7.0, I recommend cutting a new CPAN developer
release 1.30_04 as soon as all the tests pass.
For my part, I can at least try testing on another system or 2 in case for some
reason the new failures are specific to my first machine, though if anyone else
can reproduce the above test failures then that won't be necessary.
-- Darren Duncan
SQLite version 3.7.0 is now available on the website
The most important change in version 3.7.0 is that SQLite now supports
write-ahead logs as an optional method for transaction control, for improved
performance and concurrency. Additional information can be found here:
We are actually already using the write-ahead logging feature on the SQLite
website itself, in the Fossil DVCS that tracks all changes to the SQLite source
tree. (Yes, the SQLite write-ahead log code is stored in an SQLite write-ahead
log database - how's that for recursion!)
The added concurrency of the write-ahead log journaling mode allows multiple
users to be doing extended read operations, such as checking out historical
versions of the SQLite code or looking at extended timelines simultaneously with
developers making new checkins, adding or editing tickets, or actually
rebuilding the entire 10-year source code database. The write-ahead log code
has performed very well so far for us.
Version 3.7.0 also marks the official cut-over to our new SQLite logo and a new
color scheme for the website. We hope you like the new look.
The 114-day time span since the previous release (version 126.96.36.199) is the
longest span between consecutive releases in the 10-year history of SQLite.
Much of that time was spent testing and stressing the new write-ahead log
feature. This is probably the most thoroughly tested release of SQLite that we
have every produced. And so even though the write-ahead logging feature is
entirely new, we are very hopeful that the 3.7.0 release will prove to be stable
and robust and ready for production use.
Of course, if you do happen to run into problems, please let me know at once.
D. Richard Hipp