Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Music Cataloguing systems - Any ideas folks

02 Apr 2009   #1
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 
Music Cataloguing systems - Any ideas folks

Hi guys
Just wondering (To those of you who have a larger collection of music than a simple Ipod) what do you use for cataloguing / retrieving tracks / albums or do you "Roll your Own" app

My big problem with "Proprietary" Catalguing systems - is that apart from the way a lot of them insist you have music encoded in some special format there usually is no easy way to retrieve a slew of tracks easily and quickly.

Say I want to run a query like "find first 50 tracks with the words Honey Love in the title issued between 1965 and 1970 and exclude artists Roy Orbison and Lionel Ritchie" No current system I've found will do this (BTW not that I've got any thing against those two individuals -- just an example.

Or I want all tracks performed by "The London Symphony Orchestra" or all tracks conducted by "Bernard Haitink" etc.

And the mega show stopper of all is most library systems I've seen DON'T SPAN DISC VOLUMES.

I've dedicated 3 entire disk volumes for music. I store mainly in FLAC but sometimes in ATRAC (Sony Minidisc format) and OGG.

What I'm thinking of doing is creating a MySQL database with the "track meta information" and a link to the disc directory its on . By the meta information I can store the "Query tags" such as the fields I want to interrogate.

The main problem of doing this of course is to ensure the MySQL database is always up to date. However since I've "ripped" almost my entire CD collection I won't be updating this too much in future.

I never purchase Music from Itunes etc -- why pay for "compressed Music".

I upload stuff occasionally from Real time recording at Gigs (the old Minidisc is SUPERB - Still no competitor out there yet for this) and can handle this manually - not a huge amount.

Anybody know possibly of a decent facility that would allow me to do this easily rather than the MySQL method.

The absolute essentials are : (All 3 required)

1) SPANNING DISKS (i.e multiple disks allowed for the DB)
2) Music can be stored in format(s) of my choice -- not restricted to a single codec.
3) Meta data must be simple to add such as Artist, title, etc etc.

Cheers

jimbo
My System SpecsSystem Spec
02 Apr 2009   #2
Barman58

Windows 10 Pro x64 x2 Windows 10 Enterprise x64, Ubuntu
 
 

Hi Jimbo,

I think mediamonkey will do most, if not all of what you need, at least in the Gold version.

you may want to give it a look anyway, if just for ideas for your own system ...

MediaMonkey » Free Media Jukebox, Music Manager, CD Ripper & Converter
My System SpecsSystem Spec
02 Apr 2009   #3
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Hi there

Looks good -- thanks.

I've used this as a Media playing system a while ago and liked it then but I never thought of it as a "cataloguing system" -- there's some great info in this.

I'll compare this with what I'm already doing -- If i get the MySQL stuff working I can post the queries so others can create the tables / copy the application.

MySQL is Free and the great thing is it works on Linux / Windows / Macs etc etc. The server can be ANYWHERE indpendent of where the music is actually installed.


If I get the MySQL database working I can possibly also use this also to stream music around the house -- but that's not a high priority.

Cheers
jimbo
My System SpecsSystem Spec
.

02 Apr 2009   #4
swarfega

Windows 7 Professional 64-bit
 
 

I just organise my music on the hd by artist then album, its easy to navigate.
My System SpecsSystem Spec
02 Apr 2009   #5
LapTopDog

Win7, Ubuntu 8.04, Mandriva Powerpack 09
 
 

Jaikoz might work for you and offers lots of different ways tagging on lots of codecs.
It collects missing metadata from the MusicBrainz server.
Atrac might be a problem. So might excluding Roy Orbison and Lionel Ritchie. LOL
About €15 after a months trial.
My System SpecsSystem Spec
02 Apr 2009   #6
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Quote   Quote: Originally Posted by swarfega View Post
I just organise my music on the hd by artist then album, its easy to navigate.
Hi there I think you mis-read my OP.

The MAIN THING I WANT (CAPS intended) is for the library to SPAN MULTIPLE VOLUMES. The volumes might be on a Network or ANYWHERE. I want to be able to access the music from ANY computer on the network (or even remotely).

You say you just organise on the HD -- I might have a LOT of HD's to do this stuff -- also organising by Artist isn't that easy either -- just say you are organising a Classical Music collection

Who is the Artist -- The Symphony orchestra, The composer, The soloists (if any), the Conductor.

What also if the artist is represented in many albums or compilations.

It's NOT so easy to manage this stuff.

Unlike simple collections this stuff has a lot of MANY to MANY relationships.

Hi Laptopdog -- the Musicbrainz server isn't that good for metadata for Classical Music metatags.

The best allround server is the Gracenote CDDB (for CD metatags). Freedb is also good.

Once I've ripped most of the CD's I can always manually add new metatags.

Cheers
jimbo
My System SpecsSystem Spec
02 Apr 2009   #7
baarod

El Capitan / Windows 10
 
 

Quote   Quote: Originally Posted by jimbo45 View Post
Hi guys
Just wondering (To those of you who have a larger collection of music than a simple Ipod) what do you use for cataloguing / retrieving tracks / albums or do you "Roll your Own" app

My big problem with "Proprietary" Catalguing systems - is that apart from the way a lot of them insist you have music encoded in some special format there usually is no easy way to retrieve a slew of tracks easily and quickly.

Say I want to run a query like "find first 50 tracks with the words Honey Love in the title issued between 1965 and 1970 and exclude artists Roy Orbison and Lionel Ritchie" No current system I've found will do this (BTW not that I've got any thing against those two individuals -- just an example.

