/ 
DBIO-DuckDB-0.900000

Changes for version 0.900000 - 2026-06-23

  • First release. DuckDB driver for DBIO built on the pure-FFI DBD::DuckDB.
  • Storage
    • DBIO::DuckDB schema component; autodetects dbi:DuckDB: DSNs and forces +DBIO::DuckDB::Storage
    • DBIO::DuckDB::Storage on DBIO::Storage::DBI: double-quoted identifiers, INSERT ... RETURNING, savepoints
    • `-du` shortcut (use DBIO Schema => -du) via DBIO::Shortcut::du
  • SQLMaker
    • DBIO::DuckDB::SQLMaker: PostgreSQL-flavored dialect, disables SELECT ... FOR UPDATE
  • DDL / Deploy
    • DBIO::DuckDB::DDL generates DuckDB DDL from Result classes via a single-source emitter (DBIO::DuckDB::DDL::Emit)
    • emits CREATE VIEW for non-virtual views (from view_definition), after all tables
    • DBIO::DuckDB::Deploy installs and upgrades schemas via native test-deploy-and-compare
  • Introspect / Diff
    • DBIO::DuckDB::Introspect reads information_schema and duckdb_* views (tables, columns, indexes, foreign keys)
    • DBIO::DuckDB::Diff compares two introspected models (tables, columns, indexes)
  • DuckDB specials
    • Arrow-fetch and Appender escape hatches for columnar / bulk paths
    • read_csv / read_parquet / read_json table-function helpers
    • extension install, checkpoint, version helpers
    • Quack client-server RPC (libduckdb >= 1.5): quack_serve, quack_attach, quack_detach, plus on-connect attach hook
  • Tests
    • TAP suite: 00-load, 08-shortcut, 10-smoke, 20-introspect, 21-introspect-contract, 30-deploy, 35-ddl-emit, 40-diff, 50-arrow, 60-quack

Documentation

README.md

Modules

DBIO::DuckDB
DuckDB-specific schema management for DBIO
DBIO::DuckDB::DDL
Generate DuckDB DDL from DBIO Result classes
DBIO::DuckDB::DDL::Emit
Single source of DuckDB DDL statement shape
DBIO::DuckDB::Deploy
Deploy and upgrade DuckDB schemas via test-deploy-and-compare
DBIO::DuckDB::Diff
Compare two introspected DuckDB models
DBIO::DuckDB::Diff::Column
Diff operations for DuckDB columns
DBIO::DuckDB::Diff::Index
Diff operations for DuckDB indexes
DBIO::DuckDB::Diff::Table
Diff operations for DuckDB tables
DBIO::DuckDB::Introspect
Introspect a DuckDB database via information_schema + duckdb_* views
DBIO::DuckDB::Introspect::Columns
Introspect DuckDB columns
DBIO::DuckDB::Introspect::ForeignKeys
Introspect DuckDB foreign keys
DBIO::DuckDB::Introspect::Indexes
Introspect DuckDB indexes
DBIO::DuckDB::Introspect::Tables
Introspect DuckDB tables and views
DBIO::DuckDB::SQLMaker
DuckDB-specific SQL generation for DBIO
DBIO::DuckDB::Storage
DuckDB storage driver for DBIO
DBIO::DuckDB::Test
DuckDB-specific test utilities for DBIO
DBIO::Shortcut::du
`use DBIO -du` shortcut for the DuckDB driver

Other files