MySQL 5.0.19 was announced on March 10th and the developers have been very busy with resolving many of the bugs that were reported. Something that did not really get much attention because of all these changes was the fact that we now provide binaries for Microsoft Windows Server 2003 x64 (AMD64/Intel EM64T) as well!
If you run the 64bit version of this OS, give these binaries a try and let us know how they fared for you! Kudos to the build team for making these happen.

Glanced at the program of annual conference "Corporate Databases 2006" and discovered that this year there is no MySQL session. Interesting, did Sergey Kuznetsov simply forget about us? Dmitri's feedback from the last year's conference (he was presenting) doesn't fill me with enthusiasm to try to submit a new talk. In short, attendance sucks. The idea is rather muddy too, as right now it's basically trying to gather competing vendors together and have them present their products one after another. No need to be a salesman to understand that it doesn't work.
There is no conference in Russia dedicated to database research that I'm aware of, otherwise I would attend one.

Time seems to be racing - in exactly one month I'll be on the way from Vienna via London to San Francisco and then to Santa Clara to attend the MySQL User Conference.

That's all extremely exciting for me. Actually, it's the first time in my life that I leave Europe. It will also be my first flight in 11 years (after leaving school, I travelled to Tenerife with my school mates - no big trip since then). It will be a great new experience.

I have rented a car in San Francisco for the whole duration of my stay together with a GPS system, so I will be able to drive around to see a bit of the location around San Francisco. I'll have a complete day for that until the Conference starts, and also a little time after the Conference. That's another exciting aspect of my trip.

But the most exciting thing will be to meet all the guys that I had contact to via …

During a life with computers, you sometimes see very strange things - such as this:

I have a little server at home that connects to the Internet via ISDN, and all other PCs in the network get their Internet connection through this server, which was running SuSE Linux 9.0. Everything worked absolutely fine.

Last weekend, I re-installed this server and updated to SuSE Linux 10.0. I set up the hardware settings in the same way as with SuSE 9.0 and generally, it worked again - but not always. Sometimes, I couldn't connect to the Internet anymore (while sometimes, it still works), but I found out a funny solution how to work around this problem.

I have also set up a fax server with capisuite. So if I call the fax (e. g. with my mobile phone), I can connect again right afterwards. I don't know why, but it works.

Of course, this solution wouldn't be very satisfying for the long term. But xDSL is …

Today I received an interesting request from one of the db4free.net users: is it possible to trigger emails on particular events? So for example, if a record that fulfills certain conditions is being inserted, somebody should automatically receive an email.

As far as I know, it's not possible in MySQL, but in other RDBMS. So wouldn't this be a nice feature for e.g. MySQL 5.2?

The only solution that comes to my mind is rather tricky and not 100 % accurate (since it doesn't send the email immediately after change in the database happened). Somebody could write a little application that verifies the condition and if it does, it sends the email - so this app could be defined as a cronjob to be run at a regular basis. Not very elegant, indeed.

Are there better solutions for this?

I just saw a draft of the UC presentation by Batara Kesuma about mixi.co.jp, a social networking site in Japan. It has experienced phenomenal growth since its inception, and Batara-San will tell the practical/technical story of how they scaled their Apache-Perl-MySQL based environment. Excellent stuff. Arigato!

Recently I've been working on a large-ish project where all of the UI is written in Javascript. That, in itself, is great. The environments (the browsers) are crappy crappy for development though. Sure, there are Firefox extensions etc etc to help, but it's Just Not Great. Javascript = Great. Ajax = Yay. Browsers = Bah.

Over the weekend I spent all sorts of time getting a simple Rails application running with Apache and mod_fcgid. When I gave up and tried making it work with lighttpd I got server error galore. Yay. What was wrong? My fastcgi? The fcgi Ruby extension? My ruby installation is in /pkg/packages/ruby-1.8.4 or some such and the gem tool couldn't find its own libraries after being installed there. Maybe something similar for something else? I have no idea, I got no error messages anywhere. Ruby = Great. Rails = Very nice[1]. Ruby Gems = It sure is no CPAN.pm. FastCGI/lighttpd/etc = Loosely coupled? No mister, you have some way to …

Recently I've been working on a large-ish project where all of the UI is written in Javascript. That, in itself, is great. The environments (the browsers) are crappy crappy for development though. Sure, there are Firefox extensions etc etc to help, but it's Just Not Great. Javascript = Great. Ajax = Yay. Browsers = Bah.

Over the weekend I spent all sorts of time getting a simple Rails application running with Apache and mod_fcgid. When I gave up and tried making it work with lighttpd I got server error galore. Yay. What was wrong? My fastcgi? The fcgi Ruby extension? My ruby installation is in /pkg/packages/ruby-1.8.4 or some such and the gem tool couldn't find its own libraries after being installed there. Maybe something similar for something else? I have no idea, I got no error messages anywhere. Ruby = Great. Rails = Very nice[1]. Ruby Gems = It sure is no CPAN.pm. FastCGI/lighttpd/etc = Loosely coupled? No mister, you have some way to …

Well, this entry is actually just to check if my new blog gets included in Planet MySQL, but I of course will provide you with something interesting :-)

How do you like this? I find it confusing and filed a bug report about it.

mysql> CREATE FUNCTION now () RETURNS CHAR(10) RETURN("Now");
mysql> SELECT NOW(), NOW (); +---------------------+--------+ | NOW() | NOW () | +---------------------+--------+ | 2006-03-22 11:45:27 | Now | +---------------------+--------+

So we have two functions with the same name, but the space after the name makes a difference.