Adam Kennedy

The final developer release of the current DBD::SQLite has been posted to CPAN.

http://search.cpan.org/~adamk/DBD-SQLite-1.36_04/

The new release upgrades SQLite from 3.7.9 to 3.7.12 and the upgrade of DBD::SQLite is in line with SQLite upgrade recommendations, and also driven by the move of Firefox to a newer file format than currently supported.

The new release contains a few changes that may cause trouble for your application and you should test, the biggest is the change in the default file format from version 1 to version 4 that landed in 3.7.10.

This means that SQLite files produced by DBD::SQLite will no longer be readable by older versions of SQLite unless you explicitly enable PRAGMA legacy_file_format=ON.

The second major change is the introduced of FTS4, a new full text search which replaces the older FTS3 (DBD::SQLite will ship with both FTS3 and FTS4 for some time, but you should migrate if possible, as FTS3 will be removed in a later release).

In addition to these two major changes (and a host of smaller improvements inherited from the newer SQLite releases) the new DBD::SQLite also improves support for both 64-bit platforms and for older Mac platforms.

As with all DBD::SQLite public releases in the current series, we are allowing several weeks for people to test the final dev release before doing a production release.

If you encounter any issues with the new version, please file a bug report in RT or contact the DBD::SQLite mailing list.