OSCON MySQL foo

Kaj writes:
We‘re happy with the quality [of 5.1]

More stable than 5.0 was four months after GA
A better MySQL 5.0 (thousands of small fixes)

This would be because 5.0 was a complete disaster in terms of GA quality. Peruse bugs.mysql.com, it’s all there. The number of open bugs around GA time, repeated API breakages (involving leaked symbols, [...]

|

Filed under: Uncategorized | by arjen
5 Comments »

magic group numbering in SQL select or update

I came up with the following trick in response to a question in the #mysql channel on Freenode. A user needed to create a unique identifier for multiple otherwise duplicate entries. Yes that was bad schema design to begin with, but it was a fun challenge to see if it could be resolved without scripting. [...]

|

Filed under: Uncategorized | by arjen
7 Comments »

Complete set (an alternative solution)

Scott Noyes wrote about a question frequently asked in for instance the freenode #mysql channel: given a table with students and answers, which students have answered all of a certain set of questions.
While his solutions are interesting, they do indulge a bit. And I’m not even referring to the fact that he uses obscure string [...]

|

Filed under: Uncategorized | by arjen
4 Comments »

Unwired (Sydney) looking for MySQL DBA

The good people at Unwired are looking for basically a MySQL DBA, although you’d also have the opportunity to do some coding, work on other projects and with additional technologies. You’ll need to have decent experience with MySQL 4 and 5, understanding of replication and backup/recovery methods, query and server performance tuning.
You don’t need to [...]

|

Filed under: Uncategorized | by arjen
1 Comment »

On GPLv3 press coverage, and a GPL-based business model

I was just reading this article on PC World about the launch of GPLv3. I reckon it’s a decent article in that it actually bothers to explain the foundation of GPL (Richard Stallman’s software freedom principles).
One quote (from an engineering professor at MIT) gets it wrong though:
When something in the free software world gets improved, [...]

|

Filed under: Uncategorized | by arjen
1 Comment »

How to get more free time (Arjen leaves MySQL AB)

So, how do you get more free time? Simple, you quit your job. I did. Yes, seriously.
Well, I was employee#25 at MySQL AB (from August 2001), that’s nearly 6 years – I reckon I’ve done my time
What’s next? That’s not really the point, I haven’t taken another job elsewhere.
For starters I’m taking a [...]

|

Filed under: Uncategorized | by arjen
12 Comments »