Es ist vollbracht. Nach der üblichen zweiwöchigen Beta-Phase können wir heute die neue "finale" XAMPP-Versionen zum öffentlichen Download anbieten.

Aktualisiert wurden in diesem XAMPP: Apache (2.2.9), MySQL (5.0.51b), PHP (5.2.6), phpMyAdmin (2.11.7), mod_perl (2.0.4), OpenSSL (0.9.8h) und der eAccelerator (0.9.5.3).

Die Downloads und genauere Details zu den neuen Versionen gibt es auf der jeweiligen XAMPP-Projektseite.

I filed these two MySQL bugs today:

Bug#37910 Dropping unrelated index fails if fk on first col
Bug#37925 Select with comma join pretends a column does not exist

They originate with clients, and occur on recent 5.0 versions. No fatal stuff, but annoying. Both are of the fairly awkward variety and I'm curious why they still exist so late in the 5.0 series.

For instance, the second one looks like a parser bug, and I'd have figured someone tripping over this ages ago. It's actually a regression as it worked fine in 4.x, the testcase is directly from an app that was in production on a 4.x server, then upgraded to 5.0. Kaboom on this. Quite unexpected, and very annoying as going through the entire app changing the join syntax is a bit of a pest for the developers.

…

I am a member of the monday morning murder association. I murdered bugs. As said earlier, the modification of PDO_MYSQL to support both the MySQL native driver for PHP (mysqlnd) and the MySQL Client Library (AKA libmysql) is progressing. A good number of known and unknown bugs has been killed. But some new have been found as well - an overview.

(...)
Read the rest of PDO_MYSQLND: Monday morning murders (754 words)

I am a member of the monday morning murder association. I murdered bugs. As said earlier, the modification of PDO_MYSQL to support both the MySQL native driver for PHP (mysqlnd) and the MySQL Client Library (AKA libmysql) is progressing. A good number of known and unknown bugs has been killed. But some new have been found as well - an overview.

(...)
Read the rest of PDO_MYSQLND: Monday morning murders (754 words)

I teach the exact differences and use of the different join types and keywords in my courses (specifically the Optimisation by Design day). A few tidbits:

• Left and right joins are outer joins.
• A,B is an inner join (equivalent to a cross join if you don't have a join condition).

But the point of this post... when looking at apps, I often see LEFT JOINs abused. That is, the query does not actually require a left join. The result might be ok, but that entirely depends on the data contained in the tables; no guarantee.

Apart from understanding joins, I've found that there's a very simple but effective test for whether or not to use a left join.... "if you can't think of a specific reason, you don't" ;-)

I am a member of the monday morning murder association. I murdered bugs. As said earlier, the modification of PDO_MYSQL to support both the MySQL native driver for PHP (mysqlnd) and the MySQL Client Library (AKA libmysql) is progressing. A good number of known and unknown bugs has been killed. But some new have been found as well - an overview.

Please note that the status information is based on Linux 32bit and Linux 64bit testing only. We still have not done cross-platform testing recently. I spend too much time with blogging Also, I have not included some PDO_MYSQL feature requests such as the support of cursor attributes. Technically it should be possible to implement but we will focus on making "release ready" what we have today before we consider adding new features.

The following list is not ordered. Bugs have not been assigned a priority and/or severity. Its a “status quo” description that needs to be read with care. …

I'm back from my week of vacation and am ready to pick up where I left off with the interviews I conducted at the Red Hat Summit/FUDCon last month.  After today's, I will have three left: Dennis Gilmore, Max Spevack and Chander Kant of Zmanda.

The Honourable James Zemlin

On the first day of the Summit I was able to grab my buddy Jim Zemlin, the Executive Director of the Linux Foundation for a spirited discussion about the Foundation, Linux and a bunch more. 

My interview with Jim (15:55)  Listen ( …

I'm back from my week of vacation and am ready to pick up where I left off with the interviews I conducted at the Red Hat Summit/FUDCon last month.  After today's, I will have three left: Dennis Gilmore, Max Spevack and Chander Kant of Zmanda.

The Honourable James Zemlin

On the first day of the Summit I was able to grab my buddy Jim Zemlin, the Executive Director of the Linux Foundation for a spirited discussion about the Foundation, Linux and a bunch more. 

My interview with Jim (15:55)  Listen ( …

In almost all application development situations, one needs to log debug information now and then. In almost all production systems, one needs to log serious error events somewhere too.

So, what can you do? Create a log table? Sprinkle your code with SELECT 'Debug: ...' statements?

At the UDF Repository for MySQL, we now have a solution to log messages to the MySQL error log: a user-defined function called log_error().

Currently it is all very crude: the log_error function takes one argument and writes it to the mysql_error log, appending a line …

It's finished. After the usual two-week beta period, we can announce the new "final" XAMPP version available for public download.

In this version we updated: Apache (2.2.9), MySQL (5.0.51b), PHP (5.2.6), phpMyAdmin (2.11.7), mod_perl (2.0.4), OpenSSL (0.9.8h), and eAccelerator (0.9.5.3).

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