I’ve wanted for a while to extract a radio station url for HBR1, Ambient from Banshee 2.0.1.
My first thought was to grep recursively and disregarding character case for ‘hbr’ in $HOME. That didn’t work.
After some time I realized that probably Banshee stored most of the data in a sqlite db. I was right about that, but finding the radio station url still wasn’t as simple.
Here’s what I did to get it printed out on my console:
~/.config/banshee-1 % sqlite3 banshee.db ‘select * from CoreTracks’ | grep -i hbr
3|2586|12|463|0|0||http://ubuntu.hbr1.com:19800/ambient.ogg||0|0|0|0|5|0|HBR1, Ambient|hbr1 ambient||, �
3|2587|12|464|0|0||http://ubuntu.hbr1.com:19800/tronic.ogg||0|0|0|0|5|1|HBR1, House|hbr1 house||, �
3|2588|12|465|0|0||http://ubuntu.hbr1.com:19800/trance.ogg||0|0|0|0|5|0|HBR1.com – I.D.M. Tranceponder|hbr1com – idm tranceponder||, �
Yeah, not pretty, but who cares as long as you can extract your data, right? Of course, if you’re going to re-use the output in your scripts you’ll have to figure out how to make the output prettier. If you do that, drop me a line in the comments section, please.