v2.0.2 - Native & Secure Transaction Management

Overview

BridgeSQL v2.0.2 introduces native and secure support for ACID transactions, allowing developers to execute complex multi-step operations safely. This release guards against overlapping transaction states and integrates transaction lifecycles directly into the debugging timeline.

New Features

• Secure Transaction Controls: Added beginTransaction(), commit(), and rollBack() methods mapped safely to the underlying PDO link.
• State Conflict Prevention: Added internal inTransaction() health checks to prevent fatal PDO runtime exceptions when a transaction is already active or missing.
• Debug Timeline Integration: Transaction operations (-- BEGIN TRANSACTION --, -- COMMIT --, -- ROLLBACK --) are now recorded sequentially inside getDebugLog() with precise timestamps.

Enhancements

• SQL Interpolation Fix: Refactored interpolateQuery() to handle special character parameters safely using preg_quote.
• API Exposure: Added getPdo() to allow direct access to the raw PDO instance for edge-case customization.

Requirements

• PHP 8.0 or higher.
• Under the FomaDev Public License (FPL).

Contributors

@fordimalanda