Work more effectively with SQL for Performance, Security and Code Readability:
- Exposes Simple API - Takes care of PDO and Prepared Statement management so you don't have to
- Strongly-Typed returns on SELECT operations, returning instances of Entity Beans
- Strongly-Typed INSERT operations allowing easy insertion of collections of Entity Beans
- First-Class support for Master and Slave connections, with transparent dispatching of queries to appropriate connection
- Optimal management of PDO Connections and Prepared Statements across an execution context
- Reusable connections are managed via a shared "Execution Context", allowing you to use and reuse as many "Model" Class instances as convenient without constantly opening-up and tearing-down connections.
- Each connection keeps track of "Prepared Statements" tied to each new "Query String" it sees. Should the same query be invoked via another method or class later within an Execution Context, the previously-generated Prepared Statement tied to that query will be reused.
- Built TDD in PhpStorm with SOLID principles, 100% code coverage thru Unit and Integration Tests
- PSR-2 coding style
- PSR-4 auto-loading
- Composer Installation from Packagist
- Semantic Versioning will be followed
- This is not an ORM library. It assumes you'll be writing your own SQL queries.
- By leveraging "Entity Beans" for INSERT and SELECT operations, spend less time juggling untyped associative arrays.
- EasySQLConfig allows you to:
- Define your PDO-supported driver:
- Define multiple applications
- Define a Master and a Slave connection for each application
https://packagist.org/packages/easysql/easysql
{
"require": {
"easysql/easysql": "dev-master"
}
}