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 [...]

|

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 [...]

|

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 [...]

|

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 [...]

|

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 [...]

|

Filed under: Uncategorized | by arjen
12 Comments »