/ 
DBIO-PostgreSQL-0.900000

Changes for version 0.900000 - 2026-06-23

  • First release. The PostgreSQL driver for DBIO: PostgreSQL-native storage, SQL generation, schema introspection, diff, DDL and desired-state deployment.
  • Storage
    • DBIO::PostgreSQL::Storage, registered for dbi:Pg: DSNs and autodetected by core via the driver registry
    • Loadable as a schema component (load_components('PostgreSQL')) or via the use DBIO Schema => -pg shortcut, which pins +DBIO::PostgreSQL::Storage as the storage type
    • RETURNING on INSERT/UPDATE/DELETE, last_insert_id via sequences, AccessBroker connect support
    • DBIO::PostgreSQL::Result component and the -pg Result shortcut for PostgreSQL-native column/source features (schemas, indexes)
  • SQL Generation
    • DBIO::PostgreSQL::SQLMaker with native JSONB operators: @> / <@ containment (auto-serializes hashref/arrayref to JSON), @? / @@ JSONPath (PG 12+), and ? / ?| / ?& key existence (rewritten as jsonb_exists*() to avoid the DBI placeholder clash)
    • DBIO::PostgreSQL::JSONB jsonb() path-expression DSL: eq/ne/lt/le/gt/ge/like/ilike/is_null/is_not_null/as_order
  • Introspection
    • DBIO::PostgreSQL::Introspect builds a live model from pg_catalog: schemas, tables, columns, indexes, sequences, foreign keys, check constraints, functions, triggers, types/enums, extensions and row-level-security policies
  • Diff and DDL
    • DBIO::PostgreSQL::Diff compares two introspected models per object class (Schema/Table/Column/Index/Type/Function/Trigger/ Policy/Extension) and emits the ALTER/CREATE/DROP statements
    • DBIO::PostgreSQL::DDL generates PostgreSQL-native DDL from the schema, including a CREATE TYPE enum pre-pass, schema-qualified CREATE VIEW for non-virtual views, and physical-table dedupe
  • Deploy
    • DBIO::PostgreSQL::Deploy orchestrates test-deploy-and-compare: introspect live, deploy desired to a temporary schema, re-introspect, diff, then drop the temp schema; supports install, diff, apply and upgrade
    • Storage declares dbio_deploy_class so DBIO::Schema->deploy() routes through DBIO::PostgreSQL::Deploy rather than SQL::Translator

Documentation

README.md

Modules

DBIO::PostgreSQL
PostgreSQL-specific schema management for DBIO
DBIO::PostgreSQL::Adapter
PostgreSQL base->native type resolver
DBIO::PostgreSQL::DDL
Generate PostgreSQL DDL from DBIO schema classes
DBIO::PostgreSQL::Deploy
Deploy and upgrade PostgreSQL schemas via test-deploy-and-compare
DBIO::PostgreSQL::Diff
Compare two introspected PostgreSQL models
DBIO::PostgreSQL::Diff::Column
Diff operations for PostgreSQL columns
DBIO::PostgreSQL::Diff::Extension
Diff operations for PostgreSQL extensions
DBIO::PostgreSQL::Diff::Function
Diff operations for PostgreSQL functions
DBIO::PostgreSQL::Diff::Index
Diff operations for PostgreSQL indexes
DBIO::PostgreSQL::Diff::Policy
Diff operations for PostgreSQL Row Level Security policies
DBIO::PostgreSQL::Diff::Schema
Diff operations for PostgreSQL schemas
DBIO::PostgreSQL::Diff::Table
Diff operations for PostgreSQL tables
DBIO::PostgreSQL::Diff::Trigger
Diff operations for PostgreSQL triggers
DBIO::PostgreSQL::Diff::Type
Diff operations for PostgreSQL types (enums, composites, ranges)
DBIO::PostgreSQL::Introspect
Introspect a PostgreSQL database via pg_catalog
DBIO::PostgreSQL::Introspect::CheckConstraints
Introspect PostgreSQL CHECK constraints
DBIO::PostgreSQL::Introspect::Columns
Introspect PostgreSQL table columns
DBIO::PostgreSQL::Introspect::Extensions
Introspect PostgreSQL extensions
DBIO::PostgreSQL::Introspect::ForeignKeys
Introspect PostgreSQL foreign keys
DBIO::PostgreSQL::Introspect::Functions
Introspect PostgreSQL functions
DBIO::PostgreSQL::Introspect::Indexes
Introspect PostgreSQL indexes
DBIO::PostgreSQL::Introspect::Normalize
Pure normalization helpers for PostgreSQL introspected metadata
DBIO::PostgreSQL::Introspect::Parse
Pure parsers for raw PostgreSQL metadata strings
DBIO::PostgreSQL::Introspect::Policies
Introspect PostgreSQL Row Level Security policies
DBIO::PostgreSQL::Introspect::Schemas
Introspect PostgreSQL schemas (namespaces)
DBIO::PostgreSQL::Introspect::Sequences
Introspect PostgreSQL sequences
DBIO::PostgreSQL::Introspect::Tables
Introspect PostgreSQL tables
DBIO::PostgreSQL::Introspect::Triggers
Introspect PostgreSQL triggers
DBIO::PostgreSQL::Introspect::Types
Introspect PostgreSQL types (enums, composites, ranges)
DBIO::PostgreSQL::JSONB
JSONB path expression helpers for DBIO::PostgreSQL queries
DBIO::PostgreSQL::JSONB::Op
JSONB path-extraction operator object built by jsonb()
DBIO::PostgreSQL::PgSchema
Base class for PostgreSQL schema namespaces
DBIO::PostgreSQL::Result
PostgreSQL-specific Result component for DBIO
DBIO::PostgreSQL::SQLMaker
PostgreSQL-specific SQL generation for DBIO
DBIO::PostgreSQL::Storage
PostgreSQL storage layer for DBIO
DBIO::PostgreSQL::Test::EventTZPg
Test result class for PostgreSQL timezone-aware datetime inflation
DBIO::PostgreSQL::Test::SequenceTest
Test result class for PostgreSQL sequence tests
DBIO::Shortcut::pg
`use DBIO -pg` shortcut for the PostgreSQL driver

Other files