With the release of MySQL 5.0.15, the first 5.0 build to be marked as a production release, I also release my blog to the public.

You'll read about my experience handling the transition from 4.1 to 5.0 and using all it's new features, on my personal web page as well as in the company work I do for MeteoNews GmbH and RADIO TOP.

It took me a little longer to release my blog, as I wanted to write a little blog/feed/cms on the LAMP stack from scratch. And yes, it's actually LAM5P!

So let's see one first example of how I used the new features of MySQL 5.0.

Use of a TRIGGER to generate feed IDs

My blog uses an …

it’s annoying. grr.

but, on the other hand, I am speaking about MySQL 5.0 at OSDC.

This is even cooler as 5.0 has gone GA. So it’s not “upcoming features” it’s the “here and now”.

I’ll now have to release MemberDB 0.4 (the MySQL release). Converting the Linux Australia installation over at some point soon too. The 0.4 tree fixes enough bugs that it’s worth it (one of which Pia found the other day).

I am in Montreal for the week to attend a pair of MySQL training sessions as an observer:

MySQL 5.0 In Depth Workshop
MySQL Performance Tuning and Optimization Workshop

Watch this space for notes.

Of course the current contest is attracting much interest, but there was the earlier MySQL 5.0 Beta Challenge for which a winner also needs to be announced.

And the winner is... Roland Bouman. He has been very productive together with Andrew Gilfrin. But what really stood out was his Diagram of the MySQL INFORMATION_SCHEMA. I think that effort is so worthy that I've upped the Beta Challenge main prize to be an iPod nano as well.

Congrats, Roland!

IP Concerns are very real; I’ve had a couple of customers bring them up in the past. It boils down to trust; It doesn’t matter if you and a thriving community have written the best code in the world; without someone to vouch that all proper measures were taken, there is an increased risk associated with your project.

This is the second time I’ve heard IP as one of the motivations behind the Zend Framework.. The first time was from David, and now there’s this line from Wez.

I never used to think about clean IP. I knew that some organizations, such as the Apache Foundation, make committers sign contributor license agreements, but as I am not an ASF contributor, it wasn’t something I had to deal with.

That’s changed now that I’m …

SteelEye Technology, Inc., the leading provider of data and application availability management solutions for business continuity and disaster recovery on Linux and Windows, today announced its membership in the MySQL Network Certified Partner program. As a member of this program, SteelEye and MySQL will work together to facilitate the integration of MySQL into the current IT networks of enterprise customers and to ensure full availability against downtime for these environments.

There are two calls for papers open right now for two great conferences: The 2006 MySQL User Conference and the 2006 PHP Quebec Conference.

Both conferences are excellent and I have loved being a speaker at both. I will be submitting for the MySQL conference but cannot attend the PHP Quebec conference (which I regret because it was an awesome conference).

I'd suggest you submit if you have something you would like to present, both conferences treat their speakers very well.

Calls for papers:

MySQL UC
PHP Quebec

Among the more time consuming things maintaining this blog is formatting the code examples. I decided it was time for me to take that to the next level so I wrote a HTML formatter for mysql code. In case you're interested, it's available for download (zip 7kb). After downloading, just unzip it to your favourite folder, read the readme.txt, and everything should be fine after that.
I will spend the rest of this blog entry on some explanation and examples.
The Function format_mysql_as_html()
Here's the function that's responsible for actually creating html from mysql code. It is passed a string parameter via p_sql, and cuts that to bits: the tokens.
Dependant upon the type of the token maintained by v_state, it's wrapped into a tag or left just as it is. The is given a class attribute …

The WSJ is reporting [Subscription required] that AirTran Airways may stop serving Anheuser-Busch products on its flights because of Bud Light ad that pokes fun at discount airlines. One representative quote from the commercial: "Sure we're concerned for our lives," the discount airline pilot/announcer says, "just not as concerned as saving nine bucks on a roundtrip to Fort Myers."

Pretty funny, actually. But not to AirTran and others (Southwest's spokesman said the ad was "Totally tasteless. To joke about safety is awful. It's out of bounds." I guess Southwest doesn't want to be compared to ValuJet, but isn't it fair game to make that association?

Regardless, unless these discount airlines see some truth in the ad, why do they find it …

All -

I’m very proud of the MySQL 5.0 GA release today! Without question, our engineering team deserves a lot of accolades and pats on the back for a job very well done.

Last week, I was visiting a number of industry analyst groups and magazines, and was discussing the upcoming MySQL 5.0 GA release. It was very encouraging to hear them tell me (rather than vice-versa) what an important release this is for MySQL. Many shared with me their belief that 5.0 will open up many new areas of opportunity for MySQL that previously didn’t exist. Obviously, I think so too…

One last exciting nugget I wanted to share: dynamic SQL support in MySQL 5.0 stored procedures is now official! This means you can code dynamic SELECTs and other statements (DML, some DDL, etc.) within your stored procedures. For example, you can use the below proc to get accurate row counts for tables that may have outdated counts in the data dictionary: …