Considering Creating a PC-Based Music Database

pustelniakr

Silver Miner at Large
Staff member
I need to keep my software skills exercized. I am thinking about creating a PC-based music database for my own collection, that might also be useful for my friends.

This system should be useable on any PC system (Macs not so much), and be self-contained, and install easily.

Here are the features I am considering:
  • Music by artist (last name first)
  • Music by genre, then artist (last name first)
  • Music by number (I have many cassettes that are stored by cassette number), side A or B
For a particular source, I want to include the following:
  • Artist or group name (ordered by first or last name)
  • Work or album name
  • List of cuts (by side and/or number, time, location on what machine (index number))
  • Up to 8 images (Cover art, etc.)
  • Unique Identifiers (pressing, lead out grove info, etc.)
Mix tapes/discs (good also for creating/considering cuts to include on new):
  • Cut name
  • Cut time
  • Cut order in the mix
  • Album
  • Artist
  • Format
Search by:
  • Artist first name
  • Artist last name
  • Number
  • Cut name
  • Album Name
Print by:
  • Genre
  • Number
  • Artist First Name
  • Artist Last Name
  • Album Name
What other info or features might be nice to have?

Enjoy,
Rich P
 
Last edited:

kirk57

Junior Member
What I’ve found a bit lacking is a logical way to organize classical stuff. Fields would be composer, orchestra or other, who conducted, type of composition, and bonus points for label. Something like they way filters work in excel would allow me to search/play all Reiner/CSO recordings, for example. Or just sonatas written by Mozart. Or Telarc recordings.

Probably out of scope, but it would be great if all this could be ported to a smartphone so I’d know what I already have when I’m shopping for music.
 
Last edited:

Olson_jr

Active Member
Interesting exercise. One feature I really enjoy, and use, in Roon's DB, is the ability to see what other albums the sidemen play on. I can't tell you how many times I have thought I am hearing someone new only to find that they are all over the place in my collection.

As an example, the other day a friend asked me about the George Freeman/ Chico Freeman recording All In The Family. I was giving it a listen and was thinking, "That Guitarist sounds familiar but I am not placing him." Check the DB and see that he was all over the place in Soul Jazz Collections.

The ability to cross-reference every artist might be a bit ambitious from a data entry standpoint.

Screen Shot 2019-02-19 at 6.04.13 AM.pngScreen Shot 2019-02-19 at 6.05.00 AM.pngScreen Shot 2019-02-19 at 6.05.51 AM.pngScreen Shot 2019-02-19 at 6.06.38 AM.png
 

Thermionics

Post Whore In Training
Record label, label catalog ID, deadwax info.

Also miscellaneous open field(s) for additional information (such as "RSD2012" or "limited swirl vinyl" or "HDCD")
 

airdronian

Junior Member
Record label, label catalog ID, deadwax info.

Also miscellaneous open field(s) for additional information (such as "RSD2012" or "limited swirl vinyl" or "HDCD")
+1 for record label. Being able to filter by label or artist and label would be nice. Such as "Music Mattters" or "Coltrane + Impulse".
 
Top