/ 
DBIO-SQLite-0.900000

Changes for version 0.900000 - 2026-06-23

  • First release. SQLite driver for DBIO with native deploy, introspect, diff and DDL generation -- no SQL::Translator.
  • Storage
    • DBIO::SQLite::Storage, autodetected for dbi:SQLite: DSNs via the driver registry; force-on multicolumn IN where supported
    • Savepoints, deferred foreign-key checks, and the foreign_keys PRAGMA via connect_call_use_foreign_keys
    • Native database backup; DateTime::Format::SQLite for inflation
    • DBIO::SQLite::SQLMaker (no SELECT ... FOR UPDATE on SQLite)
  • Deploy / DDL / Introspect / Diff
    • DBIO::SQLite::Deploy: install/diff/apply/upgrade via test-deploy-and-compare against an in-memory :memory: target
    • DBIO::SQLite::DDL: generate DDL from Result classes, with INTEGER PRIMARY KEY AUTOINCREMENT inline and CREATE VIEW output
    • DBIO::SQLite::Introspect: read schema via sqlite_master and PRAGMA (tables, columns, indexes, foreign keys)
    • DBIO::SQLite::Diff: table/column/index diffing with columns inlined on CREATE TABLE and drop-then-create on index changes
  • Result / shortcuts
    • DBIO::SQLite::Result component with sqlite_index declaration
    • use DBIO Schema => -sqlite shortcut to pin the SQLite storage
  • Misc
    • AccessBroker support for SQLite connections
    • Requires Perl 5.36+ and DBD::SQLite

Documentation

README.md

Modules

DBIO::SQLite
SQLite-specific schema management for DBIO
DBIO::SQLite::Adapter
SQLite base->native type resolver
DBIO::SQLite::DDL
Generate SQLite DDL from DBIO Result classes
DBIO::SQLite::Deploy
Deploy and upgrade SQLite schemas via test-deploy-and-compare
DBIO::SQLite::Diff
Compare two introspected SQLite models
DBIO::SQLite::Diff::Column
Diff operations for SQLite columns
DBIO::SQLite::Diff::Index
Diff operations for SQLite indexes
DBIO::SQLite::Diff::Rebuild
Diff operation that rebuilds a SQLite table
DBIO::SQLite::Diff::Table
Diff operations for SQLite tables
DBIO::SQLite::Introspect
Introspect a SQLite database via sqlite_master and PRAGMAs
DBIO::SQLite::Introspect::Columns
Introspect SQLite columns
DBIO::SQLite::Introspect::ForeignKeys
Introspect SQLite foreign keys
DBIO::SQLite::Introspect::Indexes
Introspect SQLite indexes
DBIO::SQLite::Introspect::Tables
Introspect SQLite tables and views
DBIO::SQLite::Result
SQLite-specific Result component for DBIO
DBIO::SQLite::SQLMaker
SQLite-specific SQL generation for DBIO
DBIO::SQLite::Storage
SQLite storage driver for DBIO
DBIO::SQLite::Test
SQLite-specific test utilities for DBIO
DBIO::SQLite::Util
Shared SQLite-specific helper functions for DBIO
DBIO::Shortcut::sqlite
`use DBIO -sqlite` shortcut for the SQLite driver

Other files