A few weeks after the latest useful quiz, I want to offer a funny one.
Given the following table, on a MySQL server 5.1.22 or newer,

CREATE TABLE t1 (id int, c char(100)) engine=MyISAM;

1. Create one set of three triggers that must all be activated BEFORE INSERT.
   
   • Upon insertion of the values (1, 'nothing'), the first trigger should replace 'nothing' with 'something', leaving the number unchanged;
   • the second trigger should add ' more ';
   • the third trigger should add '!!'.
2. Create one set of three more triggers, all activated BEFORE INSERT.
   
   • Upon insertion of the values (1,'nothing') the first trigger should add 10 to the number, leaving the text unchanged.
   • the second trigger should add 100 to the number;
   • the …

It's been almost a month now since I have been evaluating JasperServer. And it has been quite hard to evaluate the software without a proper documentation. Fortunately, I was able to convince my boss to buy the books Definite Guide to iReport, Definite Guide to JasperReport and JasperServer Ultimate Guide.

What I found interesting in all this experience is that just like any open software, it is connected to a lot of different applications. I had to study Tomcat and Ant in a thorough manner to get through JasperServer. In the end, I'm actually quite happy that I had to go through this experience.

Anyway, I am now quite comfortable with JasperServer. I am now able to create reports on the fly and I'm able to understand what it is now doing in a more in-depth manner. In fact, I will be giving a demo to our boss sometime soon and who knows we might use JasperServer in our company.

Helan går sjung hopp faderallan lallan lej. Helan går, sjung hoppfaderallan lej.

Och den som inte helan tar, han ej heller halvan får. Helan går, sjung hopp faderallan lej.

while we start to wind up development of connector/odbc 5.1, i will also be taking on responsibility for libmysql, the c library that defines the client interface to mysql, and the mysql command-line utilities. there are about 120 active bugs in those areas right now, so the first task will be getting that down to a more manageable number.

after that, the field will open up for new development. i know that an asynchronous interface to libmysql is on some people’s wishlist, and there are other areas where i think that libmysql could be cleaned up in general.

but the idea that i think is the most exciting is to build a scripting …

Infobright Inc., an innovative analytic data warehouse provider, and MySQL AB today announced a multi-year extension of their partnership agreement. Infobright is a MySQL Certified Storage Engine partner. The combination of Infobright's Brighthouse and MySQL provides organizations an analytic data warehouse that delivers high levels of scalability, performance and ease-of-use.

There's been a lot of positive coverage of Sun's acquisition of MySQL last week (with one or two odd-ball conspiracy stories). To me the most significant element is that Sun has long recognized the disruptive nature of open source and is now leveraging that power as part of their overall strategy. Obviously, that's not new news. Sun has been doing this for several years with OpenSolaris, GlassFish, NetBeans, open sourcing Java, etc. The fact that both companies have bet on open source is key to the ongoing success of MySQL. I don't think MySQL would have ever sold to a... READ MORE

Many may have already heard about it last week: http://blogs.sun.com/jonathan/entry/in_a_vortex

Looks like that's pretty much all that will be changing for me. I also expect that the deal will make it easier to integrate more Solaris patches for lighttpd and perhaps gives me access to recent Sun hardware for performance testing. Up to now I test lighttpd on Solaris in a OpenSolaris VMware session on WinXP :)

A reader commented that MySQL isn't "enterprise ready", to which another reader wrote: "I hate it when snobby DBAs or managers scoff at MySQL as if it isn't ready to play with the big boys. Google called, they'd like to loan you a clue." Valid point. But, I'm fairly certain that Google engineers could run a highly scalable computing system (whatever that is) using nothing more than OS/2, a paper clip, duct tape and maple syrup. I am not bashing MySQL in any way (I'm a happy user). I am however suggesting that the skills level inside an average IT... READ MORE

Ouch. It's been a really bad day, what with my incorrect reporting of MySQL + Oracle and now this. It's a meaningless competition but to lose to the Spurs even in a pickup game is embarrassing.

Yet lose Arsenal did, and badly. Nor can the team claim to have ...