There were some rumors going around that OSDBcon might get canceled, but I was just speaking to Zak and he confirmed that S&S, the company organizing the event, is committed to making the conference happen. Last I heard there are over 30 proposals with more coming in everyday. But the more the better! This years conference is being held once again in parallel with the International PHP Conference. However I think this is suboptimal. PHP developers for the most part are actively using open source databases already. Especially the MySQL guys have no trouble reaching the PHP guys with conferences dedicated to PHP. So it would be a good idea to to think about how to best get access to other audiences, like the Java and .Net crowd.

While there are some major annoyances with transactions in MySQL like causing an implicit commit when doing DDL statements, there are also slightly more subtle annoyances. A user just stumbled over a little annoyance in MySQL transaction handling and autoincrement. If you generate a new ID inside a transaction and rollback, the autoincrement counter is not decremented.

In order to make the transistion for users upgrading to new minor (middle number increment) and major (leading number increment) version of PHP easier, the PHP project has recently begun adding a README with upgrade information with new releases. This guide steps through any issues that users are likely to be faced when upgrading their PHP installations.

Yesterday I pushed out several MDB2 releases. I am hoping that the Firebird/Interbase and the MS SQL Server drivers will follow soon, once the relevant maintainers have completed testing. This was mostly a bug fix release cycle, though the changelogs ended up being suprisingly long. The biggest, or maybe craziest, feature addition was done to the SQLite driver. I got annoyed be seeing the driver fail so many of the unit tests because there is no support for ALTER TABLE in SQLite version 2 that I sat down and wrote up an emulation for it. Maybe someone has use for it. There is a lot of tricky code in there to properly read the current table layout like fields, indexes and constraints as well as the data which all should be merged with the changes if everything goes as planned. Needless to say its a somewhat risky operation, especially since SQLite does not support transactions for DDL operaitons.

Things are moving along nicely with the 2 Google SoC projects I am mentoring. Igor is already fairly far along on his project that will add of DML support into MDB2_Schema. If you grab CVS there is a little demo script. Igar has also fixed several issues in the DTD and added an XML Schema xsd that supports much more detailed validation. The main thing Igor will hopefully get time to improve is the API for the new validation class. This should make it much easier to write new parsers or validate existing array database definition structures.