NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
Packagist
Packagist, #3368 most downloaded on Packagist
A PDO extension that provides lazy connections, array quoting, query profiling, value binding, and convenience methods for common fetch styles. Because it extends PDO, existing code that uses PDO can use this without any changes to the existing code.
Latest stable
6.1.0
Last release 1 months ago
29 Sep 2026
Release timing varies
gaps range from 2 weeks to 3.3 years
Nearly every release is documented
notes for 31 of 31 stable releases
Nothing withdrawn
no release was ever pulled
14 years old
35 releases · first in 2012
Drag across the ruler to compare, or tap a release to open it.
Add ExtendedPdo::reconnect() to drop the current connection and connect again, re-running the connection-time queries (fixes #179). Reconnection is ne
ExtendedPdo::reconnect() to drop the current connection and connect again, re-running the connection-time queries (fixes #179). Reconnection is never automatic; see the docs for the recommended catch-then-reconnect pattern. By @harikt in https://github.com/auraphp/Aura.Sql/pull/254Fix array placeholder skipped after a :: type cast following a string literal (fixes #177), and add a regression test confirming the parser never quot
:: type cast following a string literal (fixes #177), and add a regression test confirming the parser never quotes expressions such as @@session.time_zone (#181) by @harikt in https://github.com/auraphp/Aura.Sql/pull/250$password as #[\SensitiveParameter] in DecoratedPdo::connect(), ExtendedPdo::__construct() and ExtendedPdo::connect() so it is redacted from exception backtraces by @koriym in https://github.com/auraphp/Aura.Sql/pull/252Your coding agent can read these notes before it upgrades. Set up the MCP server →
Update README.md, continuous-integration.yml, scrutinizer.yml, code coverage by @harikt in https://github.com/auraphp/Aura.Sql/pull/237, https://githu
Full Changelog: https://github.com/auraphp/Aura.Sql/compare/6.0.0...6.0.1
CHG: BC Break ExtendedPdo::connect renamed to ExtendedPdo::lazyConnect
Full Changelog: https://github.com/auraphp/Aura.Sql/compare/5.0.2...6.0.0
CHG: BC Break ExtendedPdo::connect renamed to ExtendedPdo::lazyConnect
ExtendedPdo::connect renamed to ExtendedPdo::lazyConnectFull Changelog: https://github.com/auraphp/Aura.Sql/compare/5.0.2...6.0.0
Add PHP 8.3 to continuous integration workflow by @koriym in https://github.com/auraphp/Aura.Sql/pull/227
Full Changelog: https://github.com/auraphp/Aura.Sql/compare/5.0.2...5.0.3
Add failing test for #183 by @harikt in https://github.com/auraphp/Aura.Sql/pull/210
Full Changelog: https://github.com/auraphp/Aura.Sql/compare/5.0.1...5.0.2
Fix broken return types #204 by @r4ndsen
Version 5.x supports PHP 8.1 and up.
Version 5.x supports PHP 8.1 and up.
Full Changelog: https://github.com/auraphp/Aura.Sql/compare/3.0.0...5.0.0
Version 4.x supports PHP 7.2 and up.
Version 4.x supports PHP 7.2 and up.
Full Changelog: https://github.com/auraphp/Aura.Sql/compare/3.0.0...4.0.0
Continous Integration Improvements via #184, #197 by @koriym
Fixed issue #163: Add getAttribute and setAttribute functions to make sure pdo is connected before calling the functions
Fixed issue #163: Add getAttribute and setAttribute functions to make sure pdo is connected before calling the functions
Merged pull request #170: fixes error "Class 'Aura\Sql\PDO' not found"
Merged pull request #174: fixes bug with null value.
Updated documentation, and added a Bookdown JSON file.
First beta release.
Updated documentation, and added a Bookdown JSON file.
The sqlsrv driver now defaults to exceptions like all other drivers.
See migration guide for details upgrading from 2.x to 3.x
First alpha release.
This release adds two new off-interface methods to ConnectionLocator:
This release adds two new off-interface methods to ConnectionLocator:
setProfiling() to activate profiling across all connections
getProfiles() to get the profiles from all connections
ExtendedPdo::bindValue() method now binds PDO::PARAM_BOOL values as string '0' and string '1'; this addresses a not-a-bug-but-still-surprising behavio
ExtendedPdo::bindValue() method now binds PDO::PARAM_BOOL values as string '0' and string '1'; this addresses a not-a-bug-but-still-surprising behavior in PDO; cf. https://bugs.php.net/bug.php?id=49255.
Other hygiene fixes to docs, docblocks, etc.
Fix #111 : Binding variables conflicts with some Postgres SQL queries
Hygiene release: update documentation and testing.
Hygiene release: update documentation and testing.
This release adds new yield*() methods to _ExtendedPdo_; these return iterators to generate one result row at a time, which can reduce memory usage wi
This release adds new yield*() methods to ExtendedPdo; these return
iterators to generate one result row at a time, which can reduce memory usage
with very large result sets.
This release modifies the testing structure and updates other support files.
This release modifies the testing structure and updates other support files.
This is a hygiene release to update support files.
This is a hygiene release to update support files.
FIX: #96: Allow first bind value of query with numbered placeholders to be null.
The previous release changed the ExtendedPdoInterface by adding a new disconnect() method. That was an unintentional BC break to existing implementati
The previous release changed the ExtendedPdoInterface by adding a new disconnect() method. That was an unintentional BC break to existing implementations of the interface. This release corrects that break by removing the disconnect() method from the interface, while leaving it in the implementation.
ADD: ExtendedPdo::disconnect() method to close connections explicitly. This does not work for injected PDO connection objects, which should be managed
CHG: ExtendedPdo::prepare() now profiles the query-preparation time
SEC: ExtendedPdo no longer enables self::ATTR_EMULATE_PREPARES by default; this is to avoid security holes when using emulation.
NEW: Method Profiler::resetProfiles() allows you to clear existing profiles.
Release 2.0.1 includes a fix that moves PDO parameters explicitly back into the constructor. This restores named parameter matching for DI containers.
Release 2.0.1 includes a fix that moves PDO parameters explicitly back into the constructor. This restores named parameter matching for DI containers.
This is a breaking change from the beta. Previously, the ExtendedPdo object itself would retain values to bind against the next query. After discussio…
First stable release of Aura.Sql 2.0.0
Version 2 of Aura.Sql is greatly reduced from version 1, providing only an ExtendedPDO class, a query profiler, and a connection locator. No query objects, data mappers, or schema discovery objects are included; these are available in separate Aura.Sql_* packages. This keeps the package tightly focused as an extension for PDO, rather than a more general SQL toolset.
This is a breaking change from the beta. Previously, the ExtendedPdo object itself would retain values to bind against the next query. After discussion with interested parties, notably Rasmus Schultz, I was convinced that it was too much of a departure from normal PDO semantics.
Thus, the collection of values for binding has been removed. The methods query(), exec(), and prepare() no longer take bound values directly. Instead,we have a new method perform() that acts like query() but takes an array of values to bind at query time. We also have a new method prepareWithValues() that prepares a statement and binds values at that time. Finally, the new method fetchAffected() acts like exec(), but with bind values passed at the time of calling (just like with the other fetch*() methods).
In addition, you can now pass an existing PDO connection to ExtendedPdo so decorate that existing PDO instance with the ExtendedPdo behaviors.
Thanks to ralouphie, koriym, jblotus, and stof for their fixes and improvements in this release. Thanks also to Stan Lemon for the new proxy/decorator behavior, Rasmus Schultz for his semantic insights, and (as always) to Hari KT for his continued attention to detail.
The full list of changes follows.
Initial release of 2.0.0-beta1.
Version 2 of Aura.Sql is greatly reduced from version 1, providing only an ExtendedPDO class, a query profiler, and a connection locator. No query objects, data mappers, or schema discovery objects are included; these are available in separate Aura.Sql_* packages. This keeps the package tightly focused as an extension for PDO, rather than a more general SQL toolset.
Fix UnitOfWork test for PHP 5.5
Hygiene release.
Fix UnitOfWork test for PHP 5.5
Merge pull request #58 from MAXakaWIZARD/pr-select-query-reset-fix, fixes $from_key count when resetting select statement.
Merge pull request #56 from MAXakaWIZARD/pr-correct-join-order, implements correct join order for Query\Select
Keep a running count of FROM keys in Select, instead of counting each time
Remove commented-out code and update docblocks
[NEW] Query\Sqlite\(Select|Insert|Update|Delete) classes to support SQLite-specific behaviors
[NEW] Query\Sqlite(Select|Insert|Update|Delete) classes to support SQLite-specific behaviors
[NEW] Query\Pgsql(Select|Insert|Update|Delete) classes to support PostgreSQL-specific behaviors
[REF] Refactor existing limit/offset behaviors to Query\LimitTrait and Query\OffsetTrait
[REF] Refactor existing order-by behaviors to Query\OrderByTrait
[REF] Refactor query-string indenting and comma-separation behaviors to new methods
[ADD] Methods on each db-specific connection object to return db-specific query objects; e.g., Connection\Mysql::newMysqlSelect(), Connection\Pgsql::newPgsqlInsert(), etc.
Many thanks to @MAXakaWIZARD for his work on the features in this release.
[ADD] Profiler::getLastQuery() to get the last profiled query.
[ADD] Profiler::getLastQuery() to get the last profiled query.
[CHG] AbstractConnection::fetchAll(), fetchAssoc(), fetchCol(), and fetchPairs() all now take a third param: a callable to apply to each row in the results.
[ADD] AbstractConnection::disconnect(), mostly to help with testing.
[NEW] Query\Mysql classes to support MySQL-specific functionality:
[NEW] Query\Mysql\Select with SQL_CALC_FOUND_ROWS and other mysql-specific flags.
[NEW] Query\Mysql\Insert with IGNORE and other mysql-specific flags.
[NEW] Query\Mysql\Update with IGNORE and other mysql-specific flags, as well as LIMIT functionality.
[NEW] Query\Mysql\Delete with LOW_PRIORITY and other mysql-specific flags, as well as LIMIT functionality.
[LIC] Update license copyright dates.
[TST] Add PHP 5.5 to Travis build.
[DOC] Update README.
[ADD] AbstractConnection::setPdo() to inject a pre-existing PDO connection. Thanks, Stan Lemon, for the feature request.
[ADD] AbstractConnection::setPdo() to inject a pre-existing PDO connection. Thanks, Stan Lemon, for the feature request.
[ADD] Add missing properties AbstractConnection::$profiler and AbstractConnection::$query_factory.
[CHG] Varios typo fixes by Pascal Borrelli and Henrique Moody.
[CHG] Gateway registry entries must be wrapped in a callable from now on.
[ADD] Method Column::__isset()
WARNING: This release has backwards compatiblity breaks.
WARNING: This release has backwards compatiblity breaks.
[BRK] Rename "Adapter" to "Connection" throughout the package
[BRK] Rename "sql" to "connection" throughout the package
[ADD] Methods Query\AbstractQuery::setBind(), addBind(), and getBind() to allow bind data to be carried along with the query object.
[ADD] Method Query\AbstractQuery::getConnection() to get the injected database connection.
[NEW] Classes Gateway, GatewayIterator, and GatewayLocator (table data gateway implementation)
[NEW] Class AbstractMapper (mapper implementation)
[NEW] Class UnitOfWork (unit-of-work implemetation)
One column per quarter.