Skip to content

v2.0.0 - Universal PDO Bridge for 10 SGBD

Choose a tag to compare

@fordimalanda fordimalanda released this 21 Apr 21:02
· 16 commits to master since this release

Overview

BridgeSQL v2.0.0 is a major rewrite focused on performance, security, and true universal database compatibility. This version introduces a robust Driver Factory supporting 10 different database engines and implements modern PHP 8 features for automatic data typing.

Key Changes

  • Multi-SGBD Support: Integrated DSN factory for MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, Oracle, IBM DB2, Firebird, Informix, and Sybase.
  • Smart Type Detection: Automated PDO parameter binding using PHP 8 match expressions (supports Integer, Boolean, String, and Null).
  • Security Hardening: Disabled preparation emulation by default to ensure real data types and prevent advanced SQL injection vectors.
  • Improved API: Enhanced lastInsertId() to support sequence names, crucial for PostgreSQL and Oracle environments.
  • Enhanced Configuration: Added support for custom PDO attributes and options via the configuration array.

Supported Databases

  • MySQL / MariaDB
  • PostgreSQL
  • SQLite
  • Microsoft SQL Server
  • Oracle (OCI)
  • IBM DB2
  • Firebird
  • Informix
  • Sybase (SAP ASE)

Requirements

  • PHP 8.0 or higher.
  • Corresponding PDO drivers enabled for your specific database engine.

Documentation

Full documentation and implementation examples are available in the README.md and the /examples directory.