dbExpress driver and Firebird in Delphi (UIB)
Article with dbExpress driver (uib) in Delphi and Firebird . Article is in Portuguese
Author: mariuz
http://wiki.ubuntu.com/Mariuz
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
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.
The full analysis of Sourceforge CCA voting, including all finalist results
Do you like charts, graphs and number crunching? We have the full analysis of CCA voting, including all finalist results
Also you can watch the video with the announcement
“CCA09 Award – Best Project for the Enterprise”
[ED: i like the presenter speach : I’m not even drunk , I have a bad memory ]
Firebird 2.5 Beta 2 Kits Released
The Firebird Team is pleased to release the second Beta of the new Firebird 2.5 version for field-testing. 32-bit and 64-bit builds for Linux, Windows and MacOSX Intel are available. Download HERE and, as ever, send all feedback–hot or not–to the firebird-devel list. Have fun!
WebIssues Client 0.9.5 released
Version 0.9.5 of the WebIssues Client is available for download. Firebird support is added in Server version 0.8.4 if you read it in Changelog
Noteworthy Mandriva Cooker changes (27 July – 9 August 2009)
here were a lots of package updates in Mandriva Cooker during the last two weeks.Currently a complete rebuild of all packages in the Main repository is going on. Here’s a list of some more interesting changes
The Firebird database pacakges have seen many improvements and should start working well soon.