Lenny Domnitser’s

⇙ Jump to content


This is a static archive of the domnit.org blog,
which Lenny Domnitser wrote between 2006 and 2009.

Roll Your Own Last FM with Amarok and SQLite

A web page of top 20 songs by play count:

$ sqlite3 ~/.kde/share/apps/amarok/collection.db << END | tidy
.mode html
select statistics.playcounter, artist.name, tags.title
       from statistics, tags, artist
       where statistics.url = tags.url and
       statistics.deviceid = tags.deviceid and
       artist.id = tags.artist
       order by statistics.playcounter desc limit 20;

So the headline is misleading, but this is a start.