Tasmanian newspaper tames open source Firebird

20.07.2006

The Examiner now has six different Firebird-based applications that are available to the public to which are connected about 300 companies - like automotive dealers and real estate agents - connect each day.

The applications are developed with the popular PHP scripting language and delivered by the Apache Web server on Linux, exactly like the LAMP (Linux, Apache, and Perl/Python/PHP) stack, but without MySQL. Firebird is also used on FreeBSD Unix and Windows Server.

"Our transaction throughput is pretty light, we might do about 20,000 transactions a day," Weeks said, adding the biggest database is about 16GB. "But maintenance is nonexistent - it's a DBA-less database. Backups can be done on the fly, so there's no need to take it offline, and it comes with a simple level of replication built in."

Weeks has also tried developing with PostgreSQL, but it "used all the memory and crashed the server".

He describes PostgreSQL as more of a research database with more features than Firebird, but lacking its level of enterprise robustness.