Here's a snapshot of my view out the office window...Yes, it's starting to look like springtime here in Chicago.

That also means it's that time of year where I start travelling for conferences. This year is shaping up to be light so far, but of course I will be at the MySQL Users' Conference next week in Santa Clara, CA.

Besides giving a tutorial, and two talks, I'm also looking forward to being part of the Java and MySQL community, hanging out at Gavin's talk about Hibernate and Seam, and participating in the …

Here‘s a snapshot of my view out the office window…Yes, it‘s starting to look like springtime here in Chicago.

That also means it‘s that time of year where I start travelling for conferences. This year is shaping up to be light so far, but of course I will be at the MySQL Users' Conference next week in Santa Clara, CA.

Besides giving a tutorial, and two talks, I'm also looking forward to being part of the Java and MySQL community, hanging out at Gavin's talk about Hibernate and Seam, and participating in the …

Just in case the HypnoToad did not convince you to attend my sessions at next weeks’s conference, I’ll up the ante.

Thanks to Apress and O’Reilly I’ll be giving away several MySQL related books at each session.

There, now you have to come. And of course watch this space for session notes.

This morning I read some reports on the reaction to Sun's recent discussion on open source DRM.  The reaction from the Stallmanites was not surprisingly negative.  From what I gather, no DRM is the only solution that would be acceptable however this has left me somewhat confused.  Perhaps someone could leave me a comment and help me understand how this is supposed to work.

Here's what I've got so far.  Stallman cites four basic freedoms.  The freedoms to run the program you wish, to change said program, to distribute said program, and to distribute said changes.  These freedoms fit neatly into a software world but are being applied to the digial media and DRM argument.

Apparently, according to Stallman, I should have the right, as the consumer, to share with all my friends the music and movies I am listening to or watching.  This sounds like a great deal.  No more heading down to the music …

ZDNet (via slashdot) is running an article about MySQL and Solid working together to bring solidDB storage engine to MySQL in June. There's an announcement linked from the Solid homepage and a letter from the CEO in PDF format. I don't see anything at MySQL.com, but the announcement from Solid seems to indicate that details will be unveilded next week at the MySQL Users …

Now that I am a happy user of PHP5 and MySQL5 and using that for writing a new application, which fortunately involves using the newest technologies, I am finally able to solve one of the biggest issues I always had had with DB-driven applications: foreign key contraints.

Constraints and transactions
I am using InnoDB (I know those contraints had been possible before MySQL5) for that and the first time I am also using the foreign key constraints InnoDB provides. And it does make me happier :-). I don’t have to take care of updating and deleting all the referenced table rows myself, the DB’s storage engine does that for me, as I always had wanted it.

I had started out using MyISAM tables and triggers, but when I realized that I am programming the application using transactions I had to switch to InnoDB …

Suppose I try to create a table with a primary key that’s varchar(500), and MySQL complains the key length is longer than the maximum of 1000 bytes. 500 is less than 1000. What’s happening? In this article I’ll explain why I, not MySQL, am wrong. Plus, I’ll show you a tasty (yet apparently harmless) bug in MySQL. Here’s a statement that will fail on my server: create table test(c varchar(250), d varchar(250), primary key(c,d)); ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes Why does it fail?

That's right, I'm a bit crazy, but not insane and also trying not to be stupid anymore! Have done that before, not again!

One year I have been with MySQL AB and it's great to have some normal working habits. Although, I'm learning quite a few things with me now specializing on MySQL Cluster, I have to be careful I'm not hooking myself into it to much. I rather keep my options open and look at other technology to work on too.

Meanwhile at home things are getting into place. I'm rather happy with how my life is now. I found out for myself it doesn't really matter to much where I live in this world: it's all good and the same shit. Dealing with the environment and making the most of it is what I do best I guess.

There are a few things I like to keep constant in my life.. These constants are slowly taking shape. But having hit the stone to often, I go easier on these things.

Till next status …

There is a tentative Obfuscated SQL contest with one entry by Kai Voigt.

SELECT CONCAT(CONV(536,8,20), LPAD(EXPORT_SET(1,'Y','N','',1), 3, "P"), CHAR(32), HEX(234), UNHEX(594939469*POW(3,2)))

Not bad, but ... SQL without data ? Doesn't sound right.
Here's my take (requires MySQL 4.1 or later):

drop table if exists complex;
drop table if exists simple;
CREATE TABLE complex ( simple char(2), complex char(1)) ;
CREATE TABLE simple ( complex char(2), simple char(1));

INSERT INTO complex VALUES ('0','7'),('1','6'),('2','6'),('3','6'),('4','2'),
('5','7'),('6','7'),('7','7'),('8','6'),('10','7'),('11','7'),('12','2'), …

Really Versioned Database Backup...
...Or abusing a version control system

I've always liked to keep my /etc configuration files in a source control system, since it both helps me document changes, as well as quickly roll back to an earlier date.

Then, I implemented some systems, such as web hosting and email configurations to reside inside a MySQL database, not to mention also some TikiWiki? sites.

Now, I wanted to have a versioned backup of the database... something that I could just dial to an arbitrary date, as well as see the changes.

How about mysqldump combined with p4 (Perforce) — Yes, I know subversion, cvs and bitkeeper might be polically more correct — but while I use all of them, I'm still fastest with p4, and it is available for free for up to 2 users and 5 clients.

So, here's a really simple script (use …