After reading a post in the Firebird forum at Devshed I immediately put up a small example about writing a trigger (and also upgraded my favourite tool, Flamerobin, to the latest version) , here it goes [ED:tutorial written by pabloj]
For those of you data hounds out there that use open source databases.
May I suggest the excellent Firebird, coupled with IBexpert, as opposed to mySQL.
I have found it a heck of a lot easier to design and implement stored procedures. It is open source and rock solid.
That is J. J. Walter’s opinion about firebird , expressed in his blog.
Meik “Acyd Burn” Sievertsen, phpBB’s Development Team Leader has just announced that the bug tracker for phpBB3 née Olympus is now open
Supported DBMS
Though developed using MySQL, the wonders of a DBAL means phpBB Olympus already supports a wide number of databases:
* Firebird (firebird) – Firebird 1.5+/Interbase 7.1+
from this thread on the orafaq forum:
“There is no way we would be able to raise the money required to buy a commercial Oracle license.”
Hello Firebird Developers,
I’m the CTO of Coverity, Inc., a company that does static source code
analysis to look for defects in code. You may have heard of us or of our
technology from its days at Stanford (the “Stanford Checker“). The
reason I’m writing is because we have set up a framework internally to
continually scan open source projects and provide the results of our
analysis back to the developers of those projects. Firebird is one of
the 32 projects currently scanned at:
Windows (setup & zip), Linux (gtk1 & gtk2), Mac OS X and source packages are available for download. Enjoy.
New features
– DDL extraction for all object types
– Rebuild View option (drop and recreate dependent objects)
– Option to drop database
Enhancements and Bug fixes
The changes in this release are as follows:
Connections to Firebird 2 database servers are now supported, a Czech translation was added, and this maintenance release fixes the few minor issues reported over the last few months.
http://freshmeat.net/projects/ibwebadmin/
The RC1 tag is going to be set this week. If anybody has pending commits,
please do them. If anyone has some work in progress regarding non-regression
bugfixes, please complete it ASAP. Starting with the next week, only
regressions will be fixed.
Dmitry
[Ed: so firebird 2.0 rc1 will be here soon , and only bug fixes will be allowed]
Gianugo kicked off good discussion on a mailing list (message reposted to the
Feather blog). It gets at an idea that has been floating around for a
good
while, that Open Source does not equate to Open Development, and
while the difference is glaring obvious to folks who have been
around open source for a while, it is not so to many others.
Now there seems to be a clear response. MySQL has hired former Firebird developer Jim Starkey and MySQL has a new CTO: Taneli Otala – read Kaj Arnö’s interview with Taneli.
The final statement on this interview declares a clear goal: “Definitely. I want to be part of the team building the world’s best database!”. The times when MySQL targeted itself mainly to drive small and medium web based applications are definitely over!
Read more on db4free blog
