arabcoders / database

v1.0.10 2026-11-10 18:57 UTC

Requires

• php: >=8.5
• ext-pdo: *
• psr/container: ^2.0
• psr/event-dispatcher: ^1.0
• psr/http-message: ^2.0
• psr/log: ^3.0
• psr/simple-cache: ^3.0

Requires (Dev)

• carthage-software/mago: ^1.3.0
• phpunit/phpunit: ^13.0
• rector/rector: ^2.5

MIT

• Abdulmohsen

• database
• mysql
• sqlite
• pdo
• pgsql

Published on Packagist.org on 2026-11-10 19:08 UTC

README

PDO queries, ORM, schema migrations, and seeders for PHP.

Install

composer require arabcoders/database

Requirements

• PHP 8.5 or newer.
• A PDO driver for mysql, pgsql, or sqlite.

Guides

• Query builder
• ORM
• Schema and migrations
• Seeding
• Database dialects

Connect and run a query

Query an existing todos table:

<?php

declare(strict_types=1);

use arabcoders\database\Connection;
use arabcoders\database\Dialect\DialectFactory;
use arabcoders\database\Query\Condition;
use arabcoders\database\Query\SelectQuery;

$pdo = new \PDO('sqlite:app.sqlite');
$db = new Connection($pdo, DialectFactory::fromPdo($pdo));

$rows = $db->fetchAll(
    (new SelectQuery('todos'))
        ->select(['id', 'title'])
        ->where(Condition::equals('status', 'open'))
        ->orderBy('id', 'DESC')
        ->limit(20)
);