Changes for version 1.43_08 - 2014-08-21

  • Updated to SQLite 3.8.6, which should fix a unique index issue: see for details (ISHIGAKI)

Changes for version 1.43_07 - 2014-07-30

  • Resolved #97598: Crash on disconnect with virtual tables (FTS4) (patch and test code by Rob++) (ISHIGAKI)

Changes for version 1.43_06 - 2014-07-22

  • Fixed compile error/warning for older perls (reported by ribasushi) (ISHIGAKI)

Changes for version 1.43_05 - 2014-07-21

  • No significant code changes; removed unnecessary dependencies.

Changes for version 1.43_04 - 2014-07-21

  • Resolved #96877: sql statements should be converted to utf8 (DAMI) If you set sqlite_unicode to true, SQL statements will be upgraded to avoid inconsistency between embedded params and bind params.
  • Resolved #96494: [PATCH] add SYSTEM TABLE to table_info() type list (MJP)
  • Supported virtual tables in Perl, and added two sample tables (DAMI++)

Changes for version 1.43_03 - 2014-06-12

  • Updated to SQLite 3.8.5, which should fix query planner's issues in SQLite (ISHIGAKI)
  • Fixed busy_timeout to accept 0 to disable (reported by zdm) (ISHIGAKI)
  • Resolved #95511: primary_key_info fails to return names for named primary keys (Kenneth Kroenlein)
  • Resolved #96050: Segfault in disconnected sqlite_db_filename (reported by Alex Vandiver) (ISHIGAKI)

Changes for version 1.43_02 - 2014-03-26

  • Limited -std=gnu99 to solaris gcc only, though it may be harmless in many cases (mattp++) (ISHIGAKI)

Changes for version 1.43_01 - 2014-03-26

  • Added -std=gnu99 for solaris gcc users (reported by mattp++) (ISHIGAKI)


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


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


in lib/DBD/SQLite/
in lib/DBD/SQLite/VirtualTable/
in lib/DBD/SQLite/VirtualTable/
in lib/DBD/
in lib/DBD/
in lib/DBD/