Posted by Erik on February 10, 2010
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 [...]
Posted by Erik on September 28, 2009
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 [...]
Posted by Erik on May 11, 2007
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, [...]