/ 
DBIO-SQLite-0.900001

Changes for version 0.900001 - 2026-07-12

  • Fixes
    • Fix DROP INDEX / DROP TABLE collision in full-schema sync (karr #14). When diff reconciled a live schema containing a table absent from the target (removed from the app's DBIO classes, or an unmanaged leftover), it emitted both DROP TABLE <t> and a later standalone DROP INDEX for one of that table's indexes; since SQLite's DROP TABLE already removes the table's own indexes, the standalone DROP INDEX died with "no such index" and aborted apply()/upgrade(). DBIO::SQLite::Diff::Index now receives the tables sections (threaded in by DBIO::SQLite::Diff) and suppresses a standalone DROP INDEX for any index whose owning table is itself being dropped in the same pass. Indexes of surviving tables are still dropped as before; the two-argument diff() call stays backward compatible (absent table sections => nothing suppressed)
    • t/01-access-broker-api.t referenced the never-released DBIO::AccessBroker::Credentials, which broke the test suite on fresh installs (the module only existed as a local dev leftover); switched to the released DBIO::AccessBroker::Static (Codeberg #1, reported by eserte)
    • t/populate_more.t: updated the load_components path after core renamed DBIO::Schema::PopulateMore to DBIO::PopulateMore
    • Removed the now-stale TODO markers from the two order_by hashref-condition cases in the SQLMaker suite: core's parameterization fix (bdd38a2ce) already made them pass, they were just surfacing as "TODO passed" noise
  • Dependencies
    • Requires core DBIO >= 0.900001 (family-wide version alignment)
  • Project
    • Added SECURITY.md (CPAN Security Group guidelines v1.5.0)

Documentation

README.md
SECURITY.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