Lenny Domnitser’s
domnit.org

⇙ Jump to content

explicit

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;
END

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