2017 © Pedro Peláez
 

library sql

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.

image

aura/sql

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.

  • Monday, June 11, 2018
  • by pmjones
  • Repository
  • 46 Watchers
  • 426 Stars
  • 334,385 Installations
  • PHP
  • 51 Dependents
  • 4 Suggesters
  • 87 Forks
  • 2 Open issues
  • 26 Versions
  • 7 % Grown

The README.md

Aura.Sql

Provides an extension to the native PDO along with a profiler and connection locator. Because ExtendedPdo is an extension of the native PDO, code already using the native PDO or typehinted to the native PDO can use ExtendedPdo without any changes., (*1)

Added functionality in Aura.Sql over the native PDO includes:, (*2)

  • Lazy connection. ExtendedPdo connects to the database only on method calls that require a connection. This means you can create an instance and not incur the cost of a connection if you never make a query., (*3)

  • Decoration. DecoratedPdo can be used to decorate an existing PDO instance. This means that a PDO instance can be "extended" at runtime to provide the ExtendedPdo behaviors., (*4)

  • Array quoting. The quote() method will accept an array as input, and return a string of comma-separated quoted values., (*5)

  • New perform() method. The perform() method acts just like query(), but binds values to a prepared statement as part of the call. In addition, placeholders that represent array values will be replaced with comma- separated quoted values. This means you can bind an array of values to a placeholder used with an IN (...) condition when using perform()., (*6)

  • New fetch*() methods. The new fetch*() methods provide for commonly-used fetch actions. For example, you can call fetchAll() directly on the instance instead of having to prepare a statement, bind values, execute, and then fetch from the prepared statement. All of the fetch*() methods take an array of values to bind to to the query statement, and use the new perform() method internally., (*7)

  • New yield*() methods. These are complements to the fetch*() methods that yield results instead of returning them., (*8)

  • Exceptions by default. ExtendedPdo starts in the ERRMODE_EXCEPTION mode for error reporting instead of the ERRMODE_SILENT mode., (*9)

  • Profiler. An optional query profiler is provided, along with an interface for other implementations, that logs to any PSR-3 interface., (*10)

  • Connection locator. A optional lazy-loading service locator is provided for picking different database connections (default, read, and write)., (*11)

Installation and Autoloading

This package is installable and PSR-4 autoloadable via Composer as aura/sql., (*12)

Alternatively, download a release, or clone this repository, then map the Aura\Sql\ namespace to the package src/ directory., (*13)

Dependencies

Version 6.x is compatible with PHP 8.4 and above. If you're running PHP 8.1-8.3, please use version 5.x. We recommend using the latest available version of PHP as a matter of principle., (*14)

Aura library packages may sometimes depend on external interfaces, but never on external implementations. This allows compliance with community standards without compromising flexibility. For specifics, please examine the package composer.json file., (*15)

Quality

Scrutinizer Code Quality Code Coverage Build Status PDS Skeleton, (*16)

This project adheres to Semantic Versioning., (*17)

To run the unit tests at the command line, issue composer install and then ./vendor/bin/phpunit at the package root. (This requires Composer to be available as composer.), (*18)

This package attempts to comply with PSR-1, PSR-2, and PSR-4. If you notice compliance oversights, please send a patch via pull request., (*19)

Community

To ask questions, provide feedback, or otherwise communicate with other Aura users, please join our Google Group, follow @auraphp, or chat with us on Freenode in the #auraphp channel., (*20)

Documentation

This package is fully documented here., (*21)

The Versions

11/06 2018

3.x-dev

3.9999999.9999999.9999999-dev https://github.com/auraphp/Aura.Sql

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.

  Sources   Download

MIT

The Requires

 

The Development Requires

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

11/06 2018

3.0.0

3.0.0.0 https://github.com/auraphp/Aura.Sql

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.

  Sources   Download

MIT

The Requires

 

The Development Requires

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

01/05 2018

2.x-dev

2.9999999.9999999.9999999-dev https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

The Development Requires

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

04/03 2018

2.5.2

2.5.2.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

The Development Requires

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

28/06 2017

3.0.0-beta1

3.0.0.0-beta1 https://github.com/auraphp/Aura.Sql

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.

  Sources   Download

MIT

The Requires

 

The Development Requires

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

09/03 2017

3.0.0-alpha1

3.0.0.0-alpha1 https://github.com/auraphp/Aura.Sql

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.

  Sources   Download

MIT

The Requires

 

The Development Requires

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

24/02 2017

dev-quote-name

