Skip to content

v2.0.1 - Logging System & License Update

Choose a tag to compare

@fordimalanda fordimalanda released this 13 May 07:01
· 10 commits to master since this release

BridgeSQL v2.0.1 introduces a comprehensive debugging suite and a transition to the FomaDev Public License (FPL). This release focuses on developer experience by providing deep visibility into query execution and performance metrics.

New Features

  • Query Logging System: Added getDebugLog() to retrieve a full history of SQL executions, including execution duration (ms) and precise timestamps.
  • Live Query Inspection: Added getLastQuery() to access the most recent statement with interpolated parameters for immediate debugging.
  • SQL Interpolator: Implementation of an internal logic to reconstruct prepared statements, allowing developers to see final SQL strings before execution.

Licensing Update

  • Transition to FPL: The project has migrated from MIT to the FomaDev Public License (FPL).
  • Commercial Protection: Commercial redistribution or the creation of derivative database tools now requires a paid license from FomaDev.
  • Community Collaboration: Personal and educational use remains free, with a mandatory requirement for contributions to be submitted via Pull Requests to the official repository.

Enhancements

  • Added micro-benchmarking to the query execution flow to identify performance bottlenecks.
  • Updated documentation including a new CONTRIBUTING.md aligned with FPL requirements.
  • Standardized internal parameter binding to improve stability across different DBMS drivers.

Requirements

  • PHP 8.0 or higher.
  • Compatible with all 10 supported DBMS (MySQL, PostgreSQL, SQLite, etc.).

Contributors

@fordimalanda