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)
New: IBExpert Developer Studio 2006.03.15
Today we uploaded a new Version of IBExpert Developer Studio on www.ibexpert.com
What is IBExpert Developer Studio?
IBExpert Developer Studio is a combination of IBExpert and other Modules for professional Database Development. All customers of IBExpert have access to all modules, such as
-IBExpert Integerated Development Environment
-IBEScript.exe Commandlineversion for Executing Scripts
-IBEScript.dll Script API for using IBExpert Script in your own Application
-IBExpertSQLMonitor: A Proxy Server to monitor all SQL Statements send from any clientsoftware
-IBExpertLive: Watch the Videos from Firebird Conferences and other Events
-IBExpertBackupRestore: Automate your daily Backup Restore Jobs
-IBExpertTransactionMonitor: Avoid the Oldest Active Transaction Problem automatically
-IBExpertDemoDB: A collection of useful Demodatabases
In Non Customer Versions you will only have access to IBExpert IDE and IBExpertLive. The other Modules will only work on licensed computers.
Download for Customers: www.ibexpert.com/customer/setup_customer.exe
Trial Edition Download: www.ibexpert.com/download/setup_trial.exe
The IBExpert Team
“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
Recently the main page of the Firebird Foundation site got a facelift. Check it out and if you are not a member of the Foundation, maybe it is a good time to subscribe and help the economic viability of the Firebird project.
“IntraWeb Studio is a professional Content Management System (CMS). It enables you to edit and manage your website in a very efficient and cost effective way.
All of your files and documents for a web site are kept in a repository. The repository may be located on your development machine or on an external repository server (IWS Pro and up). The repository is implemented in an SQL based DBMS. Currently IWS supports FireBird, IWS Personal and Desktop edition use an embedded version of FireBird – no special setup is required.”
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