PostgreSQL – Firebird comparison – updated
Google led me to a comparison sheet about PostgreSQL and Firebird by AMSoftwareDesign, as it looks a bit outdated I decided to add some infos about the latest Firebird release, see it in action
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Setting up ColdFusion and Firebird
After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.
Another great new feature of Firebird 2.5
Other than CREATE USER something really valuable has been added, the ability to query other databases.
Firebird SuperClassic – Another option
Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0.
Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic.
Basically SuperClassic is like ClassicServer. Only instead of a process for each attachment it uses a single process with a thread for each attachment. The benefit being that it uses fewer kernel resources and is a bit faster.
Read a deeper comparison between the three architectures.
Apache, PHP and Firebird Performance Tuning
In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do.
The only major changes from the last post is that I’ve now upgraded the database engine to the “Firebird v2.5 Alpha 1” that supports SMP, and that the application now contains more base data in the tables.
Firebird 1.5 Language Reference Update is Published
The Firebird Documentation Project coordinator (Paul Vinkenoog) is pleased to announce that the first volume of the Firebird Language Reference Update series, for Firebird 1.0.x and 1.5.x, is now available in both HTML and PDF formats. Other volumes will follow, each encompassing a macro release. Translations are under way.
Latest FBLib for Delphi/Lazarus
At the moment (well, for the last two years now) we only use FBLib.
The original author is nowhere to be found, so I started maintaining
or rather fixing the issues we deteced. For our latest FBLib, you can
get a update from tiOPF’s project on SourceForge.net.
Solaris and the 256 File Descriptor Problem
Some of you reading this may remember that back when InterBase 6.0 was released on Solaris we ran into a fundamental problem on Solaris. It seems that since 1992 there has been an open bug documenting Solaris’ file descriptor problem: “32-bit stdio routines should support file descriptors >255.”
PHP Firebird driver á la ActiveRecord
A very useful Firebird driver for performing most CRUD database operations in PHP.
Firebird QLI scripts documentation
Does someome have any links or documentation for qli.exe?
I recently used qli.exe scripts for fixing BD structure corruption as described in this article , since then and I’ve been searching for information about qli commands or scripts but it seems not to be so much information about it.
Near the bottom of this page is a download link for the qli syntax document from InterBase 3. Qli hasn’t changed.
Update: QLI is deprecated and unsupported fore firebird > 2