Technical articles, How-tos, guides, etc.
Douglas Tosi wrote about why is recommended to do the upgrade in a short like review (If you don’t want to parse the changelog yet)
Yesterday Firebird 2.1.3 was made public. As with all maintenance releases its focus is stability. A number of bugs are fixed and it is a recommended update for everyone using older versions of the 2.1 series
Via twitter status post
Lorenzo wrote another impressive sql article :This morning a new article of yours truly has been published on the TechPortal. The title is Graph in the database: SQL meets social networks, and it’s a natural sequel to my talk aboutTrees in the database.
You will learn how to retrieve linked nodes, and how to answer some of the queries typical of social networks like LinkedIn, Facebook, or recommendation systems (“You might also know/like”, “How you are connected to XY”, …).
Here is what Milan Babuskov wrote about his experience with Linux Slackware and Firebird related packages on x64 system :
I just installed Slamd64 version 12.2. I know that Slackware -current is 64bit and Slackware 13.0 is out, but out-of-the-box 32bit compatibility of Slamd64 is very tempting, so this is the first 64bit slackware I installed.
Install went fine, and KDE is running in a matter of seconds. Now, time to compile all the needed stuff for development. Basically, all I need is Firebird, FlameRobin and PHP extension for Firebird (i.e. InterBase).
Lars (from Compas Pascal blog) talks about the usage of IBX with Firebird databases. Don’t forget to check the comments for interesting information about compatibility.
The question is on StackOverflow:
I am trying to choose between postgre and firebird databasses. The database will be installed on a windows 2003 server with asp.net 3.5. i don’t want to use sql server because of price issues and I don’t want MySQL I had a bad experience with it and the .net connector and the membership provider.
Douglas Tosi wrote on his blog :
This week I received the Brazilian Active Delphi magazine with a pleasant surprise. My very fist published article.
Jeff Overcash originally made it clear, that IBX doesn’t officially support Firebird, and he has no intention to implement it. Many point at IBObjects and now DBExpress for Firebird support, so why use IBX? Here’s a reason
Another interesting email conversation between a developer and Dimitry Yemanov (Firebird core developer) produced this information
We have made 1 terabyte database test with Firebird 2.1. Read more. Questions?
Summary
In this experiment Firebird shows the following resultsUndoubted ability to handle big databases. We are pretty sure that it’s possible to create and use 32 Tb database on appropriate hardware, and Firebird will show the same high performance as it shows for smaller databases (i.e., 1Tb and below).
Good scalability and amazingly small footprint. 1Tb database was created at usual desktop computer and, more important, it can be used to perform general queries: if you don’t fetch millions of records, query’s speed is the same as it is for moderate size databases (10-15Gb).
Using hcOPF (persistence framework for delphi) example with Firebird 2.0