Or I want all tracks performed by "The London Symphony Orchestra" or all tracks conducted by "Bernard Haitink" etc.

And the mega show stopper of all is most library systems I've seen DON'T SPAN DISC VOLUMES.

I've dedicated 3 entire disk volumes for music. I store mainly in FLAC but sometimes in ATRAC (Sony Minidisc format) and OGG.

What I'm thinking of doing is creating a MySQL database with the "track meta information" and a link to the disc directory its on . By the meta information I can store the "Query tags" such as the fields I want to interrogate.

The main problem of doing this of course is to ensure the MySQL database is always up to date. However since I've "ripped" almost my entire CD collection I won't be updating this too much in future.

I never purchase Music from Itunes etc -- why pay for "compressed Music".

I upload stuff occasionally from Real time recording at Gigs (the old Minidisc is SUPERB - Still no competitor out there yet for this) and can handle this manually - not a huge amount.

Anybody know possibly of a decent facility that would allow me to do this easily rather than the MySQL method.

The absolute essentials are : (All 3 required)

1) SPANNING DISKS (i.e multiple disks allowed for the DB)
2) Music can be stored in format(s) of my choice -- not restricted to a single codec.
3) Meta data must be simple to add such as Artist, title, etc etc.

Cheers

jimbo
I'll just throw this out there but I don't expect you to consider it a prime choice as most folks with "specific" requirements like this shy away from using what's built into Windows. I've never quite understood that frankly but here goes.

1) Spanning disks -- Windows 7 has this neat little feature called LIBRARIES which are designed for just that. Windows Media Player uses them natively. You can even add disks/folders from your homegroup or domain.
2) Music in multiple formats -- well you actually mean music AND TAGS in multiple formats. Still not a problem. There are plugins that will allow you to play FLAC and ATRAC (although I have no idea why you'd want that as even the developer of this niche proprietary format has ditched it for AAC -- New Sony Walkmans ditch ATRAC for AAC) and this nifty little plugin that gives tag support for those formats and more M4a, Flac, Ogg, Ape, Tag Support Plugin for Windows Media Player & Windows Media Center
3) Easy to add -- well that's subjective. For simple edits I use WMP and for mass changes I use mp3tag Mp3tag - the universal Tag Editor (ID3v1, ID3v2, APEv2)

As for advanced query functionality try autoplaylists:

Music Cataloguing systems - Any ideas folks-capture.jpg


My System SpecsSystem Spec
02 Apr 2009   #8
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

Hi there
Thanks for all the suggestions.

ATRAC I only use for some Legacy stuff -- the latest (?) minidisc recorder RH1 uses WAV and MP3 as well.

I'm not a big fan of Windows Media player as it does all sorts of "Phoning Home" to "Daddy" in Redmond to check on what you are playing, whether you have the rights for it and whether you've messed around with any DRM.

WMP doesn't EXPLICITLY say this of course -- it just says Data is sent to Microsoft for "purely informational" purposes with a view to "enhancing the customers Windows experience".

Anyway thanks everybody there's enougfh stuff here to go on with.

Cheers
jimbo
My System SpecsSystem Spec
02 Apr 2009   #9
baarod

El Capitan / Windows 10
 
 

Quote   Quote: Originally Posted by jimbo45 View Post
Hi there
Thanks for all the suggestions.

ATRAC I only use for some Legacy stuff -- the latest (?) minidisc recorder RH1 uses WAV and MP3 as well.

I'm not a big fan of Windows Media player as it does all sorts of "Phoning Home" to "Daddy" in Redmond to check on what you are playing, whether you have the rights for it and whether you've messed around with any DRM.

WMP doesn't EXPLICITLY say this of course -- it just says Data is sent to Microsoft for "purely informational" purposes with a view to "enhancing the customers Windows experience".

Anyway thanks everybody there's enougfh stuff here to go on with.

Cheers
jimbo
Turn all that off in options and if you're still worried about it, set a firewall rule to explicitly prevent such activity as well...
My System SpecsSystem Spec
19 Jun 2009   #10
t41

windows7 7600 x86
 
 

best cataloger i have found - orangecd - OrangeCD – Automatic database software to catalog CD and MP3 collections

you can control this program to seek what you want.



use in conjunction with winamp and i use jaikoz to tag my files with.

good luck
My System SpecsSystem Spec
Reply

Thread Tools


Similar help and support threads
Thread Forum
Hi folks!
Hello everyone, I'm also on 8F, 10F, and PCHF. :) Figured I might as well join this forum as well! :geek: -Chuck
Chillout Room
BSOD when playing music or watching video any ideas would help
I am running a Alienware Aurora Window 7 64 bit i7 with 6g ram I have tried whocrashed with no luck or finger pointing. Problem signature: Problem Event Name: BlueScreen OS Version: 6.1.7600.2.0.0.256.1 Locale ID: 1033 Additional information about the problem: BCCode: 7f
BSOD Help and Support
Music Programs/Cool Playing Programs Ideas?
Hey guys.. My first Post ! :) Im wondering about a good problem to play music files and video files.. I want a cool looking music playing program like wamp or something.. or a cool skin for a program.. my theme on my computer is red/grey.. Strong computer with cs5 master collection and i need a...
Music, Pictures & Video
Are Unix systems more secure than Windows systems?
Lately, I've heard some people say that the Unix code is more secure than the Windows code and that the Windows code has many holes and bugs in it. Before, I always thought Unix systems (for example, Mac) were less likely to get infected by viruses only because they had a lower market share....
System Security


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 11:20.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App