Skip to content

v2.11.0

Choose a tag to compare

View all tags
@tommyknocker tommyknocker released this 28 Nov 18:14
· 78 commits to master since this release
v2.11.0
d39940a

🚀 Release v2.11.0 - Oracle Database Support & Major Enhancements

Release Date: November 28, 2025

This release introduces full Oracle Database support along with significant improvements to the CLI tools, environment configuration, and overall code quality.

🎉 Major Features

🗄️ Oracle Database Support

Complete Oracle Database (OCI driver) implementation with:

  • Full query builder support for all Oracle features
  • Oracle-specific data types and functions
  • CLOB handling for large text fields
  • Support for recursive CTEs, window functions, and advanced Oracle features
  • normalize_row_keys option for automatic column name normalization
  • Comprehensive examples and test coverage
  • CI integration in GitHub Actions

🔧 New Methods & Features

  • PdoDb::fromEnv() - Unified .env file support for easy database connection
  • PHP Extension Validation - Automatic validation with helpful error messages
  • Connection Management CLI - New pdodb connection commands
  • Database Seeds - New pdodb seed functionality
  • Enhanced Dump Command - Compression, auto-naming, and backup rotation
  • Table Management - New count and sample commands

📊 Test Coverage

Extended test coverage to 74%+ with comprehensive tests for:

  • All CLI commands
  • DDL builders for all dialects
  • Code generators (Repository, Service, Migration)
  • Cache and connection management
  • Edge cases and error handling

🔄 Improvements

Oracle Compatibility

  • Improved support for TRUE/FALSE, CAST, GREATEST, LEAST functions
  • Enhanced REGEXP_MATCH, COALESCE, and NULLIF support
  • Better CLOB handling in various operations
  • Cursor pagination support
  • Improved date handling in INSERT ALL statements

Code Quality

  • Removed dialect-specific logic from general classes
  • Moved dialect-specific logic to dialect implementations
  • Improved code organization and maintainability

🐛 Bug Fixes

  • Fixed Oracle CI in GitHub Actions (Instant Client installation, extension compilation)
  • Fixed Oracle CLI examples (environment variable propagation)
  • Fixed Oracle examples (recursive CTEs, window functions, JSON basics)
  • Fixed Memcached adapter creation
  • Fixed foreign key constraint handling in DDL examples
  • Fixed PHPStan errors

📚 Documentation

  • Added Oracle Database installation instructions
  • Fixed all documentation links
  • Created bidirectional links between documentation and examples
  • Updated README.md for better readability
  • Added bash completion installation instructions

🔗 Links

📦 Installation

composer require tommyknocker/pdo-database-class:^2.11.0

⚡ Migration Guide

No breaking changes! This is a backward-compatible release. You can safely update from v2.10.x.

For Oracle support, make sure you have:

Thank you for using PDOdb! 🎊

Assets 2
Loading