An idea to help organize your music with extra metadata using a SQL Server Database. This repository searches through a folder and gathers metadata already in mp3 files to add to a database
2
stars
1
forks
source link
Additional Metadata For Artist and Album Tables; Use all Useful Data TagLib Can Gather #8
Turns out that the TagLib library already has the filename present on the metadata it gathers from an MP3 file. Using that instead of making a custom object that adds redundant data.
Added new data to Main table that TagLib was able to find (Note that only some MP3s have some or all of this data, depending on how much data the publisher of the music wanted to add to the file):
Lyrics
Comment - occasionally has purchase information
Beats Per Minute
Copyright
Publisher
ISRC - Like an ISBN, but for music
Bit Rate
Sample Rate
Sample Channels
Bits Per Sample
Owner - Now just the username of the machine that is running this database generator script
Added new data to the Artist table
Primary Person ID - the primary composer of the music or the "lead" of the musical group (if that data is listed in the MP3 file)
Added new data to the Album table
Track Count - the total number of tracks in the album
ReleaseYear - the latest date that any one of the album tracks was released. Note that this metadata does not exist on the MP3 file itself and is calculated. Because of this, this value will likely be inaccurate for "Best of" albums and other compilation albums.
Added new ArtistPersons table, listing the real names of the members of the band or group that is associated with the artist of the music
Only some MP3 files have this information
The person listed first the MP3 metadata is assumed to be the "lead" member of the group
Assumes that all persons are associated with the same Artist per track
This assumption is safe so long as the "Artist" metadata of the MP3 file only lists 1 music group
Needs Verified: I believe that tracks that are collaborations usually have both artists listed as a "new" artist in the artist metadata. Something like Artist = "artist1 & artist2" rather than Artist = ["artist1", "artist2"]
Maintable that TagLib was able to find (Note that only some MP3s have some or all of this data, depending on how much data the publisher of the music wanted to add to the file):ArtisttableAlbumtableArtistPersonstable, listing the real names of the members of the band or group that is associated with the artist of the musicArtist = "artist1 & artist2"rather thanArtist = ["artist1", "artist2"]