Skip to content
cyclePublic

About

Database Abstraction Layer, Schema Introspection, Schema Generation, Query Builders

Topics

Resources

Code of conduct

Contributing

Security policy

Stars

72 stars

Watchers

3 watching

Forks

Repository files navigation

Cycle DBAL: database abstraction layer, schema introspection, migrations and pagination

Documentation Sponsor Discord

Psalm Level Type Coverage Codecov


Secure, multiple SQL dialects (MySQL, PostgreSQL, SQLite, SQLServer), schema introspection, schema declaration, smart identifier wrappers, database partitions, query builders, nested queries.

Get Started

Requirements

Make sure that your server is configured with following PHP version and extensions:

  • PHP 8.2+
  • PDO Extension with desired database drivers

Installation

composer require cycle/database

PHP Latest Version on Packagist License Total Downloads

Example

Given example demonstrates the connection to SQLite database, creation of table schema, data insertion and selection:

<?php
declare(strict_types=1);

require_once "vendor/autoload.php";

use Cycle\Database\Config;
use Cycle\Database\DatabaseManager;

$dbm = new DatabaseManager(new Config\DatabaseConfig([
    'databases'   => [
        'default' => ['connection' => 'sqlite'],
    ],
    'connections' => [
        'sqlite' => new Config\SQLiteDriverConfig(
            connection: new Config\SQLite\FileConnectionConfig(
                database: 'runtime/database.db'
            ),
        ),
    ],
]));

$users = $dbm->database('default')->table('users');

// create or update table schema
$schema = $users->getSchema();
$schema->primary('id');
$schema->string('name');
$schema->datetime('created_at');
$schema->datetime('updated_at');
$schema->save();

// insert data
$users->insertOne([
    'name'       => 'test',
    'created_at' => new DateTimeImmutable(),
    'updated_at' => new DateTimeImmutable(),  
]);

// select data
foreach ($users->select()->where(['name' => 'test']) as $u) {
    print_r($u);
}

Documentation

About

Database Abstraction Layer, Schema Introspection, Schema Generation, Query Builders

Topics

Resources

Code of conduct

Contributing

Security policy

Stars

72 stars

Watchers

3 watching

Forks

Releases

Sponsor this project

Used by

Contributors

Languages