Here is the guide on installing Firebird 2.5.3 from FreeBSD 10 Ports and
creating your first test database; also we show you how to install
Flamerobin GUI (administration tool) and the PHP driver for it. This was tested on fresh FreeBSD 10 on a kvm-linux virtual machine.
Download a compressed snapshot of the Ports Collection into /var/db/portsnap.
# portsnap fetch
Or update it.
If you are running Portsnap for the first time, extract the snapshot into /usr/ports:
# portsnap extract
If you already have a populated /usr/ports directory and you are just updating, run the following command instead:
# portsnap update
Enter firebird server ports directory:
# cd /usr/ports/databases/firebird25-server
Compile and install firebird server:
# make -DPACKAGE_BUILDING
# make install
Enable it by adding
Start it with:
# /usr/local/etc/rc.d/firebird start
logs and security2.fdb seems to be in /var/db/firebird.
To create a new database:
SQL> create database “tmp/first_database.fdb”;
SQL> connect “/tmp/first_database.fdb” ;
Commit current transaction (y/n)? <– y
If you want to create a simple table then insert 1-2 rows and select from it; here is one example:
SQL> CREATE TABLE TEST (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(20));
SQL> show tables;
SQL> INSERT INTO TEST VALUES (1, ‘John’);
SQL> INSERT INTO TEST VALUES (2, ‘Joe’);
SQL> select * from test;
To quit the isql-fb console, type quit:
For a good open source GUI admin tool you might check the flamerobin administration tool included in ports repository; it can be installed by a simple:
# cd /usr/ports/databases/flamerobin/ && make install clean
Or if you don’t want to wait use pkg-add
# pkg-add -r flamerobin
To use firebird with php, you will need the php5 driver:
# cd /usr/ports/databases/php5-interbase/ && make install clean
You can choose to compile php with apache support (I have chosen cli, cgi , and apache support);
check it if is enabled with:
# /usr/local/bin/php -m
Or if you don’t want to wait compile all the php use pkg-add
# pkg-add -r php5-interbase
It seems that now the YiiFirebird extension is stable enough (please let me know it is not so) for merge in YiiFramework master repo.
Now, the next step is to create the automated tests for this extension. Volunteers? Ideas?
We need to add a “tests” directory for that purpose in our local repo before committing Yii master repo.
Comment on this issue
Ricardo Obregon announces that the Firebird Adapter 1.0RC for Yii is now released
Please vote on this survey if you agree to Firebird to become more popular in Php/Python world and to be added to the XAMPP package
This was written on albringas.com :
I’ve been using Codeigniter as my development platform and framework of choice since last year. Being a ten year PHP developer, Codeigner was a refreshing way of coding web apps with PHP.
The first ones developments I did with Codeigniter were using MySQL, a very used database. But since I’ve also been using Firebird SQL Database from ten or more years ago, I decided to give a try to the Codeigniter-Firebird duo.
Read the rest of the adventure