Extract artist/titles from Music Library

Get help for Volumio here!

Ads helps Volumio remain Free and Open Source. Please consider donating to help us continue to serve you.

Extract artist/titles from Music Library

Postby Stomper85 » Thu Aug 29 2019 19:52

I have a serious question about how to extract a list of all my music stored in the library of my volumio.

The background is, that I unfortunately deleted all my music by accident from my NAS.
Tried to recover etc. but no way... so this is gone.

But as I had a lot of music, where I don´t know the Artist and the Album Titel etc. because I just recorded it from online radio or found by cover art etc. I wil never be able to re collect all of that cool music.

So my idea was, that volumio still has all titles in the database and shows every Album and Title I have aver stored on my NAS.

I would love to extract these titles from the database or the data file. I am a C and C# developer, so it seems to be no problem, if I knew where the data is stored.

Can anyone help me?

Best regards
Random avatar
Stomper85
Fresh off the boat
Fresh off the boat
 
Posts: 3
Joined: Thu Aug 29 2019 19:45

Ads helps Volumio remain Free and Open Source. Please consider donating to help us continue to serve you.


Extract artist/titles from Music Library

Postby Stomper85 » Fri Aug 30 2019 20:05

So, what I found about the storage of the database is, that it is using Google LevelDB Database.

But I am the old fashioned relational SQL Database guy and would need some help how to read the values from LevelDB... should be easy if one knows how to do it... but I don't want to damage anything...

Is there anybody who can help with reading all keys/values from leveldb ?
Random avatar
Stomper85
Fresh off the boat
Fresh off the boat
 
Posts: 3
Joined: Thu Aug 29 2019 19:45


Extract artist/titles from Music Library

Postby Stomper85 » Tue Sep 10 2019 23:01

What about the developement team?
There should be someone who can help me.
Random avatar
Stomper85
Fresh off the boat
Fresh off the boat
 
Posts: 3
Joined: Thu Aug 29 2019 19:45


Extract artist/titles from Music Library

Postby PaulM » Wed Sep 11 2019 08:05

I would start by making a backup of the database first. From there, you can make a second copy to try with on your normal workstation, or use the copy on the Pi to extract the data.

Edit: I dug into it a bit again. The documentation indeed says that Volumio uses LevelDB, not sure for what though. The music library is MPD's library. The file can be found at '/var/lib/mpd/tag_cache'.
According to MPD documentation it should be a flat text file, but for some reason I cannot decipher mine. But this should be your way to go I guess.

Other idea: why not use the Volumio UI to list all your music?
Random avatar
PaulM
Audiophile
Audiophile
 
Posts: 144
Joined: Sat Mar 07 2015 12:37


Return to Help

Who is online

Users browsing this forum: Bing [Bot] and 9 guests