|Music A place to discuss the thing we are doing all this other stuff for|
Please consider donating to help us continue to serve you.
Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
||Thread Tools||Search this Thread|
|26th April 2020, 11:16 AM||#1|
looking for inspiration: Music Database
Oftentimes, I just can't solder around.
So I started to build a database (ninox) where I try to gather and connect as much information as possible as fine-grained as possible, like
Of course, this task barely has a boundary, and so I'm quite overwhelmed of its complexity. I would like to find solutions on both the technical (database-design) level as well as the logical level (where to best hook attributes like "authorship, contribution, role" etc.)...
Is there a place where such issues are discussed?
Could this be the place?
Thank you, enjoy sunday!
I listen to music more than not, and try to build knowledge about it.
trying to set up a sort of a catalogue of my music-library, which consists of a inherited collection of classical records (~1500 vinyls), and there's some records in the world of pop/jazz/etc. (~300 vinyls). Plus a huge collection of digital files (~500 ripped CD's, + ~300 Albums purchased through bleep + bandcamp)
|27th April 2020, 10:03 PM||#2|
Join Date: Apr 2020
Which database engine do you want to use
Access, SQLserver, sqlite, Oracle
How is you SQL knowledge
You will have to create two tables: one for the album and another for the track
The reason for this design is:
a song may be sing by several singer
The same song by the same singer may be on several albums (vinyl, MP3 or CD) on different supports
Here is my design (may be not the best)
Just add the missing fields (colums in SQL)
album Nb (Primiry key)
serialNb (serial number: an album may be from a serie)
kind of music
typeOfSupport (vinyl, CD, mp3, etc)
digitised (yes, no)
quality (exellent to poor, 10 to 1)
Track Table Track
(trackNb, albumNb) (Primary key)
kindOfMusic (jazz, rock, etc...)
nameOfFile (or address of the file on your server
CONSTRAINT PK_PRIMARY KEY (trackNb, albumNb)
FOREIGN KEY (Album) REFERENCES Album(albumNb)
Hope this help
|28th April 2020, 12:02 AM||#4|
Join Date: May 2010
I use Mediamonkey for all my needs. So far 250000 tracks / 4TB tagged.
Started 3 years ago, but sometimes I pause for a few days or even a whole month. Depends on the Mood.
I'm not so detailed. I just use ALBUM, ARTiST, ALBUMARTIST, TRACK, GENRE , DISC, YEAR & COVER fields. Sometimes Comment field also.
I Recommend tagging inconsistencies script to find things like Brian (Bryan) Adams.
Cindy (Cyndi) Lauper, Missing Fields, Artists & (AND) BAND, and so on.
I believe Hydrogenaudio forums address music databases, methods and rules.
|29th April 2020, 09:51 AM||#5|
I use a beginner-friendly tool called Ninox (webiste)
The Database's structure is shown like (see attachment). It's awkward and the fields can't be pushed around for better readability...
My SQL-knowledge is equal to 1 (I know it exists, but nothing more)
I'had already started to build it up, beginning with a track-table, a artist-table and a releases-table:
expressions between ( 'expression' ) are key-elements.
A 'track' has its 'composer'
On a 'release', the 'track' is interpreted by a 'formation' which consists of 'artists' playing 'instruments', 'recording date', 'duration', 'style', 'rating', contributions, soloists, etc.
A 'release' is being published by a 'label' which is owned by a 'publisher'. many of the above arguments apply to a release, too.
So far, so good.
I was able to connect
artist to formation
instrument to artist
track to composer
track to formation/interpretation
track to release
release to formation
release to label/publisher
I haven't been able yet to connect [artist playing a specific instrument] to interpretation or release, which would be interesting...
John Lennon plays guitar on track x
John Lennon plays piano on track y
I also would like to have a track's "genealogy" (what other pieces was it inspired from?)
more to come...
|Thread Tools||Search this Thread|
|Thread||Thread Starter||Forum||Replies||Last Post|
|Inspiration||strawberry||Multi-Way||7||27th May 2013 12:20 AM|
|Inspiration||gmphadte||The Lounge||0||23rd January 2013 10:53 AM|
|Japanese Inspiration||Leonidas||Full Range||11||25th February 2007 03:45 PM|
|some inspiration!||mrthieme||Multi-Way||3||27th December 2005 07:20 PM|
|New To Site?||Need Help?|