/ 
DBIO-MySQL-0.900000

Changes for version 0.900000 - 2026-06-23

  • First release. MySQL and MariaDB driver for DBIO, with native schema deployment, introspection, diffing and DDL generation.
  • Driver
    • MySQL/MariaDB storage with autodetection of dbi:mysql: DSNs via the DBIO driver registry
    • DBIO::MySQL schema component and -mysql shortcut
    • DBIO::MySQL::Storage and DBIO::MySQL::Storage::MariaDB
    • DateTime::Format::MySQL datetime parsing
  • SQLMaker
    • DBIO::MySQL::SQLMaker with apply_limit() (LIMIT ?, ? syntax) and FOR SHARE locking
    • DBIO::MySQL::SQLMaker::MariaDB maps FOR SHARE to LOCK IN SHARE MODE for MariaDB
  • Schema management
    • DBIO::MySQL::Introspect (Tables, Columns, Indexes, ForeignKeys) via information_schema
    • DBIO::MySQL::DDL generator from Result classes with ENGINE/CHARSET/COLLATE handling, view and shared-table handling
    • DBIO::MySQL::Diff (Table, Column, Index, ForeignKey) with inlined columns on CREATE TABLE and full MODIFY COLUMN support
    • DBIO::MySQL::Deploy: install/diff/apply/upgrade via test-deploy- and-compare against a temporary database
    • Storage routes DBIO::Schema->deploy() through DBIO::MySQL::Deploy
  • Result component
    • DBIO::MySQL::Result with mysql_engine, mysql_charset, mysql_collate and mysql_index declarations consumed by the DDL generator

Documentation

README.md

Modules

DBIO::MySQL
MySQL-specific schema management for DBIO
DBIO::MySQL::Adapter
MySQL base->native type resolver
DBIO::MySQL::DDL
Generate MySQL/MariaDB DDL from DBIO Result classes
DBIO::MySQL::Deploy
Deploy and upgrade MySQL/MariaDB schemas via test-deploy-and-compare
DBIO::MySQL::Diff
Compare two introspected MySQL/MariaDB models
DBIO::MySQL::Diff::Column
Diff operations for MySQL/MariaDB columns
DBIO::MySQL::Diff::ForeignKey
Diff operations for MySQL/MariaDB foreign keys
DBIO::MySQL::Diff::Index
Diff operations for MySQL/MariaDB indexes
DBIO::MySQL::Diff::Table
Diff operations for MySQL/MariaDB tables
DBIO::MySQL::Introspect
Introspect a MySQL/MariaDB database via information_schema
DBIO::MySQL::Introspect::Columns
Introspect MySQL/MariaDB columns
DBIO::MySQL::Introspect::ForeignKeys
Introspect MySQL/MariaDB foreign keys
DBIO::MySQL::Introspect::Indexes
Introspect MySQL/MariaDB indexes
DBIO::MySQL::Introspect::Tables
Introspect MySQL/MariaDB tables and views
DBIO::MySQL::Introspect::Util
Shared helpers for the MySQL/MariaDB introspect submodules
DBIO::MySQL::MariaDB
MariaDB-specific schema management for DBIO
DBIO::MySQL::Result
MySQL/MariaDB-specific Result component for DBIO
DBIO::MySQL::SQLMaker
MySQL-specific SQL generation for DBIO
DBIO::MySQL::SQLMaker::MariaDB
SQLMaker subclass for MariaDB's SQL syntax quirks
DBIO::MySQL::Storage
MySQL storage layer for DBIO
DBIO::MySQL::Storage::MariaDB
MariaDB-specific storage for DBIO
DBIO::MySQL::Test::EventTZ
Test result class for MySQL/MariaDB timezone-aware datetime inflation
DBIO::MySQL::Test::EventTZDeprecated
Test result class using deprecated extra => { timezone => ... } syntax
DBIO::Shortcut::mysql
`use DBIO -mysql` shortcut for the MySQL driver

Other files