Firebird 2.0.x series discontinued End Of Life

Accordingly to its release lifetime policy, Firebird Project notifies that the Firebird v2.0 series has reached its end of life and thus will not be maintained anymore. The last official release in this series, Firebird 2.0.7, which has been announced this year, will be available from the “discontinued” section of the download area.

The Firebird roadmap is updated , we are waiting for Firebird 3.0.x Alpha 🙂

FlameRobin connection thread test on Windows

I have posted a test version of FlameRobin: http://mghie.users.sourceforge.net/flamerobin_win32_test.zip

(a ZIP file containing only the 32 bit executables for Windows in ANSI and Unicode version) that uses a thread to establish the database connection. That
means that the progress dialog can be moved and cancelled, and the progress bar is updated in indeterminate mode. To see it in action it’s
best to try to connect to a database on a server which is not available or which doesn’t exist, which so far blocks FlameRobin completely until
the connection call times out. It would be great if people could test this and write (to flamerobin-devel) whether anything

breaks for them (it didn’t for me, yet). I’m a little of unsure if I should clean this up and commit…

Thanks


Michael Hieke

CakePHP 1.3 and Firebird

After searching the internet for a decent walk through or tutorial, I came up with very little and so I decided to collate what have learned in this post with the hope that someone else can benefit from it.

Firstly you will need to obtain the datasources plugin from github and stick it in your application’s plugin folder (app/plugins) – make sure you get the master branch and not the 2.0 as it needs to be compatible with your version of CakePHP (1.3 ideally)

The next thing you need to do is edit the databases config file (app/config/database.php):

var $defaultarray(
        'driver' => 'Datasources.DboFirebird'//references the datasources plugin
        'persistent' => false,
        'host' => 'localhost'//the host name of your database
        'login' => 'sysdba',
        'password' => 'masterkey',
        'database' => 'C:\\path\\to\\database.gdb'//path to the database - note the double backslashes
        'prefix' => '',
        //'encoding' => 'utf8',
    );

The two important things you should note of is the driver key-value pair which references the datasource plugin namespace, and secondly the double backslashes for the database file path.

All the models you create for your application should now access the corresponding tables through the FireBird SQL connection.

1 103 104 105 106 107 294