The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

Changes for version 1.31

  • Production release, identical to 1.30_06

Changes for version 1.30_06

  • Resolved # 60860: Slow but steady memory leak on last_insert_id calls (ISHIGAKI)
  • Moved DBD::SQLite::FTS3Transitional into a dedicated dist (DAMI)
  • Updated bundled Test::NoWarnings to 1.02 (ADAMK)
  • Slightly bumped Test::More and added Test::Builder dependencies, because they are inherited from the bundled Test::NoWarnings (ADAMK)
  • Upgraded ppport.h to the latest version (ADAMK)

Changes for version 1.30_05

  • Test::NoWarnings bundled in the "inc" directory was ignored in a new test. (ISHIGAKI)

Changes for version 1.30_04

  • Updated to SQLite 3.7.2 (DUNCAND)
  • Resolved #60698: "Test failures with SQLite 3.7", using included patch by Niko Tyni (ntyni@debian.org) of t/lib/Test.pm (DUNCAND)
  • Added support for FTS3 tokenizers written in Perl. Added tests and documentation on how to use FTS3. Changed compilation flag to use the recommanded -DSQLITE_ENABLE_FTS3_PARENTHESIS
    • MAY POSSIBLY BREAK OLD APPLICATIONS THAT ALREADY USED FTS3 *** (DAMI)
  • Fixed various backward compatibility issues back to SQLite 3.6.1 (ISHIGAKI)
  • Resolved #58332: Documentation error for preventing fsync (ISHIGAKI)

Changes for version 1.30_03

  • Updated to SQLite 3.6.23.1 (ISHIGAKI)
  • Resolved #56693: [PATCH] Fix spelling errors (patch by Ansgar Burchardt) (ISHIGAKI)
  • Added compile_options() to get compile options (ISHIGAKI)
  • Fixed punctuation; suggested by Father Chrysostomos (ISHIGAKI)
  • Ignore unknown collations, as they may be installed without using DBD::SQLite's api. This should help ICU plugin. (ISHIGAKI)

Changes for version 1.30_02

  • Implemented sqlite_use_immediate_transaction database handle attribute to avoid deadlocks easily (ISHIGAKI)
  • Resolved #55466: Problem with names in DB that using square bracers (ISHIGAKI)
  • Added SQLITE_ENABLE_LOCKING_STYLE=0 for Mac OSX to avoid compile error (ISHIGAKI)

Changes for version 1.30_01

  • CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
  • Resolved #54271: Inserting a string with utf-8 flag on corrupts BLOB data; now BLOB data is always stored as bytes (without the utf-8 flag) even if it has the flag set (ISHIGAKI)
  • Updated to SQLite 3.6.23 (DUNCAND)
  • Implemented NUM_OF_PARAMS statement handle attribute (ISHIGAKI)
  • Added experimental "sqlite_allow_multiple_statements" database handle attribute, and "sqlite_unprepared_statements" statement handle attribute, to allow processing a SQL dump. (ISHIGAKI)
  • Resolved #53579: Added a note and a test of placeholders. (ISHIGAKI)
  • Resolved #45113, which was actually an issue of dequoting primary key column names (ISHIGAKI)
  • You can now retrieve some of the statement handle attributes before you execute. (ISHIGAKI)
  • Added preamble to copy sqlite3.[hc] files into a share directory (where you can access via File::ShareDir) to allow extension authors to use the same C source/header as they used to build DBD::SQLite itself. (ISHIGAKI)

Documentation

The DBD::SQLite Cookbook

Modules

Self-contained RDBMS in a DBI Driver

Provides

in lib/DBD/SQLite.pm
in lib/DBD/SQLite.pm
in lib/DBD/SQLite.pm