Have you heard of MySQL Camp at Google HQ in Mountain View, California, November 10-12?

Want to go? Can’t go because it’s out in sunny (ha, ha) California, hundreds or thousands of miles/kilometers from where you live?

Maybe you’re a bright student, or maybe you’re currently unemployed, or maybe you’ve got a job, but you just can’t afford to jet out to Mountain View for the weekend. Maybe you contribute code, bug fixes, tools; maybe you run a MySQL Meetup, and just can’t bear the airfare.

Proven Scaling would like to sponsora one such person to attend MySQL Camp! We’ll pay for your airfare and hotel—meals and transportation are on you. If you think you are qualified, you live somewhere in the USA or Canadab and you …

If you can remember back to mid ‘05 when MySQL 5.0 was being released there was something missing. I have been thinking about writing about MySQL 5.0 being released too soon but I don’t think that was the case. Was 5.1 released too late? Maybe. Was something wrong with the 5.0 -> 5.1 schedule and feature set? Oh yeah.

Looking back at the change logs for 4.1, 5.0, and 5.1 I noticed something that I hadn’t though about before. I knew there was a difference in the release dates for 5.0->5.1 from 4.1->5.0 but I didn’t realize how drastic the difference was until I drew it out (on paper, sorry) today. Here is a summary of the major milestones from 4.1 Alpha to today:

• Apr 03 - 4.1 Alpha
• Dec 03 - 5.0 Alpha
• Jul 04 - 4.1 Beta
• Aug 04 - 4.1 Gamma
• Oct 04 - 4.1 Release
• Mar 05 - 5.0 Beta (Where is 5.1 Alpha?)
• Sep 05 - 5.0 Gamma.
• Nov …

I greatly admire the works of the Dutch literary author Gerard Reve (1923 - 2006). On many occasions, he was asked whether his stories were real-life stories, and he always answered like this:

If you mean "did this sequence of events factually take place?" then I can be brief: No. And that's a good thing too, because if a writer would describe reality, the result would be very hard to believe, if not completely inconceivable. The course taken by real life is just too crazy. A true description is bound to be seem like a constructed mannerism and no reader can be expected to believe even one word of it.
However, as far as the single events are concerned, I exclusively use only those things bourne from reality.

If you ever read The Daily WTF you will probably agree that this point of view …

MySQL Enterprise — Double your DBA Staff without Adding Headcount, MySQL (Press Release)

Ingres Opens Its Doors in India to Satisfy Growing Demand for Business Open Source Software, Ingres (Press Release)

Free Standards Group Teams with O?Reilly Media to Offer Linux Developer Services, Free Standards Group (Press Release)

Hyperic Enhances Enterprise-Class Software Security, Hyperic (Press Release)

Zimbra Soars Past Four Million Paid Mailbox Milestone, Zimbra (Press Release)

…

There's a slightly humorous interview with Steve Jobs in NewsWeek by Steven Levy about the success of the iPod.  Jobs does a good job providing some insight into what makes products successful.  But his comments on Microsoft's forthcoming Zune portable audio player sound like like's giving dating tips:

Q. Microsoft has announced its new iPod competitor, Zune. It says that this device is all about building communities. Are you worried?
In a word, no. I've seen the demonstrations on the Internet about how you can find another person using a Zune and give them a song they can play three times. It takes forever. By the time you've gone through all that, the girl's got up and left! You're much better off …

This is the fourth in a series of articles on profiling MySQL. My past three articles have explained how to measure the work a query causes MySQL to do. In this article I introduce a tool I’ve written to do the work for you and produce a compact, readable report of that work, with all the math already done, and the measurements labelled and grouped for ease of comprehension. With this tool you can understand query performance at a glance.

ZCS 4.0.3 includes fixes for 55 bugs and enhancements. It has significant improvements in calendar behavior and fixes a bug in Trash folder viewing that was troubling many folks. It also includes upgrade speed improvements. This allows the upgrade to take much better advantage of installs that have multiple disks available to MySQL.

Zimbra - Forums - Zimbra Collaboration Suite 4.0.3 Released

ZCS 4.0.3 includes fixes for 55 bugs and enhancements. It has significant improvements in calendar behavior and fixes a bug in Trash folder viewing that was troubling many folks. It also includes upgrade speed improvements. This allows the upgrade to take much better advantage of installs that have multiple disks available to MySQL.

Zimbra - Forums - Zimbra Collaboration Suite 4.0.3 Released

Ok, someone came in #oracle on freenode and wanted a query that would give him a distinct set of rows, where it did not matter if a values is in the first or second column.

Here is a sample table:

CREATE TABLE t (
  a int(11) NOT NULL,
  b int(11) NOT NULL
);

INSERT INTO t (a, b) VALUES (1, 2);
INSERT INTO t (a, b) VALUES (2, 1);
INSERT INTO t (a, b) VALUES (3, 4);
INSERT INTO t (a, b) VALUES (3, 6);
INSERT INTO t (a, b) VALUES (4, 3);
INSERT INTO t (a, b) VALUES (6, 3);

The output should be something like:

(1, 2), (3, 4), (3, 6)
OR
(2, 1), (3, 4), (3, 6)
OR
(6, 3), (2, 1), (3, 4)
etc ..

You get the drift ..

A self join solves the challenge, though we were wondering if any RDBMS out there could do it without a self-join by just using funky analytic features. Any RDBMS specific magic goes (except for implementing a join inside a stored procecure of course). Lets see what …