In case I ever forget this again, I’m posting these instructions here.  It’s actually really easy. Install OpenSSH from Cydia Mount the iPod’s filesystem: mkdir -p ~/touch && sshfs -o allow_other root@192.168.1.7:/ ~/touch/ Then, in Amarok 2, go to the collection browser, and find all the songs that match your criteria (I use ratings): Highlight them [...]

I was having a bunch of trouble today importing my old MySQL amarok database into the new nightly version of amarok I installed.  The Amarok Wiki had a great section on how to convert a MySQL Amarok collection into an SQLlite one.  This was the key to importing my old 1.4 collection into the new [...]

I was messing around writing some sweet SQL statements for amarok tonight. You can either run them using the MySQL console or using dcop (google ‘amarok dcop’). Here’s some examples: # List artists and their average rating and number of ratings ordered by favorite artists first SELECT a.name, avg(s.rating) avg, COUNT(s.rating) count FROM tags t, [...]