Content not direct related to FB, but interesting reading.
New snapshot builds (SVN revision 2210) for Windows 32 and 64 bits are
available on SF.net.
Feedback on field and text delimiter settings for save grid data as CSV
file command would be especially welcome.
Thanks
—
Michael Hieke
From http://ramsees.blogspot.com:
I did some comparitions selecting 1000, 10000 and 100000 with Ruby Fb gem, Delphi Fibplus and the FB .NET driver, here is the result:
| ROWS | RUBY | DELPHI | .NET |
| 1000 | 0.12 | 0.47 | 0.09 |
| 10000 | 0.94 | 0.48 | 0.53 |
| 100000 | 10.95 | 3.79 | 5.53 |
The results are on milliseconds, the table is from a production database with 40 fields and about 3 million records, as you can see, native code is still the king, .NET result are quite good, but Ruby is quite dissapointing handling lots of data.
Video uploaded to FirebirdSQL channel on Youtube
Marco Cantu speaks about best practices and approaches to develop Firebird and Delphi applications with dbExpress framework.
This post will show an example of using an embedded firebird database in .NET/C# projects.
You can check his tweet and the package page in ArchLinux:
Just updated #php-pdo-firebird package in #ArchLinux User Repo to connect to @FirebirdSQL from PHP 5.3.9. #Firebird http://t.co/XyeaRJE0
If you find this package useful and want to have it in the community repository, please Vote Up!
Question of the day on Stack Overflow is :
How to make an efficient check constraint for an e-mail field in Firebird (if field value not null)?
A question came to me last week. It was simple. Given the column I’d like to query all tables in database for this column (with some condition) and get values back. It was on Firebird so I jumped into system tables and generated query on the fly in execute block (aka anonymous stored procedure).
Read the rest on Jiri Cicura blog
This article shows how to use Data Abstract for .NET and Firebird Embedded together (and that it’s no effort at all to do this). All you need is to deploy the needed dll’s and to remember about the x86/x64 compatibility caveat.
It was just released the first webinar video from the Mind the Bird campaign. The webinar is about the history of Interbase and Firebird, by Ann Harrison.
Yesterday the second issue of Firebird SQL Project newsletter was delivered to all subscribers. This issue includes announcements of official Firebird channels at YouTube and SlideShare, the full list of materials from Firebird Conference 2011, and also digest of recent community news.
You can read the second issue online.
