Skip to content

Instantly share code, notes, and snippets.

@pete
Created April 5, 2011 04:07
Show Gist options
  • Save pete/903003 to your computer and use it in GitHub Desktop.
Save pete/903003 to your computer and use it in GitHub Desktop.
Here I have started sqlite3 and pointed it at the xmms2 database.
Note the columns "id", "key", and "value": it is a bad, one-level
key/value store done in sqlite3. The sound file used as an example
is apparently shipped with xmms2.
sqlite> select * from Media where id = 1;
id,key,value,source,intval
1,added,1301974718,1,1301974718
1,album,Dreamweb,4,
1,artist,mind.in.a.box,4,
1,bitrate,224000,4,224000
1,chain,gvfs:magic:vorbis:segment,1,
1,channels,2,4,2
1,comment,http://www.mindinabox.com/,4,
1,duration,26000,4,26000
1,laststarted,1301974779,1,1301974779
1,lmod,1266601434,2,1266601434
1,mime,application/ogg,3,
1,sample_format,S16,4,
1,samplerate,44100,4,44100
1,size,686051,2,686051
1,status,1,1,1
1,timesplayed,3,1,3
1,title,"Lament for Lost Dreams (snippet)",4,
1,url,file:///usr/share/xmms2/mind.in.a.box-lament_snipplet.ogg,1,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment