ramblings on PHP, SQL, the web, politics, ultimate frisbee and what else is on in my life
back

MDB2 progress

So it seems that my original plan of just a few RCs for MDB2 did not go through. I am now at RC4. I have spend alot of time over christmas just reading the source up and down. That way I found a number of bugs and ugly spots that I fixed within those 4 RCs.

Also I am very happy that most PEAR developers have accepted my patches to add MDB2 support. This means that soon most PEAR packages should provide MDB2 support. Especially Mark Wiesemann has been very helpful in prodiving feedback and patches as he was expanding my original patches for DB_Table. This has helped alot in finding little bugs as well problem in the way we were handling the "seqname_format" and "idxname_format" option with legacy databases not created with MDB2.

I encourage everyone to play around with MDB2 so that we can uncover any potential internal deficiencies that may still lurk somewhere in the code. I am really trying to solve all kinks that might lead to BC issues down the road now before going stable. The actual bugs I am solving are in fringe cases for the most part (especially in some of the modules). So you should only really run into issues if you start using some of the advanced features you will not find anywhere else and usually I have a very quick turn around time in fixing bugs.

The mysql and mysqli drivers (though I am really not happy with the internal mysqli API) are looking very good. Same for the pgsql driver. The sqlite driver is still missing a userland emulation of ALTER TABLE, but looks very solid otherwise. The querysim driver seems to work as expected, but could use some more flexibility in the way you can pass data to it. The oracle driver is continuously updated but I am only porting fixes from other drivers to it. The oci8 extension is just too buggy on windows and I have not spend time on figureing out how to get a backtrace on windows (my testing platform). So until I have some commercial interest in expanding the oci8 driver it will mostly sit in maintainance mode. The mssql driver needs some love to get the little kinks out. The fbsql driver looks like it will end up bit rotting. I still need to find time to work on a PDO based driver (patches welcome as always). I would really like to have something PDO based in my hands before going stable.

Anyways thank you again Mark for continuously prodiving high quality bug reports with accompanying patches. Not to be forgotten Lorenzo is a great help as well of course. Working on the Interbase/Firebird as well as commenting on the general design of MDB2.