Work more optimally with SQL for Performance, Security and Readability
PHP
Switch branches/tags
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.idea
com/github/elchris/easysql
vendor
LICENSE
README.md
cacert.pem
composer.json
composer.lock
composer.phar

README.md

EasySQL

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.

Test Coverage Scrutinizer Code Quality Code Climate Build Status

Compliance & Standards

More Precisely

  • 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:

Composer Installation:

https://packagist.org/packages/easysql/easysql

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

Sample Usage:

Purpose