Archive for the ‘Databases’ Category

MySQL vs. PostgreSQL

We were at the Sun+Zend party last night, and it was a blast (thank you Jesse Silver!). If you’re a PostgreSQL or MySQL user/developer or just a general database geek, you should’ve been there. Why?


(watch the video if its stripped in your feed reader)

Monty Widenius (MySQL) and Josh Berkus (PostgreSQL), decided to start sumo wrestling! It ended with a 5-0 score, advantage MySQL.

An attendee Tim Moore twittered: “Postgres is totally losing the sumo match. I’m migrating all of my databases to MySQL tomorrow.”

Monty says, this is what we do to people that leave Sun! In fact, if you didn’t already know, Josh Berkus, my esteemed colleague in the Database Group at Sun Microsystems, is leaving his post as the PostgreSQL Team Lead. We met for the first time, face to face at foss.in last year, and all I can say is I’m truly saddened to see him leave. But thanks to the magic of the open source world, we’ll still be interacting, I’m sure. Good luck Josh! (and better sumo practising next time, mmmkay?)

Silona speaks about grids, databases, and open government

Silona Bonewald, the lady always in a hat (she says that it’s just become an extension of her). Describe her, by her tags: open government, open data, open standards, and databases.


(watch the video if your feed reader strips it out)

Silona’s the founder of The League of Technical Voters, which allows technical people to be more involved in voting process. As part of this, she created the Transparent Federal Budget, with Bill Bradley and Jimmy Wales.

On top of all that, she’s also the open source evangelist for grid.org. The focus there is a social network for grid, cluster, and cloud computing folk – a community of communities. Best of all, this was just launched on Tuesday!

It’s also the home to UniCluster, and they’ve recently struck a deal which Intel to pop UniCluster in BIOSes. UniCluster works with Sun’s Grid Engine, as well.

She’s interested in Drizzle, for the same reason that she likes Drupal. She likes the decorator model, and she thinks its a great way to get the parallel computing solutions fixed.

Needless to say, all of the stuff she works on currently, is powered by MySQL.

Brian, Monty and Tim O’Reilly at OSCON 2008 Keynote

Interested in MySQL? Drizzle? How the Sun acquisition is going for MySQL? Listen to Brian, Monty, and Tim speak about this, at the OSCON panel. Watch the video, its 20+ minutes, it starts off a bit shaky (oops), but I’m mostly happy with the rest. Enjoy.

Memcached and MySQL: webminar from a Web 2.0 company

At OSCON, Brian and Dormando gave their ever famous talk, Memcached and MySQL: Everything You Need To Know. I didn’t attend the tutorial, but they assured me it was similar to what was given at the MySQL Conference 2008 (everything, but the very nice buttons dormando was giving out with the memcached logo!). Great, because not only is memcached hot, but I have notes from their talk: Memcached and MySQL tutorial.

Interestingly enough (and this didn’t happen at OSCON), was at the MySQL Conference, Patrick Galbraith jumped on stage to speak about his experience with memcached at Grazr. Why not now, spend an hour listening to Patrick talk about Grazr, memcached, and MySQL?

There’s a webminar, titled: Grazr: Lessons Learned using MySQL and Memcached in Web 2.0 Applications. Its on Thursday, August 14, 2008, and you don’t even need to dress up to listen to Pat talk – the beauty of a webminar :)

P/S: If you don’t already know, subscribing to MySQL Enterprise entitles you to 24/7 production support for memcached. Neat, right?

“Me too” comments in bug systems

I don’t know about “me too” types of bug replies, but before everyone goes to the bug database and starts saying “me too”, “this affects me”, “please fix this ASAP”, “I won’t use MySQL 5.1 till this is fixed”, I wonder if this will cause more harm (i.e. more bug spam for the developer, and all those subscribed to it) than good.

Worklog :: WL#148 >> Foreign keys: Implement Foreign Keys (all storage engines)It seems like the public Worklog interface gets this right – via voting. Having a count of those that have the same problems, even displayed via “stars”, is a much better interface, and shows urgency a lot better than “me too” posts.

Take one of my favourite worklogs – WL#148 (to implement engine independent foreign keys). Not only can you tag it, you can also comment on it (like a bug report), you can subscribe to it (watch it) and in the event you felt like a “me too”, you just login, and vote!

Lots of bug tracking systems have voting. I remember this being implemented on the OpenOffice.org system (IssueZilla) a few years back, and its definitely proven to be useful. Maybe this is a feature request, for our bugs system?

MySQL Camp in Bangalore

In Bangalore, India? Definitely go there, to the MS Ramaiah Institute of Technology, on the 29 of July 2008, from 4-7pm (no, not Indian Standard Time ;)), and listen to Kaj Arno speak about MySQL.

Sun Microsystems - IN - MySQL Camp
We’re on the front page of Sun Microsystems .in

In addition to Kaj, Thava Alagu will speak about contributing code to MySQL, and Sonali Minocha (from OSSCube) will speak on optimising enterprise applications.

There is also hope that this will be a regular meetup, aka the Bangalore MySQL User Group. Amit Saha has an entry on MySQL Camp (which isn’t exactly the hands-on MySQL Camp you’re used to – its just a name), and a schedule available.


i