I haven’t updated my blog in a while, so as a temporary placeholder, I’ve decided to just post a random conversation where I attempt to rewrite Sarah songs into either programming languages or pseudo code. Dorky, at best.

(23:27:29) esofluffy: so if you were to be listening to Sarah McLachlan, which song would you choose?
(23:27:39) arcology88: umm
(23:27:43) arcology88: the silence
(23:27:44) arcology88: haha
(23:27:49) esofluffy: I think I’ll go for “Hold On”
(23:28:09) esofluffy: well, instead i went for “Building a Mystery”
(23:28:19) esofluffy: I want to rewrite the song to be different.
(23:28:31) arcology88: hehe
(23:28:32) arcology88: explain
(23:29:00) esofluffy: well, first of all I’d rename it… to “Parsing a SQL_TREE”
(23:29:28) esofluffy: “cuz you’re working… on Parsing a SQL_TREE”
(23:30:26) arcology88: ahhah
…

I've posted the 0.3 release of the myhttp, Web Services Engine for MySQL. DELETE and UPDATE are now supported, and range queries now function properly. The handling of primary keys has been completely rewritten.

You can find a copy of it here:
http://download.tangent.org/myhttp_engine-0.3.tar.gz

The announcement here:
http://tangent.org/index.pl?node_id=528

I have also released mod_methods, which implements PUT, GET, HEAD, and DELETE for Apache 2.X. This allows the creation of a simple Webdav like environment to manipulate Apache 2.X webservers.

You can find a copy of it here:
http://download.tangent.org/mod_methods-0.2.tar.gz
…

The idea how to speed up nested-loops join a little I've mentioned earlier has now been promoted into a worklog entry. It is now known as WL#3724 "Short-Cutting Join Execution: Speeding up star queries" and its text is publicly available at MySQLForge.

At the moment there is only a short description, but hopefully Martin Hansson (the assigned developer) will add more content there.

After two months of hard work we are proud to announce a new release of XAMPP for Windows and Linux. New in both releases of XAMPP are MySQL (5.0.37), PHP (4.4.6), phpMyAdmin (2.10.0.2), and OpenSSL (0.9.8e). The Windows version also contains up-to-date versions of: FileZilla FTP Server (0.9.23), ADOdb (4.94), and Zend Optimizer (3.2.4).

With XAMPP 1.6.1 we tried to make the Windows version ready for Vista. The beta tests were very successful and most people reported a very smooth XAMPP under Vista but there were also people still having problems. Please get in touch with me if you also encounter problems on Vista. Currently please avoid installing XAMPP into the "Program files" folder.

Get the downloads and more details on the platform specific XAMPP project page.

It works!

mysql>
 SELECT s3id from pierce;
 +------------------------+
 | s3id                   |
 +------------------------+
 | ABASEMENT              |
 ...
 | ZIGZAG                 |
 | ZOOLOGY                |
 +------------------------+
 992 rows in set (25 min 51.73 sec)
 mysql> _

Ok, so it needs to be made a bit faster, but I have some ideas for that...

One of the keynote panels from the Web 2.0 Expo featured three entrepreneurs of companies that are heavy users of MySQL: Joe Kraus (JotSpot), Mena Trott (SixApart) and Jay Adelson (Digg).  It was one of the more interesting discussions dealing with companies at different stages of considering their independence.

• CNet: Video - To Flip or Not to Flip (excerpt)
• Red Herring: Buzz & Money
• AppScout: Web 2.0 Expo Live Blog - Panel with Batelle, Adelson, Trott, Kraus
…

This time of year has the MySQL Conference where everyone interested in MySQL, or who are partners, can go to the USA and learn new techniques and features coming out in the up and coming MySQL versions.

Being a MySQL consulting and training partner, this is one of our most important conference and networking times of the year and as such our office will be closed over these 2 weeks.

Cybersite is still contactable through either email or via instant messenger and can help with remote work if time permits. Otherwise, we will be back in Australia at the beginning of May ready to present the knowledge learned at the conference.

Tomorrow morning (11.5hrs time actually) I’ll be on a plane to SFO (then down to Santa Clara) in preparation for the MySQL Conference.

So, if you’re in the area - give us a buzz. My aussie phone will work, as will traditional email.

Also on IRC… should be easy to find me (freenode).

Jay has written an excellent summary of sessions at the MySQL Conference & Expo that will be particularly interesting for developers using MySQL to power their applications or web sites. I noticed that he did not explicitely mentioned the Perl scripting language, even though there actually are a few sessions that will be of interest for the Perl Mongers amongst us (I would not dare to claim I am one myself, I just hack on it in my spare time):

• There will be a tutorial about "Real-world MySQL Performance Tuning", held …

Xing is Europe's leading Business Network with more than 2 million members. Recently, Xing announced that they would come up with an API later this year to get access to the network. As far as I know, Xing was developed by ePublica using Perl and MySQL.

Having an API is essential in these mashup days. I was invited to the private alpha test and implemented a reference implementation of an API client via PHP5 which behaves like SOAPClient (but uses ReST as the transport mechanism) and overloads the methods that are available.

Here's an example of how to call it currently (API is …