Firebird 2.1.2 Changes in Ubuntu Karmic and Debian
New packages for Ubuntu karmic and debian unstable are released with security and bug fixes
Here is the change log for the firebird2.1 (2.1.2.18118-0.ds1-4) package in Ubuntu Karmic and Debian Unstable and Testing :
* add patch from upstream CVS fixing denial of service (daemon crash)
via a malformed op_connect_request message (CVE-2009-2620)
Closes: #539478. Thanks to Giuseppe Iuculano
* rules: disable parallel MAKE
the targets are now chained so no simultaneous satisfaction of classic and
super build can commence. also, upstream sources aren’t to be made in
parallel so pass -j1
Closes: #538870. Thanks to Bastian Blank
dbExpress driver and Firebird in Delphi (UIB)
Article with dbExpress driver (uib) in Delphi and Firebird . Article is in Portuguese
TPDA (Tiny Perl Database Application) 0.6 released
TPDA (Tiny Perl Database Application) is a classic desktop database application framework with support for Firebird, PostgreSQL, and MySQL. The goal of this project is to make database applications more flexible and accessible for every user.
Firebird – query to show which fields in your database are not based on a domain
Our strategy is that in all of our InterBase and Firebird databases, the column definitions are based on domains.
But some of our databases do not have that for all columns (usually because we got involved later in the development cycle).
When you forget to define a column based on a domain, then both InterBase and Firebird will create a new system domain on the fly that starts with ‘RDB$’.
So if you forget, you get a new system domain for every column!
The below query will list those columns.
Cache flushes to disk and Firebird
Paul Beach wrote on his Blog
The following fragment of a message appeared on the Firebird development list. As the question and answer are interesting, I thought I would put it on the blog.
“If I want to make cache flushes to disk very rare, do I set MaxUnflushedWrites & MaxUnflushedWriteTime to -1 or to some large value?
What other settings adjustments can make table flushes to disk more rare?
Is there any combination of settings that will keep the entire db in cache and never flush it to disk?”
Embarcadaro Rolls Out RAD Studio 2010
In the list of important changes :
Firebird support. Delphi now has native support for what Embaracaro
claims is the most deployed open source database in the world.
http://www.ddj.com/development-tools/219300166
Embarcadero Change Manager
Gordon Lucas, from Embarcadero, just dropped me a note about Embarcadero Change Manager product support for Firebird, saying that work is well undersway, and a sneak peak preview video is available at http://www.youtube.com/watch?v=WUCFSPfKOlY
More info here.
DDL execution architecture in Firebird – why we need to move on
Posted By Adriano dos Santos Fernandes on his blog:
Here I’m going to explain how Firebird DDL commands works in the architecture, why it stops innovation and how it is supposed to work in Firebird 3.0.
New IBProvider 3.0.0.7575 with queries pool and enhanced working with Delphi.
Performance optimization for repeated queries
New IBProvider v3 has the pool of SQL-queries that stores prepared and created commands and allows substantial time saving with a large number of repeated queries for Firebird.
Support of tables list getting in Delphi in Client Cursor Engine mode
Tables list getting has been brought into compliance with the requirements of dbGo components in Client Cursor Engine mode.
Attention! Special offer!
20 % discount for any IBProvider license is valid for 4 days only.
Please read details here: query pooling in Firebird

