In the spirit of humor, here are 2 ways I know I am a MySQL geek. These are actually things I do….

You Know You’re a MySQL Geek When….
1. You cannot type the word “myself” without typing “mysql” first, deleting 2 characters and finishing out the word.
2. You type “show processlist” at the commandline when you really mean “ps -ef”

Anyone have anything they can add to the list?

I've been following with interest Charles Lee's post over at the TSS about "Hibernate - A MySQL Enabler?". MySQL has always been well-supported by Hibernate, so it's good to see yet another project find that the two together can be a powerful pair (and keep vendor lock-in at bay).

The key issue that Hyperic ran into is that MySQL doesn't have sequences, but instead has identity-like columns. It seems that many folks with legacy data models run into the same issue.

Maybe it was serendipity that Steve Ebersole and the Hibernate team have delivered SequenceStyleGenerators in Hibernate 3.2.3 (and with even a bit earlier delivery, maybe Hyperic wouldn't have had to roll their own implementation).

I went and took a look at …

I've been following with interest Charles Lee's post over at the TSS about "Hibernate - A MySQL Enabler?". MySQL has always been well-supported by Hibernate, so it's good to see yet another project find that the two together can be a powerful pair (and keep vendor lock-in at bay).

The key issue that Hyperic ran into is that MySQL doesn't have sequences, but instead has identity-like columns. It seems that many folks with legacy data models run into the same issue.

Maybe it was serendipity that Steve Ebersole and the Hibernate team have delivered SequenceStyleGenerators in Hibernate 3.2.3 (and with even a bit earlier delivery, maybe Hyperic wouldn't have had to roll their own implementation).

I went and took a look at …

I've been following with interest Charles Lee's post over at the TSS about "Hibernate - A MySQL Enabler?". MySQL has always been well-supported by Hibernate, so it's good to see yet another project find that the two together can be a powerful pair (and keep vendor lock-in at bay).

The key issue that Hyperic ran into is that MySQL doesn't have sequences, but instead has identity-like columns. It seems that many folks with legacy data models run into the same issue.

Maybe it was serendipity that Steve Ebersole and the Hibernate team have delivered SequenceStyleGenerators in Hibernate 3.2.3 (and with even a bit earlier delivery, maybe Hyperic wouldn't have had to roll their own implementation).

I went and took a look at …

So a few things happened in the last few weeks or will be happening that I find worth sharing. First up Pagenello, the biggest Ultimate Frisbee tournament in Europe, was blast. Plenty of sun while playing 10 beach Frisbee matches in 4 days with some quality time chilling in Rimini before and after the tournament.

Yesterday I also held a slightly updated version of my "Explaining Explain" talk (now called "Finding Order in Execution") at the webtuesday usergroup meeting here in Zurich. As always you can find a pdf with the slides in the slides section of my blog.

Speaking of speaking I will be giving a talk on PHP6 at MySQL User …

Today while waiting at the airport, I took a look at the news stand, and right there on the cover of Fast Company were two words Google, and Wikipedia. Given Wikipedia is a poster boy of MySQL it was an immediate purchase just to see what was being said.

So the title of the cover was Google’s worse nightmare - Wikipedia’s Jimmy Wales has his sights set on the search business.

Now, often I use Wikipedia to search for things directly rather then using Google. I’ve found it usually to be more accurate, particular on topics I know it will contain. References to search users being disappointed, Google and Yahoo tied with a 2.3 of 5 in user satisfaction hits about home for me as week, and that’s exactly the ideas …

As I write this blog I have over 90 draft blog posts. That’s 9-0. Why do I have so many posts? The main reason is I want to say something, and I’ve either not completed it, or researched it sufficiently to consider the entry complete.

This frustrates me as sometimes I just want to get the word out on something, or of my opinion, or of something great I’ve discovered. I do it for me, I don’t really care if anybody actually reads my stuff, but I’m surprised sometimes when I get comments how people actually get to see my blog.

JotThat is a surprisingly simple yet brilliant idea. It’s quite simply a site for making Jots, making quick notes, making a passing comment, noting a thought, something you want to either remember or something you want to say in a simple Jot form.

What makes JotThat in my eyes? Well it’s simple, …

I leaned a new trick today with LOAD DATA INFILE. I’m migrating some data from an external source, and the Date Format is not the MySQL required YYYY-MM-DD, it was DD-MMM-YY. So how do you load this into a Date Field.


$ echo "02-FEB-07" > /tmp/t1.psv
$ mysql -umysql
USE test;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(d1 DATE);
# echo "02-FEB-07" > /tmp/t1.psv
LOAD DATA LOCAL INFILE '/tmp/t1.psv'
INTO TABLE t1 (@var1)
SET d1=STR_TO_DATE(@var1,'%d-%M-%y');
SELECT * FROM t1;
EXIT


The trick is to bind the appropriate column within the file being loaded to a variable, @var1 in my example and use the SET syntax to perform a function on the variable. Rather cool.

A good tip to know.

Those that know me, know that I‘m a little paranoid about backup automation around the house (because I‘m lazy, and that if it wasn‘t automated, it wouldn‘t get done).

I‘m also a little paranoid about offsite backups, so therefore I have a VPN between my house and my parents‘ house, and send my nightly backups (via rsync) to their place as well.

Normally, when I check my e-mail in the morning, I see a little report about what got backed up. I didn‘t notice that it was missing this morning, and instead it arrived at 3:00 in the afternoon.

That seemed a little odd, so I went and looked at my cricket instance, and low-and-behold, the outbound rsync had the 768Kbps side of my DSL connection pegged since 02:00 AM. A little “du”ing around on my backup server, and I found out that a backup had taken place in the middle of a torrent of FC6. That wouldn‘t have been a problem, except that BT stores …

Those that know me, know that I'm a little paranoid about backup automation around the house (because I'm lazy, and that if it wasn't automated, it wouldn't get done).

I'm also a little paranoid about offsite backups, so therefore I have a VPN between my house and my parents' house, and send my nightly backups (via rsync) to their place as well.

Normally, when I check my e-mail in the morning, I see a little report about what got backed up. I didn't notice that it was missing this morning, and instead it arrived at 3:00 in the afternoon.

That seemed a little odd, so I went and looked at my cricket instance, and low-and-behold, the outbound rsync had the 768Kbps side of my DSL connection pegged since 02:00 AM. A little "du"ing around on my backup server, and I found out that a backup had taken place in the middle of a torrent of FC6. That wouldn't have been a problem, except that BT stores incomplete files in your …