Go Back   Home > Forums > >
Home Forums Rules Articles diyAudio Store Blogs Gallery Wiki Register Donations FAQ Calendar Search Today's Posts Mark Forums Read

Music A place to discuss the thing we are doing all this other stuff for

looking for inspiration: Music Database
looking for inspiration: Music Database
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
Reply
 
Thread Tools Search this Thread
Old 26th April 2020, 11:16 AM   #1
myleftear is offline myleftear  Switzerland
diyAudio Member
 
myleftear's Avatar
 
Join Date: Sep 2017
Location: Luzern
looking for inspiration: Music Database
Default looking for inspiration: Music Database

Hi friends

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
  • who wrote (what piece)
  • who played (what instrument)
  • who contributed (on which track)
  • who recorded it
  • who published it
  • what do I or other family member like
You get the picture. Kind of a clone of discogs, merged with my iTunes-library or something like that, so that I can dig out specific informations from the collection...

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!
david

(context:
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)
)
__________________
dobedobedo...
  Reply With Quote
Old 27th April 2020, 10:03 PM   #2
jjcMtl is offline jjcMtl
diyAudio Member
 
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 Table
album Nb (Primiry key)
serialNb (serial number: an album may be from a serie)
albumAtist
editor
kind of music
country
yearOfPublication
typeOfSupport (vinyl, CD, mp3, etc)
monoStereo
digitised (yes, no)
quality (exellent to poor, 10 to 1)
comments

Track Table Track
(trackNb, albumNb) (Primary key)
trackTitle
artist
country
kindOfMusic (jazz, rock, etc...)
duration (m.s)
nameOfFile (or address of the file on your server

SQL:
CONSTRAINT PK_PRIMARY KEY (trackNb, albumNb)
FOREIGN KEY (Album) REFERENCES Album(albumNb)

Hope this help

jjcMtl
  Reply With Quote
Old 27th April 2020, 10:58 PM   #3
rayma is offline rayma  United States
diyAudio Member
 
Join Date: Apr 2011
Check allmusic, they do a very good job.
  Reply With Quote
Old 28th April 2020, 12:02 AM   #4
MAAC0 is offline MAAC0  Portugal
diyAudio Member
 
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.
  Reply With Quote
Old 29th April 2020, 09:51 AM   #5
myleftear is offline myleftear  Switzerland
diyAudio Member
 
myleftear's Avatar
 
Join Date: Sep 2017
Location: Luzern
looking for inspiration: Music Database
Hey jjMtl

Thank you!
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...
(like
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...


Quote:
Originally Posted by jjcMtl View Post
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
Attached Images
File Type: png Bildschirmfoto 2020-04-29 um 11.50.01.png (102.3 KB, 16 views)
__________________
dobedobedo...
  Reply With Quote

Reply


looking for inspiration: Music DatabaseHide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
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?

All times are GMT. The time now is 03:30 PM.


Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 15.00%
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Copyright ©1999-2020 diyAudio
Wiki