All,

I am pleased to announce that DBD::SQLite (Self Contained RDBMS in a Perl DBI
Driver) version 1.26_06 has been released on CPAN (by Adam Kennedy).

   http://search.cpan.org/~adamk/DBD-SQLite-1.26_06/

TESTING NEEDED!

Please bash the hell out of the latest DBD::SQLite and report any outstanding
bugs on RT.  Test your dependent or compatible projects with it, which includes
any DBMS-wrapping or object persistence modules, and applications.

This developer release includes both several changes which *might break your 
applications* if not accounted for, and it has a lot of code refactoring.

This release should also fix the known problem with full-text search (FTS3) that 
was reported in the 1.26_05 release but had existed in many prior versions; the 
included test for that problem now passes.

 From the Changes file:

     *** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
     - Removed undocumented (and most probably unused) reset method
       from a statement handle (which was only accessible via func().)
       Simply use "$sth-> finish" instead. (ISHIGAKI)
     - Now DBD::SQLite supports foreign key constraints by default.
       Long-ignored foreign keys (typically written for other DB
       engines) will start working. If you don't want this feature,
       issue a pragma to disable foreign keys. (ISHIGAKI)
     - Renamed "unicode" attribute to "sqlite_unicode" for integrity.
       Old "unicode" attribute is still accessible but will be
       deprecated in the near future. (ISHIGAKI)

     - You can see file/line info while tracing even if you compile
       with a non-gcc compiler. (ISHIGAKI)
     - Major code refactoring. (ISHIGAKI)
     - Pod reorganized, and some of the missing bits (including
       pragma) are added. (ISHIGAKI)

The bundled SQLite version (3.6.19) is unchanged from last time.

If you want in to DBD::SQLite development, then join the following email/IRC
forums which MST created (the mailing list, I am administrating):

   http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbd-sqlite

   #dbd-sqlite on irc.perl.org

And the canonical version control is at:

   http://svn.ali.as/cpan/trunk/DBD-SQLite/

Patches welcome.  Ideas welcome.  Testing welcome.  Whining is also welcome!

If you feel that a bug you find is in SQLite itself rather than the Perl DBI
driver for it, the main users email forum for SQLite in general is at:

   http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

... where you can report it as an appropriate list post (the SQLite issue
tracking system is no longer updateable by the public; posting in the list can
cause an update there by a registered SQLite developer).

Please do not reply to me directly with your responses.  Instead send them to
the forums or file with RT as is appropriate.

Thank you. -- Darren Duncan