Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-1839

Track MBID SQL changes

    XMLWordPrintable

    Details

      Description

      Before NGS a track could only ever be on one release, so the Track Id uniquely identified a track on a particulr release. With NGS tracks (now known as recordings) can be on multiple releases so the recording id (replacing the track id) no longer identifies a recording on a release.

      To do that you now need to store the recordingid and releaseid, and then iterate through the tracks on the release to find where it on the release, but this is a bit of a pain.

      Alternatively you need to store the trackno as well, the disadvantage of this is that whilst end user applications making use of Musicbrainz can hide the recordingid and releaseid the trackno is normally visible to the user, hence it can be modified breaking the link to Musicbrainz.

      Another issue is finding of duplicates, now looking for duplicates purely by trackid/recordingid would delete the same song on two different releases which probably is not what users would normally want.

      Both of these problems are easy enough to work round, but it would be alot easier if the track on a release could be allocated a trackid, and I wonder if there are situations whereby the lack of a trackid is really going to cause some headaches.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                warp Kuno Woudt
                Reporter:
                ijabz Paul Taylor
              • Votes:
                5 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Schema change, 2013-05-15