Export .ogg's from cache.db

[DYLANzzz]

I opened up the cache.db in sqliteman and it loaded everything fine.
I searched the blobs for "oggs" (which I assumed is something that begins all .ogg music files) and I found all the entries.
When I go to export everything to csv, I expected it to export all the binary data but all I get is:

Code: [Select]

"OggS"
"OggS"
"OggS"
"OggS"
"OggS"
"OggS"
"OggS"
"OggS"
...
Is there any way to get these out? I want to find some more music to listen to.

[Ad Bot]

[Aware]

Is there any specific reason why you want to take them out of the cache.db instead of download them?

[Kalphiter²]

I opened up the cache.db in sqliteman and it loaded everything fine.
I searched the blobs for "oggs" (which I assumed is something that begins all .ogg music files) and I found all the entries.
When I go to export everything to csv, I expected it to export all the binary data but all I get is:

Is there any way to get these out? I want to find some more music to listen to.

You'll probably have to use some sort of programming language to read the database and save every OGG (marked by starting bytes "OggS") to a file. The problem is that you're trying to export a binary file to a regular human-readable export format.

[DYLANzzz]

Is there any specific reason why you want to take them out of the cache.db instead of download them?

What? I don't want to go scouring the forums for tons of .oggs. I just wanted to extract them all from the .db to see which ones I liked so I can record the names. I have something like 1250 oggs.

You'll probably have to use some sort of programming language to read the database and save every OGG (marked by starting bytes "OggS") to a file. The problem is that you're trying to export a binary file to a regular human-readable export format.

I figured exporting to csv and opening with NP++ would show me all the binary data which I could write a simple perl script to seperate into all the files. I guess Ill just read straight from the .db then.

[Zeblote]

I just wanted to extract them all from the .db to see which ones I liked so I can record the names.

Protip: cache.db doesn't contain file names.