ceibacore / ceiba-db

v1.0.1 2026-09-21 03:48 UTC

Requires

• php: ^8.1 || ^8.2 || ^8.3 || ^8.4
• ext-pdo: *

Requires (Dev)

• phpunit/phpunit: ^10.5 || ^11.5 || ^12.0

MIT

• Ceiba Core Team

Published on Packagist.org on 2026-09-21 03:54 UTC

README

A lightweight, zero-dependency, PDO-backed database abstraction layer and fluent query builder for PHP 8.1+.

Designed for maximum developer ergonomics without the overhead of heavy ORMs. Supports MySQL, MariaDB, PostgreSQL, and SQLite.

Installation

composer require ceibacore/ceiba-db

Quick Start

1. Initialize Connection (Singleton)

use CeibaDB;

// Configure singleton instance
$db = CeibaDB::getInstance([
    'driver'   => 'mysql',
    'host'     => '127.0.0.1',
    'port'     => 3306,
    'db'       => 'my_database',
    'username' => 'db_user',
    'password' => 'secret',
    'charset'  => 'utf8mb4',
    'prefix'   => 'cb_', // optional table prefix
]);

2. Query Builder (CeibaQuery)

// SELECT
$users = $db->query('users')
    ->select(['id', 'name', 'email'])
    ->where(['status' => 1])
    ->orderby('created_at DESC')
    ->limit(20)
    ->get();

// INSERT
$userId = $db->query('users')->insert([
    'name'  => 'Jane Doe',
    'email' => '[e-mail]',
]);

// UPDATE (requires at least one WHERE condition for safety)
$affected = $db->query('users')
    ->where(['id' => $userId])
    ->update(['name' => 'Jane Smith']);

// DELETE (requires at least one WHERE condition for safety)
$deleted = $db->query('users')
    ->where(['id' => $userId])
    ->delete();

3. Transactions

$db->transaction(function (CeibaDB $db) {
    $db->query('accounts')->where(['id' => 1])->decrement('balance', 100);
    $db->query('accounts')->where(['id' => 2])->increment('balance', 100);
});

Backward Compatibility

CeibaDB includes 100% backward compatibility aliases for LemurDB and LemurQuery:

// Existing code using LemurDB continues to work transparently:
$db = LemurDB::getInstance();

License

MIT License. See LICENSE for details.