iTunes and SQL
Mood: satisfied
Posted on 2005-05-08 15:11:00
Words: 167

So I'm a geek. My current project is to take my iTunes database (with all of my rated songs and whatnot) and use it to figure out which artists and such I like best. So I wrote a python script to read in the iTunes Music Library.xml that iTunes uses to store its data and put it in an SQL database. Then I did some neat SQL stuff (and learned a bit along the way) to find out which artists had the highest average rating, which genres had the highest rating, etc. The top few bands are Barenaked Ladies, Frou Frou, The Beatles, Linkin Park, Matchbox 20, Michael Jackson, Coldplay, Journey, etc.

So I have these scripts, so if anyone is interested I'd be happy to do the same analysis on their .xml file - just send it to me and I'll send you a text file with lots of interesting stuff. :-)

Anyway, it's been a fairly busy week, and I'll post a real update maybe tomorrow sometime...

2 comments

Comment from djedi:
2005-05-09T15:56:08+00:00
Michael Jackson? Just teasing.

I need one of these magical scripts that can tell me what sort of music I like. On second thought to quote a great mouse "I don't care what it does so long as it folds and fits under a bed."

Comment from gregstoll:
2005-05-09T16:39:30+00:00
As under a bed our music is. :-)

(and yes, I like Michael Jackson!)

This backup was done by LJBackup.