/ 
DBIx-Fast-0.20

Changes for version 0.20 - 2026-10-06

  • Reads ~10-15% faster: own statement cache instead of DBI's (Perl) prepare_cached, and no per-call closure when no tracker is active
  • query() iterator: no warning when it outlives a closed connection
  • IN (?) with an arrayref expands to one placeholder per value
  • where(): WHERE clause from filters (undef skipped; IN, CONTAINS...)
  • page(): rows + total + pages, ORDER BY from a whitelist
  • like(): literal LIKE patterns (ESCAPE '!'); in_chunks() for long lists
  • count()/exists(): IN, NOT IN, CONTAINS, PREFIX, SUFFIX operators
  • upsert/upsert_many: update modes 'new', '+', { '+' => N }, \'SQL'
  • insert_ignore(); find_or_create() (race-safe via the UNIQUE index)
  • insert_many/upsert_many: chunk => N; insert_many: ignore => 1
  • timestamps => {...}: automatic created/updated columns per table
  • json_columns => {...}: encode on write, decode on read
  • Fix: rows after a write uses execute()'s count (DBD::Pg ON CONFLICT)

Documentation

CONTRIBUTING.md
README.md
SECURITY.md

Modules

DBIx::Fast
DBI fast & easy
DBIx::Fast::Base
Base class for DBIx::Fast components
DBIx::Fast::Cache
Query result cache with TTL and tag invalidation
DBIx::Fast::Cached
Query proxy that caches results
DBIx::Fast::Connector
DBIx::Fast connection manager fork safe
DBIx::Fast::Output
Unified output layer for the profiler subsystem
DBIx::Fast::Profile::Base
Abstract base class for database driver profiles
DBIx::Fast::Profile::MariaDB
MariaDB/MySQL profiling and diagnostics
DBIx::Fast::Profile::Pg
PostgreSQL profiling and diagnostics
DBIx::Fast::Profile::SQLite
SQLite profiling stub
DBIx::Fast::Profile::mysql
MySQL profiling and diagnostics
DBIx::Fast::Profiler
Query profiling and statistics for DBIx::Fast
DBIx::Fast::Result
Lightweight row iterator for query results
DBIx::Fast::SQL
Query and CRUD methods of DBIx::Fast
DBIx::Fast::Schema
Schema introspection for DBIx::Fast
DBIx::Fast::Transaction
Transaction management for DBIx::Fast
DBIx::Fast::X
Typed exceptions for DBIx::Fast

Examples

Other files