Posts Tagged ‘sqlite’

ffms2m3u.sh - create playlist for all files on a Firefly Media Server

Tuesday, September 2nd, 2008

ffms2m3u - create playlist for all files on a Firefly Media Server.

If you run Firefly Media Server, you can run this script to create an M3U of all the tracks on your server. You can play this in most audio players; VLC likes it, as does iTunes (though big playlists take an age to load). Rhythmbox and the default Ubuntu Movie Player won’t touch my playlist of over 17,000 tracks.

To configure the script you need to edit three lines:


# where the Firefly database lives
DATABASE="/usr/var/cache/mt-daapd/songs3.db"
# server domain name or IP address
SERVER="server.example.com"
# Port to talk to server - don't leave blank
PORT="3689"

If you’re running Ubuntu, you’ll probably only need to change the SERVER line. It spits the M3U playlist, ordered by album, to stdout. Note that in the default Ubuntu install, regular users can’t read the database file.

If you’re running this from a cron job, it’s probably a good idea to fill in the real paths for sqlite3 and awk.

SQLite Manager

Sunday, April 20th, 2008

SQLite Manager for Firefox

I like SQLite Manager for Firefox.

Rise Up Singing! in freedb

Sunday, February 10th, 2008

It took me a while, but I finally put all the track information for Sing Out!’s Rise Up Singing teaching CDs (also on the artists’ website) on freedb. I was given the data just over a year ago by Mark D. Moss, the editor of Sing Out! magazine.
The discs are:

Perhaps what took longest was working out a UTF-8 safe processing workflow, from converting the original Excel table to e-mailing the entries to the freedb server. Let’s just say that OpenOffice, sqlite, and Perl were very helpful here.

overfed

Wednesday, June 13th, 2007

We had a power cut last night, and my Gregarius aggregator on the basement server really didn’t appreciate it. I think it was doing something to the sqlite database that holds the feeds when the power went out, so I lost all my configs and had to trudge through hundreds of old items.

It could be worse; you could be stabbed! (as Mark Taylor always used to say).