dbExpress driver and Firebird in Delphi (UIB)
Article with dbExpress driver (uib) in Delphi and Firebird . Article is in Portuguese
Article with dbExpress driver (uib) in Delphi and Firebird . Article is in Portuguese
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.
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.
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?”
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
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.
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.
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
Capabilities in the suite include native support for the Firebird open-source database. “Firebird is one of the most used open-source databases out there, like MySQL,” Rozlag said.
Read full article in Computerworld.
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 ]