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

Changes for version 1.50 - 2016-02-11

  • Switched to a production version.

Changes for version 1.49_08 - 2016-01-30

  • no significant code changes
  • Resolved RT#111558: Virtual table tests depend on enhanced query syntax availability (vlmarek++)
  • Ingore FTS tests if FTS is not available

Changes for version 1.49_07 - 2016-01-21

  • Updated to SQLite 3.10.2, which fixed a case-folding bug in the LIKE operator introduced in SQLite 3.10.0.

Changes for version 1.49_06 - 2016-01-15

  • Updated to SQLite 3.10.1, which fixed an old bug that could generate incorrect results when a scalar subquery attempts to use the block sorting optimization.

Changes for version 1.49_05 - 2016-01-11

  • CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
  • Updated to SQLite 3.10.0. Because of the addition of LIKE/GLOB/REGEXP support on virtual tables, previous ::PerlData virtual table got broken. This is hopefully fixed by adding strlike/strglob functions to DBD::SQLite but if you use this virtual table, please test it carefully.
  • Now you can make a database connection read-only if you turn on the ReadOnly attribute when you connect. (RT #110439) If you set it after you connect to a database, DBD::SQLite warns because the database doesn't actually become read-only.
  • Improved ::Constants
    • to load DBD::SQLite by itself
    • to expose SQLITE_VERSION_NUMBER
    • introduced a few new (shorter) tags

Changes for version 1.49_04 - 2015-11-24

  • Updated ::Constants
  • Fixed a sqlite version number in a test (GH-14; NANIS++)

Changes for version 1.49_03 - 2015-11-05

  • Updated to SQLite 3.9.2, with JSON support

Changes for version 1.49_02 - 2015-10-10

  • Added a workaround to resolve #106950 Extra warnings with savepoints (hopefully)
  • Not to run tests for table_column_metadata unless ENABLE_COLUMN_METADATA is set

Changes for version 1.49_01 - 2015-08-04

  • Updated to SQLite 3.8.11.1
  • Resolved #106151 SAVEPOINT bug
  • Made sure to keep what's left in unprepared_statements when allow_multiple_statements is set. (GH #11)

Documentation

The DBD::SQLite Cookbook
Using fulltext searches with DBD::SQLite

Modules

Self-contained RDBMS in a DBI Driver
SQLite virtual tables implemented in Perl
virtual table for viewing file contents
virtual table hooked to Perl data

Provides

in lib/DBD/SQLite/VirtualTable.pm
in lib/DBD/SQLite/VirtualTable/FileContent.pm
in lib/DBD/SQLite/VirtualTable/PerlData.pm