Tag Archives: amarok

Putting Music from Amarok 2 on the iPod Touch

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 and right-click drag them into the Dolphin/Nautilus window showing the directory ~/touch/private/var/mobile/Media/Music/ You may have to create the above directory. When you drop them, choose [...]

Importing MySQL 1.4 Amarok data into Amarok 2.2 Nightly

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 2.2 nightly version of Amarok.

Sweet SQL queries for Amarok

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, artist a, statistics s WHERE a.id=t.artist AND t.url=s.url GROUP BY a.name HAVING count > 10 ORDER BY avg DESC;