Another great new feature of Firebird 2.5
Other than CREATE USER something really valuable has been added, the ability to query other databases.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
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
FB training videos (free)
From IBExpert Team: We have published new Firebird Training Videos on google video. The videos were recorded during the firebird Conference 2007 and gives you an introduction into the most important Firebird database technologies. The access to the videos (total about 8 hours) is free for everyone. IBExpert customer can find a link in the customer area where to download the videos in uncompressed avi format.
Firebird .NET provider for Entity Framework is back
By Jiri : Well, not so back as you might think, but the incompatibility between Beta 3 and SP1 Beta 1 is gone. I’ve done some new methods etc. so it’s now at least able to work in totally simple cases. In next weeks I’ll try to review all the changes and push the support little bit further. You can download current state from weekly builds.