I'm going to need to do this at some point.

"Here is a memory-friendly function that should be able to split a big file in individual queries without needing to open the whole file at once:" Yep, that'll do.

"Here’s a complication of some common and useful time & date calculations and equations. Some, though very simple, are often misunderstood, leading to inefficient or incorrect implementations. There are many ways to solve such problems. I’ll present my favorites." These are, indeed, useful, and I've been using a few of them recently.

A good list of tips - lots of compiled stuff needs to be recompiled to x64, and this will be confusing. I am not upgrading quite yet.

"My other half says I’m losing it. But I think that as an enthusiast kernel developer she doesn’t have the right to criticize people." Generating ASCII pie charts with a single SQL query. It's a very, very big query. It's a bit crazy.

Ryan North makes a little poem dedicated to the COALESCE function in MySQL. He's right: it's super useful.

The reason CakePHP has issues connecting to MySQL database on OSX 10.5 is because its database adaptor is explicitly looking for the default mysql socket defined in your php.ini. If you fix that, everything works. The critical adjective, if you ever search for this again, is the "OSX" part.

"Sequel Pro is the perfect tool for working with database-driven websites and applications." Leopard-only MySQL management application; forked out of the long-neglected CocoaMySQL.

"Are you tired of browser-based games that are thinly veiled interfaces for databases? Finally, there's a game that just is a database!" This looks awesome.

"The problem exists only with binary distributions of MySQL and is related to the installation location of the libraries for the MySQL client that DBD::mysql uses." Ran into this problem today; wasted an hour on it. Never again.

"The problem is that you need the MySQL development headers in order to get the ruby gem to compile…sooo, you need to install this first."

A useful plugin for Wordpress - prior to 2.2, data was stored as latin1. Now it's UTF-8. If you've got a lot to convert, this seemed to do the trick.

As with so many other SQL challenges, if you re-phrase the question, it’s easy to select the maximum or minimum row per group without subqueries. The key is to understand what you want, and to be able to word the problem in a way that translates from En

Ooh, crunch - nitty, gritty, technical (and often above-my-head) blog devoted to MySQL performance. But lots of good data in here nontheless. Mmn.

Nice write-up of Cal's tutorial

The bug Darryl Miles points out is the important thing to note, and a real show-stopper. Handy to be able to do this, though

Some useful reminders in here, even if most of it's been covered before

"Freetag is an easy tagging and folksonomy-enabled plugin for use with MySQL-PHP applications"