It looks like MySQL AB is going about the code fork in a very methodical, gradual, and thoughtful fashion. The latest Community release seems evidence of this. It was released as source-only, as promised, however it was announced that since no community contributions have been made to the community tree, the release was made from the Enterprise tree. In effect, the actual fork has not taken place yet. There is a community tree in evidence in BitKeeper, but it appears to be a placeholder only so far. The changes to date have been with regard to policy and procedure, not code.

I see this as a good thing. This gives MySQL time to evaluate reactions to these changes while implementing them in a gradual fashion. The changes appear well thought out and sound, and reflect changes in the community, the marketplace, and the customer base. It's important to balance all of these factors since they all play a part in the life of the product. …

Two weeks into the New Year, and four weeks since I got back from Thailand, I finally get round to updating this thing. By “updating”, I don’t just mean posting. Gojira the One-Lung Webserver has had an overhaul as well: I’ve added some more RAM, caught up with the last couple of months’ worth of Windows 2000 patches, updated to the latest versions of PHP, MySQL, WordPress, and Cygwin. (Tip: If you’re running PHP and MySQL on Windows, be sure to get rid of the libMySQL.dll that comes with PHP — because it’s crap — and to use the version that comes with MySQL instead.)

So… 2006 was a pretty decent year, with a number of positive changes:

• I got to see my daughter grow up some more. She’s just more amazing every time I see her.
• I got out of the hell-hole of a house that I’d lived in for 3 years. I must admit that I had some mixed emotions about that. I’d lived there …

While MySQL customers have been bitterly complaining about the move to package support and rigorous testing of binaries into a paid package, Stephen Walli of Optaros has been thinking:

What if Microsoft SQL Server open sourced their codebase, provided support and testing of binaries in a paid package similar to MySQL Network, and “DB mashups” ensued?

http://stephesblog.blogs.com/my_weblog/2007/01/microsoft_and_m.html

It’s an interesting read to get you thinking. Most of my thought was, “that’d be neat….I wonder if folks would stop complaining about the MySQL Enterprise and Community models if that actually happened.”

Flying to Boston this morning, I have a talk to give at MIT tomorrow, and will spend the rest of the week with the MySQL Falcon team.

So how is security this morning?

The raver chick in front of me in line had a "gallon bag" which the
agent spent ten minutes on trying to help her sort through. He
wouldn't let her friend take anything from the bag and pack it in her
own.

"Sorry, it is her stuff and she is limited to the advertised amount."

He helped her sort out the liquid items since she had the bag
completely filled.

He put the glitter in the liquid bag.

Glitter is a liquid?

Now it floats in air so it is sort of a fluid... not really.

This doesn't matter to me at all though.

Why is that?

Did I …

Continuing MySQL saga… This is actually a follow up on my previous post. Developers tried to rewrite all statements and even overdid it. As we say in Russia - “teach fool how to pray and he will break his forehead”. Note, I had to rename columns/tables as I write so sorry for possible typos Query converted by [...]

Last week I needed to write an update SQL script that would insert some records into a database. However as the script was to be incorporated into a software update that was going to be deployed to all our customers, it needed to check some condition first and see, whether the insert was required at all.

Even though MySQL provides some non-standard SQL enhancement there is no INSERT IF EXISTS kind of statement.

I managed to do it using some temp-tables and a combination of INSERT IGNORE ... SELECT FROM and UPDATE ... WHERE statements.

The following example demonstrates how to insert a new row of data in the table named real_table. The data must only be inserted into this table, if another record in a table named condition_table exists. No change of real_table must occur, if there is no record matching the condition.

Moreover (because I …

Last week I needed to write an update SQL script that would insert some records into a database. However as the script was to be incorporated into a software update that was going to be deployed to all our customers, it needed to check some condition first and see, whether the insert was required at all.

Even though MySQL provides some non-standard SQL enhancement there is no INSERT IF EXISTS kind of statement.

I managed to do it using some temp-tables and a combination of INSERT IGNORE ... SELECT FROM and UPDATE ... WHERE statements.

The following example demonstrates how to insert a new row of data in the table named real_table. The data must only be inserted into this table, if another record in a table named condition_table exists. No change of real_table must occur, if there is no record matching the condition.

Moreover (because I …

From Rishab's excellent report came a few graphics that I thought worth calling out separately from the report itself. It's interesting to see how Europe's adoption and usage of open source compares with the US'. Here are a few slides (from IDC and Optaros - its report is here [Registration req'd]) that depict the differences.

First, here are the open source applications most prevalently used in Europe:

Compared to the US, first large ($1B+) enterprises:

And then mid-sized companies ($50M - $1B):

I will be spending the coming week in Washington, DC to attend a four day MySQL performance tuning training session.

I believe Tobias Asplund will be the presenter. During the MySQL conference last year (then known as MySQL Users Conference), I attended a three hour performance tuning session presented by Tobias and Peter Zaitsev and enjoyed it very much so I cannot wait to attend this one.

The training will be held at MySQL's training facility in downtown Washington, DC.

I will be staying at Washington Suites in Georgetown, DC. Their suites are less expensive than many hotel rooms.

A big thanks to …

Convert Flash Video (.flv) to AVI (.avi) or MPEG (.mpg) - lifehack.org: "Convert Flash Video (.flv) to AVI (.avi) or MPEG (.mpg)Hitrec at VideoHelp forum introduces a software called RivaFLVencoder which able you to convert .flv files (Flash Video) into avi and mpg files. This is extremely useful when you download youtube or google videos and you don’t like it play in flv player. With this