Changes for version 0.900007 - 2026-11-17

  • Fixed
    • vacuum($file) on a libsqlite older than 3.27 throws an exception that names VACUUM INTO, the version it needs and the version present, before any statement is sent, instead of SQLite's bare 'near "INTO": syntax error'. A plain vacuum is unchanged.
    • Introspection and the primary key check read a PRAGMA that has no result columns (foreign_key_list of a table without keys, a PRAGMA the linked SQLite library does not know) as no rows on DBI 1.634 and older too, instead of dying in fetchall_arrayref.
  • Documentation
    • The dbio-sqlite skill lists every component (Result, Extension, JSON, Test::Conformance), the sqlite_extensions API, the always-declared capabilities supports_upsert_where and supports_exists_query, the deliberate transactional_ddl = 0, the -sqlite shortcut, the test variables and the capped-test run, and shows the SQLMaker override as the code has it, with the ON CONFLICT and INSERT OR clauses.
  • Tests
    • t/storage/txn_scope_guard.t skips its 'no warnings' assertion on Text::Balanced older than 2.06, whose broken overloading raises the intended warning.
    • t/14-vacuum.t compares the bind list in the form the trace shows it (bind values cut to 32 characters plus '...'), so long temp paths pass.
    • t/53lean_startup.t runs its probe program from a temporary script file, not as a multi-line -e argument, and starts it through IPC::Open3, which takes the command as a list on every platform; a list-form pipe open is not available to Perl before 5.22 on Windows.
    • t/debug/core.t closes the log file handle before removing the file, which Windows cannot do while it is open.
    • The declared deviation of the conformance case bind-numeric-exact also recognises the three-digit exponent (e+015) some Windows perls print; t/69-conformance-bind-fact.t pins both spellings.
    • t/53lean_startup.t reads the probe's output with the CR of a Windows line end removed, and the probe writes through a CRLF layer on every platform, so the Windows line end is exercised on Linux too.

Documentation

Modules

SQLite-specific schema management for DBIO
SQLite base->native type resolver
Generate SQLite DDL from DBIO Result classes
Deploy and upgrade SQLite schemas via test-deploy-and-compare
Compare two introspected SQLite models
Diff operations for SQLite columns
Diff operations for SQLite indexes
Diff operation that rebuilds a SQLite table
Diff operations for SQLite tables
Diff operations for SQLite views
The extension class of a SQLite extension without rules, and the driver's table of the family's classes
The extension class of SQLite's FTS5 full-text module
The extension class of SQLite's R*Tree module
Base of the extension classes of SQLite modules that keep shadow tables
Introspect a SQLite database via sqlite_master and PRAGMAs
Introspect SQLite columns
Introspect SQLite foreign keys
Introspect SQLite indexes
Introspect SQLite tables and views
Introspect SQLite triggers
JSON path expression helpers for DBIO::SQLite queries
SQLite JSON path-extraction operator object built by json()
SQLite-specific Result component for DBIO
SQLite-specific SQL generation for DBIO
SQLite storage driver for DBIO
SQLite-specific test utilities for DBIO
Answers the shared conformance case table for the SQLite driver
Shared SQLite-specific helper functions for DBIO
`use DBIO -sqlite` shortcut for the SQLite driver