PHPackages ezydb/ezydb - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. ezydb/ezydb ActiveLibrary[Database & ORM](/categories/database) ezydb/ezydb =========== PHP library aimed at simplifying database interoperability and manipulation. 1.0.8(1y ago)22[3 issues](https://github.com/ricardolima-xyz/ezydb/issues)MITPHPPHP ^8.3CI passing Since Mar 16Pushed 1y ago1 watchersCompare [ Source](https://github.com/ricardolima-xyz/ezydb)[ Packagist](https://packagist.org/packages/ezydb/ezydb)[ RSS](/packages/ezydb-ezydb/feed)WikiDiscussions main Synced today READMEChangelog (4)Dependencies (3)Versions (8)Used By (0) ezydb ===== [](#ezydb) **ezydb** is a PHP library aimed at simplifying database interoperability and manipulation. It provides a foundational implementation of the [Data Access Object (DAO)](https://en.wikipedia.org/wiki/Data_access_object) design pattern, enabling basic [Create-Read-Update-Delete (CRUD)](https://en.wikipedia.org/wiki/Create,_read,_update_and_delete) operations with minimal SQL writing. Additionally, it includes utilities for SQL interoperability, making it easier to work with different database engines. With built-in support for prepared statements, it focuses on providing a secure and efficient way to interact with databases, while continuing to evolve as a project. Testing ------- [](#testing) ``` composer update composer test ``` Notes - DAO ----------- [](#notes---dao) - Currently tested with MySQL, MariaDB, SQLite and PostgreSQL. - It depends on PDO - It is compatible with mysql if it uses ANSI mode. Make sure that tables were creaded in ANSI mode and set ANSI Mode when creating the PDO connection ``` $connection = new PDO( $connectionString, $dbUser, $dbPassword, [PDO::MYSQL_ATTR_INIT_COMMAND => 'SET sql_mode="ANSI"'] ); ``` Getting started - DAO --------------------- [](#getting-started---dao) Fist you need a database. In our example, we are using SQLite as our database engine. ``` CREATE TABLE IF NOT EXISTS testEntity ( id INTEGER PRIMARY KEY, columnone VARCHAR(255), columntwo DOUBLE PRECISION, active CHAR(1) DEFAULT '1' ); ``` Now, in your code you start by creating your dao; ``` include_once 'dao.class.php'; $myDAO = new DAO( // PDO Connection string new PDO("sqlite:./test.sqlite"), // DB Table name 'table', // Mapping of table column names and PDO param types [ 'id' => PDO::PARAM_INT, 'columnone' => PDO::PARAM_STR, 'columntwo' => PDO::PARAM_STR, 'active' => PDO::PARAM_STR ], [ // Defines which column is the primary key (requirement of this library) DAO::KEY => 'id', // Specifies whether the primary key is auto generated or not DAO::KEY_IS_AUTOGENERATED => true // Specifies delete method, which could be deletion or deactivation DAO::DEL_METHOD => DAO::DEL_METHOD_DEACTIVATE, // Case the delete method is deactivation, we should specify the column which serves as a flag // Deleted objects receive 0 and active objects receive 1. DAO::DEACTIVATE_COLUMN => 'active' ] ); ``` Now you have an object which is ready to perform basic CRUD operations without writing one line of SQL: ``` // Creates a new object in the database. Note that id doesn't need to be specified if it // is autogenerated in database and this information was passed in the constructor $id = $myDAO->create(['columnone'=>'abc', columntwo=>'1.2']); // Retrieves the object with given primary key $object = $myDAO->get($id); // Checks the existence of the object without retrieving it $itExists = $myDAO->exists($id); $itDoesNotExist = $myDAO->exists('BLAHBLAHBLAH'); // Retrieves a list of objects $result = $myDAO->list(); // Deletes the object $result = $myDAO->del($id); ``` ### Health Score 26 — LowBetter than 41% of packages Maintenance22 Infrequent updates — may be unmaintained Popularity6 Limited adoption so far Community9 Small or concentrated contributor base Maturity58 Maturing project, gaining track record Bus Factor1 Top contributor holds 78.8% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~0 days Total 7 Last Release 473d ago ### Community Maintainers ![](https://avatars.githubusercontent.com/u/1002329?v=4)[Ricardo](/maintainers/ricardolima)[@ricardolima](https://github.com/ricardolima) --- Top Contributors [![ricardolima-xyz](https://avatars.githubusercontent.com/u/698278?v=4)](https://github.com/ricardolima-xyz "ricardolima-xyz (52 commits)")[![actions-user](https://avatars.githubusercontent.com/u/65916846?v=4)](https://github.com/actions-user "actions-user (14 commits)") --- Tags daodao-cruddao-design-patterndata-accessdatta-access-layerdatta-access-objectdesign-patterndesign-pattern-phpdesign-patternsiso-sqlphp-librarysqlsql-2019sql-translator ### Code Quality TestsPHPUnit Code StylePHP\_CodeSniffer ### Embed Badge ![Health badge](/badges/ezydb-ezydb/health.svg) ``` [![Health](https://phpackages.com/badges/ezydb-ezydb/health.svg)](https://phpackages.com/packages/ezydb-ezydb) ``` ### Alternatives [jdorn/sql-formatter a PHP SQL highlighting library 3.9k117.2M118](/packages/jdorn-sql-formatter)[propel/propel1 Propel is an open-source Object-Relational Mapping (ORM) for PHP5. 8351.6M87](/packages/propel-propel1)[jfelder/oracledb Oracle DB driver for Laravel 11518.4k](/packages/jfelder-oracledb) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)