Category Archives: MySQL

Registered for OpenSQL Camp 2009

I’ll be in Portland on November 13, 14 and 15 for OpenSQL Camp, an unconference covering open source databases. In addition to learning more about MySQL and Drizzle internals, I’m looking forward to learning a bit about Postgres and some of the NoSQL database alternatives. They aren’t just your father’s high performance key-value stores, anymore.

Logging SQL for Prepared Statement with C3P0

The C3P0 database connection pooling library has worked very well for me, but I recently ran into a problem when I wanted to log the SQL that was being generated for a PreparedStatement if an insert failed. Then, if database problems caused inserts to fail beyond an automated retry period, I could easily harvest the… Read More »

EBay & Google MySQL Patches and Drizzle

This year I attended presentations by the EBay engineering team at the MySQL Conference and JavaOne in which they talked about some very interesting patches that had made to MySQL Server. I lamented the fact that they hadn’t open sourced it yet or contributed all the patches back to MySQL. Google has also announced some… Read More »

Updating Substring in Column in MySQL

Today I needed to make the same kind of update to a field in a few rows of a large database table. There were too many rows to do it with a separate SQL update statement per row, so I hunted down the MySQL REPLACE function. Okay, it was only 6 rows, but I needed… Read More »

Adding Newlines with sed

Not realizing there was a surfeit of newline characters in a largish mysqldump file I was analyzing, I tried to open it in TextMate. After a few minutes of listening to the hard drive in my Mac thrash away, I had to kill TextMate. One obvious solution was to split it into multiple lines, but… Read More »

2008 MySQL Conference

I’ll be at the 2008 MySQL Conference the next three days. If any of the three or so of you that read these posts will be there, let me know and I would love to meet up down in Santa Clara. Even better, I’d love to carpool with someone from Oakland to Santa Clara. Besides… Read More »

MySQL Support from Python on OS X

It was more work than it should have been, but you can get access to a MySQL database from Python on OS X 10.5 by following the instructions at this blog post. If you’re using Pydev in Eclipse, be sure /Library/Python/2.5/site-packages is in the System PYTHONPATH. Bring up the Preferences dialog, open Pydev in the… Read More »