Smarter Playlists with SQL
Posted on Sun, 19 Oct 2014

I recently discovered that my music player (Clementine) stores its metadata in a SQLite database.

The first thing I did once I knew this was to do a bunch of queries which summarised the data in interesting ways. My favourite so far is a count of albums released on each year, as represented in this graph:

… [more]
While My Guitar...
Posted on Fri, 26 Jul 2013

Ok, so I was going to come up with a pun on the title of a certain Beatles song for the title of this post, something like "While My Guitar Generally Shrieks", but I couldn't think of anything funny, so I gave in.

Anyway, I thought I'd write a word or two about my interest in music:

… [more]

Older posts >>