Music Library manager ??? Any one

Hi folks
I have loads of old CD's being ripped to flac but I still want each folder to be related to the original CD.

Problem is specially with classical music -- you might have several identical titles --e.g Beethoven Symph 3 -- where one might have it being placed by the London Symphony, another by Chicago Symphony etc -- and even with the same orchestra there might be different conductors, soloists etc. Many "compilations" are often generically labelled as "Various Artists".

Ripping and tagging tracks isn't a problem but how to organise these properly -- doesn't seem to be an type of catalog program --I'm sure I'm not the only one with this problem. I don't bother with things like Spotify. I've plenty of storage space so I prefer my own music in non lossy format - flac usually.

tagged cd output is essentially



The nearest I've got to it is to have the "cover art" per "CD" in the file -- where it doesn't exist(in about 2% of cases) I create one by scanning the cd - and link the files via a MariaDB database so I have basically in the Maria DB key --CD title, then cover image, then artist / "various" but it's a bit of a manual process. As a secondary key genre is also possible e.g classical, rock, etc.

Anybody else have any suggestions or some decent cataloging software for this purpose.
Note --I don't want to create any playlists or store the actual music content into any proprietary system. Links to the actual music is what I'm interested in.

I've roughly 3500 CD's accumulated over the years !!

Cheers
jimbo

jimbo45 said:

I still want each folder to be related to the original CD.

Click to expand...

I've only had a few of identical titles, so I just manually created separate folders. Big job though if you've got many but, that's the way of it, as far as I know!
However...

jimbo45 said:

Anybody else have any suggestions or some decent cataloging software for this purpose.

Click to expand...

... WMP Legacy still sorts them automatically...

Also:
You can probably customize the Titles in Advanced Naming Properties...

Edwin said:

Also:
You can probably customize the Titles in Advanced Naming Properties...

View attachment 56592

Click to expand...

Hi there
@Edwin

It's too much hassle that way.

However in dBpoweramp I do like the facility before doing the rip you can look at what several Music meta data providers show so you can choose the best one if you don't stick with the default / first found.

Messing around in a VM so I can test MariaDB connection I have on the host.

here's the "manual meta data" selector from dBpoweramp


seems MusicBrainz has greatly improved for classical music CD over the last couple of years --sonata DB is also good while freedb is probably better for rock etc and tagging individual music selections than CD rips.

I don't like the WMP method -- that can really hose up things !!!!

I think I'll just stick to the MariaDB and insert the album art (max size is around 220kb) as a blob. Wit MariaDB you can do loads of queries to get what you want - and easy to return in excel Query. !!!

E.g -- from a test DB







Seems simple -- you just need the ODBC driver for the remote DB server

From Windows it's easy even with a GUI to build the SQL DB -- use HediSQL to create tables etc etc.





That should give you some fun things to play with !!!!

If I get the thing working I'll post an image

Cheers
jimbo