Seems that a good number of people got food poisoning, or a bug on the last day of the conference. Which for me makes the third ever getting sick while traveling (an experience I would not recommend).

Since this hit so many people who attended the conference for and about linux, would this make it the first true linux virus?

(And I am fine, it passed, literally, within 24 hours).

I am reading that this might be the "Norovirus from Christchurch", whatever that means. Still a few hundred people in the same hotel from all around the world and what else do you expect?

Still, great conference :)

Norbert Bollow, the man who already made himself a name in the campaign against software patents by founding ThankPoland.info, now runs a new website http://truth50.com/ where he questions whether the ‘European of the Year’ award really [was] decided by the votes in the public poll, as it should have according to the predefined rules set by European Voice itself.

Heise.de runs a good summary in German of what it’s all about. My own thinking, also quoted in that Heise.de article, is that I have a hard time understanding how anybody — including the declared winner Jean-Claude Juncker — would have been …

Well this is low. I’ve just been spammed on my Wiki. And it was cunning, I just found it by accident. An enterprising hacker embedded into my Home Page hidden links that were not visible via normal page view, but ultimately would be via a search bot or some other means.

Even better the pricks even deleted content on one page. Here is an example diff of pages. I even posted a few days ago What makes your blood boil? and that was just an article on a news site with misleading dated information. I could see the opportunity for more blood boiling articles, but it doesn’t solve the problem. The problem is, I don’t know how to solve the problem.

So what can you do other then clean up this hacker …

I’m sure you are all aware by now of Mike Hillyer’s MySQL Sakila Sample Database that will be launched at the MySQL Conference. We now have an official MySQL Forum for this as well.

As part of leveraging this existing database, and using this for the basis of my MySQL Conference presentation on MySQL for Oracle Developers, I’ve released the first version of my MySQL Sakila Sample Application at http://sakila.arabx.com.au which I would very much like some feedback on. Please use the official …

Here is a MySQL version of a function to convert from gregorian to discordian dates.

DELIMITER $

DROP FUNCTION IF EXISTS `test`.`toDiscordian` $
CREATE FUNCTION `toDiscordian` (gdate DATE ) RETURNS varchar ( 50 )
DETERMINISTIC
COMMENT 'Discordian Date Converter'
BEGIN

SET @year = EXTRACT ( YEAR FROM gdate);
SET @dyear = @year + 1166 ;
SET @month = EXTRACT ( MONTH FROM gdate);
SET @mday = DAYOFMONTH (gdate);
SET @yday = DAYOFYEAR (gdate);
SET @dseason = round ( @yday / 73 );

CASE @dseason
WHEN 0 THEN SET @a_holiday = 'Mungday' ;
WHEN 1 THEN SET @a_holiday = 'Mojoday' ;
WHEN 2 THEN SET @a_holiday = 'Syaday' ;
WHEN 3 THEN SET @a_holiday = 'Zaraday' ;
WHEN 4 THEN SET @a_holiday = 'Maladay' ;
ELSE SET @a_holiday = 'Error in a_holiday' ;
END CASE ;

CASE @dseason
…

Just released at the MySQL Forums yesterday an updated source version of MySQL Workbench for Linux available at ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-1.0.1.tar.gz.

So can Version 1.0.1 compile when I had no success with compiling 1.0.0?


$ su -
$ cd /src
$ wget ftp://ftp.mysql.com/pub/mysql/download/mysql-workbench-1.0.1.tar.gz
$ tar xvfz mysql-workbench-1.0.1.tar.gz
$ cd mysql-workbench-1.0.1
$ cd mysql-gui-common
$ ./configure --enable-grt --enable-canvas
$ make
MySQLGRT/MGRTValueTree.cc:255: instantiated from here
/usr/include/sigc++-2.0/sigc++/adaptors/bound_argument.h:158: error: 'const …

Giuseppe Maxia recently told me about a book that he could recommand - it's called "Producing Open Source Software - How to run a successful free software project" by Karl Fogel (ISBN 0-596-00759-0).

I ordered it at Amazon.de (and was astonished that they could ship an English book within 24 hours - mostly I have to order English books from the US Amazon, where books are also shipped very quickly but it can easily take a month until the book is finally delivered) and started reading. I have only finished the first chapter so I can't tell much about the details. But it still looks interesting: it tells about the philosophy of Open Source Software and why most Open Source projects fail (assumedly 90 - 95 %). The first chapter forecasts that it will show the pitfalls and what should be done to minimize the risks that an Open Source project will fail.

It sure …

I found an interesting post on a newsgroup which made me think about a nice solution for this problem:

You have a date/interval pair stored in a table, let's say, the 29th January and an interval of 14 days and you want to check if a date is followed by that given interval. So this should be true for 29th January (I assume that the given date should be included), 13th February, 27th February, 13th March etc.

I wanted to find a solution which can not only deal with one pair, but with many pairs. You should be able to specify a date and verify which pairs are true for the specified date (if you're a bit confused by my explaination - my example will make it easier to understand what I mean).

I have set up an example table with several date/interval pairs:

mysql> SELECT id, dt, intvl
    -> FROM date_repetitions;
+----+------------+-------+
| id | dt         | intvl | …

Right now two other guys added their voice to mine in this feature request to MySQL AB for a public changelog of MySQL QueryBrowser.
Please add your comments too, if interested in it.

Eager to experiment ... I installed MySQL 5.1.5 on my laptop, in place of an existing MySQL 5.0.x installation from which I borrowed the my.ini file, the outcome has been bug 16781 at MySQL AB, the new one doesn't seem to like this row in the ini file:

# The default storage engine that will be used when create new tables


default-storage-engine=InnoDB