A new case-study was added to FirebirdSQL site. It is always interesting to ready such articles, and know about other companies experiences with Firebird. This time it is about DRB Systems moving from InterBase 6 to Firebird to solve stability problems. Read more.
Take a look at the new case study published in the FirebirdSQL site. Interesting that they choosed Firebird over Oracle, and cost was not the only factor. Worth reading!
There are other case studies published in the site. Make sure to read them all, and if you have an interesting case to show, contact the moderator to know how to publish it there.
Now you can use www.firebirdsql.com to visit the official project site. The URL will forward you to www.firebirdsql.org
The Firebird Project team is happy to announce that the v.2.5.1 release candidate kits for Linux and Windows 32-bit and 64-bit platforms are ready for testing. MacOSX kits are delayed by a problem with MacOSX 10.7 (Lion) but should appear soon. Enjoy! and please report bugs or regressions to the firebird-devel list.
The official report of the 8th Firebird Developers Day conference is now online, with lots of pictures. Report is available in English and Portuguese.
In the first part of our optimization story (“How to ruin Firebird performance…“) we mentioned that indices should be analyzed before dropping, even if they appeared to be very bad in IBAnalyst in terms of garbage and number of unique values.In essence, we need to log all queries used in applications, get their execution plans and check, how indices are used.For this we need to log all SQL traffic between applications and Firebird database.
Sent by Luis Rodrigues <luisrodrigues.pt@gmail.com>
1º # Install Firebird
# for this tutorial I use FirebirdSS-2.5.0.26074-0.amd64.rpm (downloaded by Firebird website)
rpm -ivh FirebirdSS-2.5.0.26074-0.amd64.rpm2º Obtain php source code
a)
# create the /etc/yum.repos.d/CentOS-SRPMS.repo with the following content[base-SRPMS]
name=CentOS-$releasever – Base SRPMS
baseurl=http://mirror.centos.org/centos/$releasever/os/SRPMS/
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-5
priority=1
enabled=1#released updates
[update-SRPMS]
name=CentOS-$releasever – Updates SRPMS
baseurl=http://mirror.centos.org/centos/$releasever/updates/SRPMS/
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-5
priority=1
enabled=1b)
yum install yum-utils
yumdownloader –source php3º # Install php-devel for phpize
yum install php-devel######################################################
# if you want to build interbase.so extension only
######################################################4º # change to the folder where the extension code is and run the following command set.
cd /usr/src/redhat/BUILD/php-5.1.6/ext/interbase
phpize
./configure –with-interbase=shared,/opt/firebird
make5º # the extension interbase.so if builded sucessfully is located at:
/usr/src/redhat/BUILD/php-5.1.6/ext/interbase/modules6º i’m using 64bits system so i need to copy the extension
cp interbase.so /usr/lib64/php/modules7º last we need to activate extension into PHP
vi /etc/php.ini#add the following line do extensions section
extension=interbase.so
#######################################################
# if you want to build Firebird Driver
#######################################################
4º # change to the folder where the extension code is and run the following command set.
cd /usr/src/redhat/BUILD/php-5.1.6/ext/pdo_firebird
phpize
./configure –with-pdo-firebird=/opt/firebird/
make5º # the extension interbase.so if builded sucessfully is located at:
/usr/src/redhat/BUILD/php-5.1.6/ext/pdo_firebird/modules6º i’m using 64bits system so i need to copy the extension
cp pdo_firebird.so /usr/lib64/php/modules7º last we need to activate extension into PHP
#to work PDO driver need PDO (if you don’t have it, install it using yum)
yum install php-pdovi /etc/php.ini
#add the following line do extensions section
extension= pdo.so
extension= pdo_firebird.so8º restart apache
service httpd restart
In summary – The zero-cost licensing model, the robustness of the product, the low usage of system resources, and minimal administration requirements make Firebird our database of choice.
Read the full answer here.
