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
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+
* MSSQL (mssql) – MSSQL 2000+
* MSSQL through ODBC (mssql_odbc) – MSSQL 2000+
* MySQL (mysql) – MySQL 3.23+/4.0+/4.1+
* MySQL4 (mysql4) – MySQL 4.0+/4.1+/5.0+
* MySQLi (mysqli) – MySQL 4.1+/5.0+
* Oracle (oracle)
* PostgreSQL (postgres) – PostgreSQL 7.3+
* SQLite (sqlite)
“There is no way we would be able to raise the money required to buy a commercial Oracle license.”
“I believe the XE edition is a max of 2gig. htmldb would be free for that, but by the time you add htmldb overhead and users, I gotta think this site has way way more data than what is left out of the starting 2gig. … Standard Edition One would be the next option, at 5 grand per proc.”
maybe oracle will toss a free license their way, but this is a great case study on how useless oracle’s free offerings really are. (to contrast, of course, mysql’s free offering is fully-featured, with no artificial limitations. same with other truly free databases like firebird or the open-source versions of postgresql.)
[ED: this is the blog of the day ]
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:
My belief is that we (Coverity) must reach out to the developers of
these packages (you) in order to make progress in actually fixing the
defects that we happen to find, so this is my first step in that
mission. Of course, I think Coverity technology is great, but I want to
hear what you think and that’s why I worked with folks at Coverity to
put this infrastructure in place. The process is simple — it checks out
your code each night from your repository and scans it so you can always
see the latest results.
Right now, we’re guarding access to the actual defects that we report
for a couple of reasons: (1) We think that you, as developers of
Firebird, should have the chance to look at the defects we find to patch
them before random other folks get to see what we found and (2) From a
support perspective, we want to make sure that we have the appropriate
time to engage with those who want to use the results to fix the code.
Because of this second point, I’d ask that if you are interested in
really digging into the results a bit further for your project, please
have a couple of core maintainers (or group nominated individuals) reach
out to me to request access. As this is a new process for us and still
involves a small number of packages, I want to make sure that I
personally can be involved with the activity that is generated from this
So I’m basically asking for people who want to play around with some
cool new technology to help make source code better. If this interests
you, please feel free to reach out to me directly. And of course, if
there are other packages you care about that aren’t currently on the
list, I want to know about those too.
If this is the wrong list, my sincerest apologies and please let me
know where would be a more appropriate forum for this type of message.
Many thanks for reading this far…
Chief Technology Officer
Windows (setup & zip), Linux (gtk1 & gtk2), Mac OS X and source packages are available for download. Enjoy.
– DDL extraction for all object types
– Rebuild View option (drop and recreate dependent objects)
– Option to drop database
Enhancements and Bug fixes
– TCP port setting is not longer ignored when creating, backing up and
– New dialog for index creation.
– Field properties dialog can now be closed when no changes are made.
– Main tree control now behaves natively on all platforms.
– Progress dialog when connecting has ability to cancel
– Windows: FlameRobin doesn’t destroy Clipboard contents when exiting
– Gtk2: Reduced font size for property pages.
– Gtk2: allow user to enter filename in dialogs.
– Other minor UI improvements.
– Faster disconnecting.
– Faster startup of SQL editor, statement history stored in separate files.
– Warn when copying data from the grid and not all rows have been fetched.
– If error happens while executing selection, the executed statement is
selected in SQL editor.
– Fixed problem with context menu and large selection in SQL Editor.
– Fixed hiding of SQL editor behind other windows.
– Data grid is now scrolled by rows
– Triggers can be added/dropped from table’s “Triggers” page.
– Take character set and collation into account when adding new columns.
– Configurable columns (default value, description) on table’s property page.
– All UPDATE statements were treated as DDL. Fixed.
– Fixed bugs in statement parser.
– Preserve character sets when altering procedures.
– Added missing whitespace between AS and procedure source.
– Privileges are restored after ALTER VIEW.
– Property pages are now updated after ALTER INDEX and SET STATISTICS
– Custom charsets are now really used when connecting to database.
– Logging can now log SET TERM statements if desired.
– Logging now detects if target directory doesn’t exist.
– Updated documentation about building FlameRobin.
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.
4 – Minor feature enhancements
ibWebAdmin is a web based admin tool for the InterBase and Firebird
database servers. Beside creating, modifying, and deleting of
databases, tables, domains, generators, triggers, indices, and users,
it supports import and export of data in CSV file format. It features
browsing through tables and entering/editing of data, including
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.
[Ed: so firebird 2.0 rc1 will be here soon , and only bug fixes will be allowed]
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