GeezerVison

The World Wide Web, restored to 800 pixels of glory.

GeezerVison is showing cycle-orm.dev — Cycle ORM: Databases - Database Isolation

Revision: Wed, 04 Nov 2026 16:26:00 GMT

Database - Logical Isolation

Configuration
Runtime configuration

The cycle/database component provides the ability to use a single connection for multiple, logically isolated databases. The isolation performed using table prefix, which automatically added to every SQL identifier.

#Configuration

To enable database prefix use option prefix of your database:

php

<?php

declare(strict_types=1);

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

$dbal = new DatabaseManager(new Config\DatabaseConfig([
    'databases'   => [
        'default' => ['connection' => 'sqlite', 'prefix' => 'my_prefix_'],
    ],
    'connections' => [
        'sqlite' => new Config\SQLiteDriverConfig(
            connection: new Config\SQLite\MemoryConnectionConfig(),
            queryCache: true,
        ),
    ],
]));

#Runtime configuration

You can isolate database in runtime using withPrefix method:

php

$db = $dbal->database();
print_r($db->withPrefix('my_db_prefix')->getTables());

The schema introspection and declaration will work with the isolated database by automatically adding a prefix to all declared tables.

← PREVIOUS Profiling and Logging

NEXT → Query Builders

2.x

1.x

Edit this page

You are visitor 01402520 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.