Garvin Hicking has released Serendipity 1.0 today.

Congratulations to Garvin and his contributors! Thank you for the best blogging software there is!

For those interested, there is now a Spanish translation of the MySQL Reference Manual online:

http://dev.mysql.com/doc/refman/5.0/es/index.html

In addition, the Connector/ODBC documentation has been re-worked, you can see it at:

http://dev.mysql.com/doc/refman/5.0/en/myodbc-connector.html

If you happen to use MySQL and live around Hamburg, Germany, here's your chance to meet with other MySQL users, developers and DBAs: I am happy to announce the second Hamburg MySQL Usergroup Meeting, which will take place on Monday, 3rd of July, 19:00. The location will be the same one as last time, the chinese restaurant Ni Hao in Hamburg-Wandsbek.  The food there is quite excellent and they will provide us with a separate room and video projector again. I'll try to arrange a presentation about MySQL and there will be plenty of time for chatting and discussing. If you'd like to join us, please RSVP via our event page on meetup.com and join the mailing list for further details! Looking forward to meeting you! Some pictures of our last meeting are available …

This might be handy

Jeroen Swart, one of the most capable and knowledgable Microsoft .NET Professionals I know, provided me with a pointer to www.connectionstrings.com. This site lists connection string formats for a whole bunch of databases. Of course, Oracle, MySQL and MS SQL are there, as are Postgres and DB2.

But what about Mimer? Lightbase? Right, that's why you might visit them.

Actually, there are also some products missing, like HSQL and SQLite and what have you. And they could pick a nicer Icon for MySQL. Otherwise, handy site.

I'm continuing my experiments with different OS and today I tested FreeBSD 6.0 on my box.
(more details about box and benchmark see here http://www.mysqlperformanceblog.com/2006/06/13/quick-look-at-ubuntu-606/).
Initially I was very pessimistic about FreeBSD, as results were (in transactions/sec, more is better.
for comparison the results from Suse 10.0):

As I mentioned here, I?m a member of the documentation team at MySQL, a job I started back in April. I?ve just completed a major tranche of documentation, and thought it would be interesting to let you guys know exactly what happens in a typical day for a member of the documentation team.

read more

There are some proposed changes in the Australian copyright law that are just too weird.

Australia has its newish free-trade agreement with the US, and so is now harmonising some of its laws. Unfortunately, things are being tightened without the corresponding "fair use" clauses that are part of the equivalent US legislation, and some flawed US stuff like the DMCA is also finding its way into the Australian proposals... laws have a fairly long cycle. The DMCA may get fixed at some point, but a new Australian law will take years again to pick up any such changes.

So, about the new copyright proposals:The proposed changes include allowing individuals to record a television program but only allowing a single viewing before it must be deleted.
The proposed laws also make it illegal to lend recorded programs to friends …

In recent articles I explained how I've optimized queries on some large tables at my current employer, and how I've written archiving and purging jobs to trim the tables down to a manageable size. This article explains how I re-indexed some of those tables without taking the server offline.

For those still interested, there is now an official job posting at the MySQL web site at http://www.mysql.com/company/jobs/tech-writer.html:

The MySQL documentation team is looking for another technical writer. For this we need the best and the most dedicated people around. You may work from anywhere in the world as long as you have the necessary skills and technical facilities to communicate across the Internet. Projects are coordinated from Germany, but our team members are expected to work independently.

You should be prepared to work intensively with our developers when writing new documentation (in English, so you should be a native English speaker), or changing existing documentation. Of course, you should have in-depth knowledge of MySQL, and we’d appreciate if you were MySQL certified. As a technical writer, you should have proven experience …

One of my first major tasks at MySQL has just been completed - a major rewrite of the Connector/ODBC (C/ODBC) documentation.

There were three major focuses for the rewrite:

1. Bring the documentation up to date. We had a mix of information on the latest release (currently 3.51, but 5.0 is currently in development), but many of the sections didn’t reflect that new version. There is also new information on how to install the driver on Mac OS X.
2. Restructure the information. This is something I’m doing across the board on the Connectors docs, as I try to re-organize them all into a more coherent, and compatible, structure. For example, I’ve collated all of the tips about using C/ODBC with different applications into their own section, organized by application. I’ve also extended the information; for example we now have a …