Parallel with last years international PHP conference the folks at S&S organized a novelty: an open source database conference. It was a great success. We had people from most projects for end users to talk to: PostgreSQL, BerkleyDB, MySQL, SQLite, Apache Derby, HSQLDB, Firebird and MaxDB. I hope this year Ingres will also make it and maybe a few others I do not even know yet! For the projects themselves it was a great opportunity to sit down and discuss about the potential for cooperation. The conference will be held again, same time same place. So mark your calendar November 6th-8th opendbcon 2006 in Frankfurt germany.

I fixed a serious BC issue that I introduced in the last releases of the MySQL drivers, that would cause issues with servers that do not support InnoDB. I switched to forcing the InnoDB table handler. The fix is to simply not force any table handler and use the server default. There were also some minor bug fixes in several of the other drivers. More importantly however I am pretty happy with the nested transaction API as well as improvements to the debug callback mechanism.

Igor is doing great work on moving forward the XML based database schema format originally developed by Manuel Lemos as part of Metabase that is used in MDB2_Schema. The idea is to add the ability to also handle UPDATE and DELETE statement next to the currently supported CREATE, DROP, ALTER and INSERT statements. This format is even supported by DBDesigner4 and the DatabaseSchema ez component. For the uninitiated if you: The idea behind this schema format is to make it possible to define a single database schema that can be used to create, alter and initialize databases in any number of RDBMS. For example currently MDB2_Schema supports MySQL, PostGreSQL, Oracle, SQLite, MS SQL Server, Interbase/Firebird.

On the education front things are moving forward nicely. I now have confirmation that the only thing that stands between me and a degree in computer sciene is finishing my thesis paper. The paper itself is already well under way. I have all the literature research done and I have written the first 2 chapters and I am fairly far with the third chapter. I just send out a ton of email interviews. The general topic is open source in the relational database market. I will publish the paper on this site once I am done.

I have begun work on the next set of features for MDB2. I just implemented a feature inspired by the popular ADODB abstraction layer. John calls it smart transactions, while I am currently planning on calling it nested transactions. However I will wait until Lorenzo has some time to look at things to see if we can fit native nested transactions in there or not. Interbase/Firedbird really shines in this department.