Music Library Statistics file (Local.adb)

[alan]

hey,
I couldn't find clear/definite answer anywhere.

Q: Is there a way to view/edit content of Local.adb?

Wondering why it's not a standard sqlite db to make it easier.

I am interested how things are stored there - I have few cases to handle and wanted to do things on my own.

[Artem]

Is there a way to view/edit content of Local.adb?

No. What data you want to change?

Wondering why it's not a standard sqlite db to make it easier.

Because SQLite is so slow.

[alan]

No. What data you want to change?

I planned to rebuild my whole audio library.

Let's say I have all music stored as 128kb/s, I want to do the following:

for each mp3 from audio library find replacement flac/ogg (better quality, higher bitrate) and swap these, then store them in folders organized in let's say {genre}/{author}/{album}

Once it's swapped create a mapping for later DB update so I can keep my current stats.

[Artem]

Once it's swapped create a mapping for later DB update so I can keep my current stats.

AIMP can do it in automatic way (of course, if metadata will be similar)

[alan]

Cool, I can play with it to see what it can do. Maybe you could give me some hints on what data I should pay the most attention: (title, author, different).
If I knew how keys are created for them or how logic serach for track if it was for example relocated that would be super helpful, this way I can do less reverse engineering

[Artem]

I should pay the most attention

Duration, File Name (without an extension), Title, Artist, Year and Album.

[alan]

Thanks @Artem