RAD Studio 2010 Review : Database Jewels
Perhaps after such a long wait, you will expect to say many things about the Firebird support in Delphi 2010. But I’ll say… just two words: just works.
Author: mariuz
http://wiki.ubuntu.com/Mariuz
Dibi – tiny’n’smart Database Abstraction Library for PHP 5.
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
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 ]