The latest from the MySQL community

This post wants to be:1. A quick glance at the new "common table expression" (aka hierarchical queries) in Firebird 2.12. A call to action for other opensource databasesSo, on with 1., Firebird recently added another great feature, common table expressions (CTE) which, to my eye at least, boils down to hierarchical queries.This is basically the ability to efficiently and easily query hierarchical

Yes, old news, but woohoo, big news. The Happy New Year is kicking off nicely. All the best for 2008!

Yes, old news, but woohoo, big news. The Happy New Year is kicking off nicely. All the best for 2008!

Yes, old news, but woohoo, big news. The Happy New Year is kicking off nicely. All the best for 2008!

After I posted my idea about a pure PHP mysqlnd driver, I received an email from Ulf Wendel from the MySQL AB team who works on the mysqlnd driver. He told me I could post his comments since he doesn't have a Blogger account. I'll include his comments below in blockquotes and then I'll comment below that.Ulf Wendel writes:What is "native"?PHP and the Borg[1] seem to be relatives. Whenever a

MySQLers share many hobbies. One of them is running. After the holiday season, I allowed myself to do some statistics on last year’s running, and add some personal reflections, only marginally related to work and MySQL.

Running is often a social event at MySQL, where a sizable portion of my 108 runs last year were with other MySQLers: Six times with Zack Urlocker (EVP Products), six times with Patrik Backman (Dir SW Eng), twice each with Larry Stefonic (SVP APAC) and Clint Smith (Legal Counsel), and once each with Kristofer Pettersson (SW Eng), Saskia Schweitzer (Training coordinator), Mikael Ronstr?m (Principal Engineer/Senior MySQL Architect), and Nicolas Pujol (Sr Director, Alliances & Channels). Running can even be social time spent with non-runners (not just on the phone), as three of my runs were with MySQLers on …

This release contains bug fixes and new features. Click through to the full article for the details. I'll also write more about the changes in a separate article.

My posts lately have been mostly progress reports and release notices. That's because we're in the home stretch on the book, and I don't have much spare time. However, a lot has also been changing with Maatkit, and I wanted to take some time to write about it properly.

A

Maatkit contains essential command-line utilities for MySQL, such as a table checksum tool and query profiler. It provides missing features such as checking replicas for data consistency, with emphasis on quality and scriptability. This release contains bug fixes and new features. Changelog for mk-archiver: 2008-01-05: version 1.0.6 * Made suffixes for time options optional (bug #1858696). Changelog for mk-deadlock-logger: 2008-01-05: version 1.0.8 * Made suffixes for time options optional (bug #1858696).