Listing the Foreign Keys in a Firebird Database
We have just completed the code to reverse engineer a Firebird database and build the class definitions used by the Habanero framework
We have just completed the code to reverse engineer a Firebird database and build the class definitions used by the Habanero framework
Firebird 2.1.1 and Flamerobin 0.9 are added to altlinux.Also latest odbc driver for firebird and mono 2.0.1
AltLinux is an Linux distro that will be used in all the Russian Schools
Other related news about altlinux you can grab from google
[Ed:so this is a big thing , imagine that firebird will be available to every kid or school there , also in Brazil they will have linux on ~50,000,000 desktops for kids , what we need now is some good translated books and documentation]
The new IBProvider version:
Read details on: Firebird driver news channel
DbLinq is THE LINQ provider that allows to use common databases with an API close to Linq to SQL
Sphinx is a very powerful and popular free open source full-text search engine. A few days ago, Sphinx 0.9.8.1 was released. Vlad Khorsun and Pierre Yager made a patch for Sphinx to support Firebird. Their patches and Windows binary are available to download and try out.
It’s an great search engine used a lot in the LAMP world So now for example if you create and phpbb site with firebird back end , you can use sphinx for indexing and fast search. Another idea is : use it to index the whole database if you have large quantities of text and you need to search for keywords (an movie comments database for example)
Firebird mention on the Attlassian blog
The Firebird Project is already using JIRA for their Firebird RDBMS Issue Tracker. And now it’s even easier for developers to search, share and keep up to date with the Firebird Project using FishEye.
[ED: I like how the branches are presented in an good graphical way Also you can watch the changes for Firebird 2.5.x or the head for example ]
The combination of Cathedron and Firebird competed and won two times: this year and in 2004. During the 14 hour race a team of two people solve a realistic business problem.
The productivity during the race is about 10 minutes per function point. In large software companies the best projects require 6 to 10 hours per function point. This implies a 60 times higher productivity during the race. When the extreme conditions of the race are normalized and you triple the amount of time to fine tune and test the deliverables, the productivity is still 5 to 10 times higher.
The combination of Cathedron and Firebird allowed the team to rapidly create and change the basic application and the underlying database. During the 14 hour race over 70 small modifications where made to a database containing valuable test data! 99% of those changes were handled by Cathedron simply by changing the data model.
Cathedron can be downloaded from www.cathedron.com and is free for personal and educational use. Although the tool and documentation are still under development, the core features such as information/data modeling, (default) screen generation and the embedded Pascal scripts have been used in production environments for over 8 years.
Firebird 2.1 (version 2.1.0) is included by default in the Ubuntu 8.10 named Intrepid Ibex that was released on 30 October. To use it you might need this guide and also there is an repository with version 2.1.1 (recommended)
I (Dan Wilson) put together the procedure I used in order to get native and PDO firebird support working with PHP and CentOS 5. I was unsuccessful using the FAQ at http://www.firebirdfaq.org/faq191/, and couldn’t find any other tricks on the web that worked. So, I compiled from a fedora source RPM as follows
On Firebird Python mailing list there is an interesting thread about rewriting Firebird Python Driver
Here is Pavel response