Xaprb

Here’s a quick productivity tip: when optimizing queries by rewriting them to different forms that should return the same results, you can verify that you get the same results by taking a checksum of them.

Just set your pager to md5sum:

mysql> pager md5sum -
PAGER set to 'md5sum -'
mysql> select * from test;
a09bc56ac9aa0cbcc659c3d566c2c7e4  -
4096 rows in set (0.00 sec)

I’ve made plans to attend part of Saturday and part of Sunday at PostgreSQL Conference East 2009. I wish I could be there the whole time. Anyway I’m just thrilled that I’ll get to see people again, and meet new people I didn’t get to meet before.

I think Josh Berkus has talked me into doing some kind of lightning talk on what the PostgreSQL community is doing right from my POV, and what parts of that I try to emulate in “other” areas of my professional life (if you know what I mean), though I can’t see how that can actually fit into a lightning talk. But that’s the point of a LT. Hmm. So it turns out Josh was inviting me to to an LT at a different PG conference. Thanks xzilla for explaining to me.

I have a hotel room at the Sheraton right next to Drexel for Saturday night, and am hoping to split that with someone, or cancel it and share someone else’s room.

An item that may be of interest: I’ve been seeing a lot of twittering and various blogs, emails, comments on IRC, etc, to the effect of this comment I saw on #postgresql today:

there are days where I’m very saddened that I’m that far away from the US of A
for example when I see something like this: http://conferences.percona.com/percona-performance-conference-2009/schedule.html

So I’d like to extend again a warm welcome to the PostgreSQL community to this event. You can read more about it here.

What’s going on at your favorite open-source database developer mailing list? Non-scientific memory of what I’ve been seeing lately:

• The Drizzle list is talking about test coverage and completeness, and schedulers.
• The MySQL internals list has recently been dominated with talk about coding standards.
• The PostgreSQL hackers list is talking about a ton of stuff. I don’t even try to keep up.
• The Percona launchpad list is talking about bugs, xtrabackup, and more bugs and patches for them. There’s also a Percona Google Group that is not very active. In fact there are several Percona lists; it looks a little confused.