EasySQL

Work more effectively with SQL for Performance, Security and Code Readability:, _(*1)

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.

, _(*2)

Compliance & Standards

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:
  - EasySQL::DRIVER_POSTGRES
  - EasySQL::DRIVER_MYSQL
- Define multiple applications
- Define a Master and a Slave connection for each application

https://packagist.org/packages/easysql/easysql, _(*3)

{
    "require": {
        "easysql/easysql": "dev-master"
    }
}

Example "BaseModel" Class
[Example "WorldModel" Class] (https://github.com/elchris/easysql/blob/master/com/github/elchris/easysql/tests/integration/ExampleApplicationTest.php)