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 …

Hey all,

I hear that the collective "you" are annoyed by all of the technical bits on this blog. So I've decided to move non-personal blog entries to my movable type server at mt.colliertech.org. Specifically, work blog posts will be made to

http://colliertech.org/~cjcollier/mysql/

If this works well and I start making lots of posts, I will have the planet mysql aggregator point to the new atom feed:

http://mt.colliertech.org/mysql/atom.xml

good fun, that. For those of you who don't read this blog to get new and juicy bits of information about MaxDB and MySQL, rest assured that posts to this blog will now be easier to consume :)

Hey all,

I hear that the collective "you" are annoyed by all of the technical bits on this blog. So I've decided to move non-personal blog entries to my movable type server at mt.colliertech.org. Specifically, work blog posts will be made to

http://colliertech.org/~cjcollier/mysql/

If this works well and I start making lots of posts, I will have the planet mysql aggregator point to the new atom feed:

http://mt.colliertech.org/mysql/atom.xml

good fun, that. For those of you who don't read this blog to get new and juicy bits of information about MaxDB and MySQL, rest assured that posts to this blog will now be easier to consume :)

In this article, I'll give a preliminary description of a new MySQL feature for scheduling and executing tasks. In version 5.1.6, MySQL has added support for events. That is, you can now say: "I want the MySQL server to execute this SQL statement every day at 9:30am, until the end of the year" -- or anything similar that involves any number of SQL statements, and a schedule.

In the tradition of my 2003 and 2004 highlights, I'm posting my personal highlights of 2005. As in years past, this is mainly for my own benefit. I hope everyone has a wonderful 2006. :-)

• Launched the PHP Security Consortium (31 Jan)
• Interviewed for the first time (01 Feb)
• Launched Brain Bulb (28 Feb)
• Spoke at PHP Quebec for the first time (30 Mar - 01 Apr)
• Spoke at NOAA's IT Security Conference for the first time (04 May)
• Spoke at php|tropics (now …

Last week my laptop crashed and while installing the new one I decided to update my perl versions. I mainly use the DBD::mysql and DBD::Oracle modules and although I'm confortable building them on Linux/Unix, like most people I use the Activestate binaries on windows.

However it turns out that Oracle licensing changes now prevent Activestate from distributing an Oracle binary, so I was forced to build them from source. It wasn't easy, but now both the Oracle and MySQL modules are working. Here's the procedure in case it helps anyone.

Install Pxperl

Firstly, you probably want to move to the pxperl windows binaries. Pxperl support the familiar CPAN system for updates. Get Pxperl at www.pxperl.com. The installation should be straight forward.

I installed into c:\tools\pxperl

Install MinGW

You'll need a C compiler capable of building native windows binaries. I used the MinGW system. You can't …

I have lights on the front of my house!

Its been 15 months since that has been the case! I even have a
ceiling light in the entrance way. Sure... no ceiling, but I have a
light!

Amazing, my house now won't look like some sort of scary haunted
house from the street.

In other news I added bittype support to the archive engine in MySQL.
Eight characters to create.

Just have to love low hanging fruit....

I have lights on the front of my house!

Its been 15 months since that has been the case! I even have a
ceiling light in the entrance way. Sure... no ceiling, but I have a
light!

Amazing, my house now won't look like some sort of scary haunted
house from the street.

In other news I added bittype support to the archive engine in MySQL.
Eight characters to create.

Just have to love low hanging fruit....

As I mentioned in an earlier post: Brian Aker, MySQL's Director of Architecture, will be on a little grand tour of AU/NZ in the coming few weeks. Next week he'll be in Melbourne, speaking at the Melbourne MySQL User Group. Exact day/time: Wednesday 18 January, 7pm

If you're in Melbourne, do sign up (free) and RSVP for this event, Brian is an interesting guy.

As I mentioned in an earlier post: Brian Aker, MySQL's Director of Architecture, will be on a little grand tour of AU/NZ in the coming few weeks. Next week he'll be in Melbourne, speaking at the Melbourne MySQL User Group. Exact day/time: Wednesday 18 January, 7pm

If you're in Melbourne, do sign up (free) and RSVP for this event, Brian is an interesting guy.