Month: December 2006

Installing MySQLdb on Mac OS X 10.4.8

I’m in the process of deleting duplicate copies of photos from my system in the interest of saving disk space (320MB just isn’t all that much when one is playing with video!). I’ve used find and md5 to build a list of all the .jpg files on my system with their hashes, and wrote some simple Python code to find duplicates. The problem now is to choose the best one of the duplicates (“best” in this case means the one with the most useful file and directory name). But my code just creates a pile of small files, one for each set of identical photos. This is a pain.

So I decided to install MySQL so that I could crawl through the duplicates in some interesting manner (yes, I did have wine with dinner tonight. Why do you ask?). The install of MySQL itself was trivial, but trying to install the Python binding (MySQLdb) was a pain. The important tip came from a posting on Jeremy Dunck’s blog — I was using gcc 3.3, and needed gcc 4. His posting explained what to do; I did it, and now I’m all set.

Now I have to actually put the data into the database and do something with it — that’s a problem for another evening, though….

Wine with Dinner

Every so often, I look at the wines featured on the endcaps at Lunardi’s. Most of them, of course, are Chardonnay, and therefore of no interest to us, but sometimes they have something which meets two important criteria:

  • It looks interesting
  • It’s being sold at a substantial discount to claimed retail

On Sunday, I found a couple of wines which met those criteria, though we’ve only drunk one so far — the 2002 Clos LaChance Central Coast Syrah. They wanted $8.99 for it, instead of a retail of $16.99 (or the winery’s suggested $18). It’s well worth the $8.99, so we bought a couple of more bottles, and might pick up more if they’re still in stock when we next visit.