While high-profile open-source efforts like MySQL and PostgreSQL slug it out with the big four commercial databases, a Tasmanian newspaper is betting on the lesser-known Firebird SQL server for its B-to-B Web applications.Two years ago The Examiner, based in Launceston, Australia, began investigating software for its new online B-to-B initiative, which started as proof-of-concept, so a "cheap" database that could handle hundreds of simultaneous users was sought by the company\u2019s systems developer, Nigel Weeks.Weeks started out with MySQL, which is "brilliant for light reads and simple queries," but "curls up its toes" when it comes to complex queries and business logic."Firebird uses a very similar query structure to MySQL so any developer can switch," Weeks said. "It\u2019s just getting your head around transactions, but once that\u2019s done there is a whole world of possibilities."Firebird is a community project based on the InterBase source code originally released by Borland in 2000. The Firebird Foundation is now based in Glenning Valley, New South Wales.Weeks praised Firebird\u2019s "super server" architecture, which is a "drop-in replacement" for MySQL and can do whatever MySQL can do "with its eyes closed."The Examiner now has six different Firebird-based applications that are available to the public, to which about 300 companies\u2014like automotive dealers and real estate agents\u2014connect each day.The applications are developed with the popular PHP scripting language and delivered by the Apache Web server on Linux, exactly like the 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\u2019s a DBA-less database. Backups can be done on the fly, so there\u2019s 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."News happens 24 hours a day, so we need it to go all day, every day," he said. "All development is done on a 166MHz Pentium machine with 64MB of RAM to force you to write good code."Support is reliable, Weeks said. Firebird\u2019s community support is good in that "if you don\u2019t get an answer back in 10 minutes, it\u2019s a bad day.""IBPhoenix provides commercial support and also does database recoveries," he said.Helen Borrie, IBPhoenix Firebird consultant and author of The Firebird Book, said IT departments should consider all the open-source database offerings to break free from the "shackles" of commercial products, but Firebird\u2019s interoperability is a "strong decider.""The SQL language implemented is highly conformant with the standards, [and] its application programming interface is available for all of the popular and upcoming languages and IDEs," Borrie said. "It slips easily into virtually any of the environments where database engines already have a place."-Rodney Gedda, Computerworld AustraliaCheck out our CIO News Alerts and Tech Informer pages for more updated news coverage.