Top 7 Free Open Source DB Servers
Article on “Simple Thgoughts” mentions Firebird. There is poll in the article about “What is your favorite DB server” and you can vote for Firebird right now (no need to register).
Article on “Simple Thgoughts” mentions Firebird. There is poll in the article about “What is your favorite DB server” and you can vote for Firebird right now (no need to register).
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.
The XP team is proud to announce the release of 5.7.4. This release features various improvements to the rdbms API:
The latest sneak preview showcases expanded database connectivity for more than a dozen platforms including Oracle, Microsoft SQL Server, Sybase, MySQL, InterBase, IBM DB2, and more, plus new support for the popular Firebird SQL database (…) “The 2010 releases will add highly requested support for Firebird SQL, the popular open source database which is based on Embarcadero’s InterBase database platform.”
Read full article at JDJ.
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
This link will show a list of QC requests that were covered by the Delphi Development Team in version 2010. Interesting enough, from the 82 items listed, 8 are requests for official Firebird support.
Better late than never 😉
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