Doctrine Firebird driver

Firebird driver for the Doctrine DBAL

Requirements

To utilize this library in your application code, the following is required:

• Firebird Client for Server version 2.5, 3, 4 or 5
• PHP >= 8.1
• fbird/ibase interbase firebird driver
• doctrine/dbal ^3.8

License & Disclaimer

See LICENSE file. Basically: Use this library at your own risk.

Limitations of Schema Manager

This library does not fully support generation through the Schema Manager, i.e.:

1. Generation of database tables, views, etc. from entities.
2. Generation of entities from database tables, views, etc.

Reasons for not investing time in schema generation include that Firebird does not allow renaming of tables, which in turn makes automated schema updates annoying and over-complicated. Better results are probably achieved by writing manual migrations.

Installation

Via Composer (satag/doctrine-firebird-driver):

composer install satag/doctrine-firebird-driver

Via Github:

git clone https://github.com/satwareAG/doctrine-firebird-driver.git

Configuration

Manual configuration

Symfony configuration (YAML)

This driver may be used like any other Doctrine DBAL driver in Symfony, e.g. with doctrine/doctrine-bundle. However, the driver_class option must be specified instead of simply driver. This is due to the driver not being part of the core Doctrine DBAL library.

Sample YAML configuration:

doctrine:
    dbal:
        default_connection: default
        connections:
            default:
                driver_class:   Satag\DoctrineFirebirdDriver\Driver\Firebird\Driver
                host:           "%database_host%"
                port:           "%database_port%"
                dbname:         "%database_name%"
                user:           "%database_user%"
                password:       "%database_password%"
                charset:        "UTF-8"

Tests

Test/development requirements

To run tests, fix bugs, provide features, etc. you can use the provided docker compose file in the /tests directory.

Credits

Authors

• Kasper Søfren
  https://github.com/kafoso
  E-mail: soefritz@gmail.com
• Uffe Pedersen
  https://github.com/upmedia

Acknowledgements

https://github.com/doctrine/dbal

Fundamental Doctrine DBAL implementation. The driver and platform logic in this library is based on other implementations in the core library, largely \Doctrine\DBAL\Driver\PDOOracle\Driver and \Doctrine\DBAL\Platforms\OraclePlatform, and their respective parent classes.

https://github.com/helicon-os/doctrine-dbal

Whilst a great inspiration for this library - and we very much appreciate the work done by the authors - the library has a few flaws and limitations regarding the Interbase Firebird driver logic:

• It contains bugs. E.g. incorrect/insufficient handling of nested transactions and save points.
• It is lacking with respect to test coverage.
• It appears to no longer be maintained. Possibly entirely discontinued.
• It is intermingled with the core Doctrine DBAL code, making version management and code adaptation unnecessarily complicated; a nightmare, really. It is forked from https://github.com/doctrine/dbal, although, this is not specifically stated.
• It is not a Composer package (not on https://packagist.org).

https://github.com/ISTDK/doctrine-dbal

A fork of https://github.com/helicon-os/doctrine-dbal with a few improvements and fixes.

https://firebirdsql.org/

The main resource for Firebird documentation, syntax, downloads, etc.

AI Context-Setting Statement

As an AI specialized in coding, your task is to support me, Michael Wegener, to improve the PHP Doctrine DBAL driver for the Firebird SQL Server for which I am the current maintainer. The Driver is not based on Firebird PDO, it is based on PHP Firebird Extension interbase.so (using fbird* function aliases for ibase* functions). You can reference the following resources for guidance:

• satag/doctrine-firebird-driver Source Code Branches
  • https://github.com/satwareAG/doctrine-firebird-driver/tree/3.0.x supports DBAL ^3.8
  • https://github.com/satwareAG/doctrine-firebird-driver/tree/4.0.x supports DBAL ^4.1
• Doctrine DBAL Driver documentation: Doctrine DBAL
• Reference manuals of Firebird’s implementation of the SQL relational database language for
  Firebird 2.5, Firebird 3.0 and Firebird 4.0
• PHP Firebird Extension Source: PHP Firebird extension
• German Firebird Forum
• You can download all given resources for reference.

The PHP Driver is implemented for PHP 8.1+ and should be covered with PHP Unit and Integration Tests against all Firebird Server Versions. Have an eye on modern development principles, performance and security.