README

Independent Laravel package with a Firebird SQL 5 driver for Laravel 13.

Features

firebird connection driver for Laravel 13 with package auto-discovery
PDO Firebird connector with DSN builder for local and host-based database paths
Query support for pagination, insertGetId(), insertUsing(), DELETE ... ROWS, single-row upsert, union all, lockForUpdate(), and sharedLock()
Schema support for create, alter, change(), renameColumn(), dropColumn(), indexes, unique constraints, foreign keys, views, and bulk dropping of tables/views
Schema introspection for tables, views, columns, indexes, foreign keys, and domains via getTypes()
Firebird-aware transaction handling for top-level Laravel transaction blocks

Requirements

PHP 8.3+
Laravel 13
ext-pdo
pdo_firebird enabled in PHP
Firebird SQL 5

Installation

composer require vkrapotkin/laravel-firebird5

Configuration

Add a Firebird connection to config/database.php:

'connections' => [
    'firebird' => [
        'driver' => 'firebird',
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', 3050),
        'database' => env('DB_DATABASE', database_path('database.fdb')),
        'username' => env('DB_USERNAME', 'sysdba'),
        'password' => env('DB_PASSWORD', 'masterkey'),
        'charset' => env('DB_CHARSET', 'UTF8'),
        'role' => env('DB_ROLE'),
        'dialect' => env('DB_DIALECT', 3),
        'prefix' => '',
        'isolation_level' => env('DB_ISOLATION_LEVEL'),
    ],
],

Example .env:

DB_CONNECTION=firebird
DB_HOST=127.0.0.1
DB_PORT=3050
DB_DATABASE=C:\data\app.fdb
DB_USERNAME=sysdba
DB_PASSWORD=masterkey
DB_CHARSET=UTF8
DB_DIALECT=3

Publishing

Create a new GitHub repository named laravel-firebird5 under vkrapotkin.
Push this package as the initial codebase of the new repository.
Sign in to Packagist and submit https://github.com/vkrapotkin/laravel-firebird5.
Ensure GitHub Services / webhooks are enabled in Packagist for automatic updates.

Notes

The package targets Firebird SQL 5 syntax and PDO Firebird.
The package namespace is Vkrapotkin\LaravelFirebird5.
Query and schema behavior is covered by unit tests and real integration tests against a Firebird 5 database recreated on demand.

Known Limitations

rename table is not exposed because a reliable Firebird 5 + PDO_FIREBIRD path was not confirmed in this driver flow.
Nested transactions are not supported through PDO; the driver supports a single top-level transaction boundary only.
insertOrIgnore* paths are intentionally unsupported and follow Laravel's base runtime exception behavior.
Savepoint behavior is not advertised until it is validated on the Firebird/PDO combination used by this package.

Transactions

Firebird with PDO_FIREBIRD often keeps the connection inside an already active transaction. Because of that, this driver adapts Laravel transaction handling as follows:

A top-level beginTransaction() / commit() / rollBack() block is supported.
If PDO already reports an active transaction, the driver adopts that transaction instead of trying to open a second physical transaction.
Nested transactions are not supported through PDO and will throw a RuntimeException.
Schema operations are not wrapped in grammar-managed transactions.

Recommended usage:

DB::beginTransaction();

try {
    // write queries...
    DB::commit();
} catch (\Throwable $e) {
    DB::rollBack();
    throw $e;
}

Avoid opening nested transaction blocks on the same Firebird connection until savepoint behavior is explicitly implemented and validated.

Testing

composer test
vendor\bin\phpunit --testsuite Unit
vendor\bin\phpunit --testsuite Integration --display-warnings

vkrapotkin / laravel-firebird5

Maintainers

Package info

Statistics

Security