dev-quote-name https://github.com/auraphp/Aura.Sql

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.

  Sources   Download

MIT

The Requires

 

The Development Requires

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

03/10 2016

2.5.1

2.5.1.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

01/05 2016

2.5.0

2.5.0.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

04/04 2015

1.x-dev

1.9999999.9999999.9999999-dev http://auraphp.github.com/Aura.Sql

A wrapper around PDO that provides connection adapters and convenience methods for MySQL, PostgreSQL, SQLite, and SQL Server.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.4.0

 

by Aura Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server

27/03 2015

2.4.3

2.4.3.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

16/03 2015

2.4.2

2.4.2.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

03/03 2015

2.4.1

2.4.1.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

10/02 2015

2.4.0

2.4.0.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

03/02 2015

2.3.0

2.3.0.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

19/01 2015

2.2.1

2.2.1.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

17/01 2015

2.2.0

2.2.0.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

24/08 2014

2.1.0

2.1.0.0 https://github.com/auraphp/Aura.Sql

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

31/05 2014

1.3.1

1.3.1.0 http://auraphp.com/Aura.Sql

The Aura Sql package is a wrapper around PDO that provides connection adapters and convenience methods for MySQL, PostgreSQL, SQLite, and SQL Server.

  Sources   Download

BSD-2-Clause

The Requires

 

by Hari KT
by Paul M. Jones
by Pascal Borreli
by Aura.Sql Contributors
by Roy Gu
by Max Grigorian
by Ramiro Varandas Jr
by Abdul.Mohsen B. A. A
by Ignace Nyamagana Butera

postgresql postgres pdo mysql sqlite pgsql sql server

08/04 2014

2.0.1

2.0.1.0 https://github.com/auraphp/Aura.Sql/releases

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

01/04 2014

2.0.0

2.0.0.0 https://github.com/auraphp/Aura.Sql/releases

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

03/01 2014

2.0.0-beta1

2.0.0.0-beta1 https://github.com/auraphp/Aura.Sql/releases

A PDO extension that provides lazy connections, array quoting, identifier 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.

  Sources   Download

BSD-2-Clause

The Requires

  • php >=5.3.0

 

by Aura.Sql Contributors

postgresql postgres pdo mysql sqlite sqlserver pgsql sql server sqlsrv

17/09 2013

1.3.0

1.3.0.0 http://auraphp.com/Aura.Sql

The Aura Sql package is a wrapper around PDO that provides connection adapters and convenience methods for MySQL, PostgreSQL, SQLite, and SQL Server.

  Sources   Download

BSD-2-Clause

The Requires

 

by Hari KT
by Paul M. Jones
by Pascal Borreli
by Aura.Sql Contributors
by Roy Gu
by Max Grigorian
by Ramiro Varandas Jr
by Abdul.Mohsen B. A. A
by Ignace Nyamagana Butera

postgresql postgres pdo mysql sqlite pgsql sql server

10/09 2013

1.2.0

1.2.0.0 http://auraphp.com/Aura.Sql

The Aura Sql package is a wrapper around PDO that provides connection adapters and convenience methods for MySQL, PostgreSQL, SQLite, and SQL Server.

  Sources   Download

BSD-2-Clause

The Requires

 

by Hari KT
by Paul M. Jones
by Pascal Borreli
by Aura.Sql Contributors
by Roy Gu
by Max Grigorian
by Ramiro Varandas Jr
by Abdul.Mohsen B. A. A
by Ignace Nyamagana Butera

postgresql postgres pdo mysql sqlite pgsql sql server

09/05 2013

1.1.0

1.1.0.0 http://auraphp.github.com/Aura.Sql

The Aura Sql package is a wrapper around PDO that provides connection adapters and convenience methods for MySQL, PostgreSQL, SQLite, and SQL Server.

  Sources   Download

BSD-2-Clause

The Requires

 

by Paul M. Jones
by Pascal Borreli
by Aura.Sql Contributors
by Roy Gu
by Ramiro Varandas Jr

postgresql postgres pdo mysql sqlite pgsql sql server

29/11 2012

1.0.0

1.0.0.0 http://auraphp.github.com/Aura.Sql

The Aura Sql package is a wrapper around PDO that provides connection adapters and convenience methods for MySQL, PostgreSQL, SQLite, and SQL Server.

  Sources   Download

BSD-2-Clause

The Requires

 

by Paul M. Jones
by Aura.Sql Contributors
by Roy Gu

postgresql postgres pdo mysql sqlite pgsql sql server