I'm more than a little bit OCD when it comes to managing my music collection. It's huge, and I like to keep the files named with a certain pattern so that when I look at the archive I can see, at a glance, what I have without having to open ...

Read More

This past week, I had to assign lat/long values to a large batch of addresses we had sitting around in our database.

To get those values, I posted to the Google Geocoding API and parsed the resulting XML.

This script isn't particularly polished - I didn't spend much time ...

Read More

Let me start with this proviso: Math is not my strong subject (okay, just stop right there with the Barbie jokes). I'll do just about anything to avoid writing complex equations. And most of the time, I don't have to. Most of the time, I can find alternative solutions, dependent ...

Read More

My mission was simple - to crawl all of our artist databases, extract names and email addresses from a couple of different tables, and spin out some custom XML.

The tables - one for complete user profiles and another for users who have signed up to receive emails only - ...

Read More

A few days too late ...

1. What's the coolest Python application, framework or library you have discovered in 2009?

PIL. Okay, maybe it wasn't exactly a new discovery, but I'd never used it before to the extent that I did in the last quarter of 2009, and ...

Read More