abulhanifah/zahir-database

A hacking database service provider for laravel

dev-master 2018-10-11 08:04 UTC

Requires

• doctrine/dbal: ^2.5
• jacquestvanzuydam/laravel-firebird: dev-5.4-support
• kafoso/doctrine-firebird-driver: ^1.1.2

MIT

README

To use this package:

Installation

Install the Firebird PDO driver for PHP.

Mariuz's Blog has a very good step by step on this: http://mapopa.blogspot.com/2009/04/php5-and-firebird-pdo-on-ubuntu-hardy.html

Install zahir-database

composer require abulhanifah/zahir-database

Update the app/config/app.php, add the service provider:

'ZahirDB\zahirServiceProvider'.

You can remove the original DatabaseServiceProvider, as the original connection factory has also been extended.

Declare your connection in the database config, using 'firebird' as the connecion type. Other keys that are needed:

'firebird' => [
    'driver'   => 'firebird',
    'host'     => env('DB_HOST', 'localhost'),
    'database' => env('DB_DATABASE','/storage/firebird/APPLICATION.FDB'),
    'username' => env('DB_USERNAME', 'sysdba'),
    'password' => env('DB_PASSWORD', 'masterkey'),
    'charset'  => env('DB_CHARSET', 'UTF8'),
],

And add to your .env

DB_CHARSET=UTF8

If necessary, change the UTF8 to any other charset

This package is still in it's infancy and I wouldn't yet recommend using it for large projects, or without backing up your database regularly.

Any comments or contributions are welcome.