animatow/cakephp-firebird-driver

CakePHP 4 Driver for Firebird Database

2.1.4 2022-04-07 19:59 UTC

Requires

• php: >=8.0
• cakephp/cakephp: ~4.0

Requires (Dev)

• phpunit/phpunit: ^8.0|^9.0

MIT

• Stephan Broeker
• Kevin Gledhill

• database
• cakephp
• driver
• firebird
• cakephp4

README

Currently provides data reading, inserting, deleting and updating.

Installation

You can install this plugin into your CakePHP application using composer.

The recommended way to install composer packages is:

composer require animatow/cakephp-firebird-driver

Requirements

• CakePHP 4.0+
• an Firebird PHP extension
  • For Ubuntu 14.04 installing see Ubuntu-PDO
  • or FreeBSD 13 installing see FreeBSD-PDO

Datasource configuration

Here is an example datasource configuration:

'myfbconnection' => [
    'className' => 'Cake\Database\Connection',
    'driver' => 'CakephpFirebird\Driver\Firebird',
    'host' => '127.0.0.1',
    'port' => '3050',
    'username' => 'sysdba',
    'password' => 'masterkey',
    'database' => '/path-to-database/database.fdb',
    ]

Known Issues

• disable multiple records insert in the same query (e.g.: fixtures)
• disable auto increment fields on table creation
• review data types
• improve unit tests
• unimplemented add and dropContraints, enable and disableForeignFeySQL

Workaround

• use cake bake lowercase table name