#musicbrainz

/

      • Vexatoast has quit
      • 2018-12-01 33518, 2018

      • Vexatos joined the channel
      • 2018-12-01 33537, 2018

      • Toast has quit
      • 2018-12-01 33528, 2018

      • Vexatos has quit
      • 2018-12-01 33526, 2018

      • Vexatos joined the channel
      • 2018-12-01 33508, 2018

      • simukis has quit
      • 2018-12-01 33537, 2018

      • Vexatos has quit
      • 2018-12-01 33506, 2018

      • Vexatos joined the channel
      • 2018-12-01 33527, 2018

      • intcat has quit
      • 2018-12-01 33528, 2018

      • lidel joined the channel
      • 2018-12-01 33544, 2018

      • D4RK-PH0ENiX has quit
      • 2018-12-01 33504, 2018

      • D4RK-PH0ENiX joined the channel
      • 2018-12-01 33509, 2018

      • Vexatos has quit
      • 2018-12-01 33535, 2018

      • xplt_ has quit
      • 2018-12-01 33553, 2018

      • Vexatos joined the channel
      • 2018-12-01 33553, 2018

      • Vexatos has quit
      • 2018-12-01 33521, 2018

      • Vexatos joined the channel
      • 2018-12-01 33541, 2018

      • timbl has quit
      • 2018-12-01 33541, 2018

      • Vexatos has quit
      • 2018-12-01 33516, 2018

      • Vexatos joined the channel
      • 2018-12-01 33535, 2018

      • timbl joined the channel
      • 2018-12-01 33557, 2018

      • D4RK-PH0ENiX has quit
      • 2018-12-01 33538, 2018

      • Vexatos has quit
      • 2018-12-01 33503, 2018

      • Vexatos joined the channel
      • 2018-12-01 33551, 2018

      • D4RK-PH0ENiX joined the channel
      • 2018-12-01 33536, 2018

      • timbl has quit
      • 2018-12-01 33556, 2018

      • Cyna has quit
      • 2018-12-01 33505, 2018

      • Leo_Verto_ joined the channel
      • 2018-12-01 33510, 2018

      • Leo_Verto has quit
      • 2018-12-01 33510, 2018

      • Leo_Verto_ is now known as Leo_Verto
      • 2018-12-01 33544, 2018

      • D4RK-PH0ENiX has quit
      • 2018-12-01 33512, 2018

      • D4RK-PH0ENiX joined the channel
      • 2018-12-01 33523, 2018

      • D4RK-PH0ENiX has quit
      • 2018-12-01 33538, 2018

      • Zialus has quit
      • 2018-12-01 33530, 2018

      • Zialus joined the channel
      • 2018-12-01 33528, 2018

      • D4RK-PH0ENiX joined the channel
      • 2018-12-01 33519, 2018

      • D4RK-PH0ENiX has quit
      • 2018-12-01 33546, 2018

      • d3daim joined the channel
      • 2018-12-01 33507, 2018

      • simukis joined the channel
      • 2018-12-01 33545, 2018

      • simukis has quit
      • 2018-12-01 33527, 2018

      • dominikh
        is there some kind of wiki page or similar for tags?
      • 2018-12-01 33545, 2018

      • dominikh
        seeing which are popular, agreeing on certain tags for certain uses, etc
      • 2018-12-01 33520, 2018

      • dominikh
        seeing game,game music,vgm on the same RG doesn't make me too hopeful :P
      • 2018-12-01 33544, 2018

      • yvanzo
        top tags are listed at https://musicbrainz.org/tags
      • 2018-12-01 33537, 2018

      • D4RK-PH0ENiX joined the channel
      • 2018-12-01 33548, 2018

      • yvanzo
      • 2018-12-01 33532, 2018

      • dominikh
        I was hoping for a community effort to agree on tags for when synonymous tags exist
      • 2018-12-01 33501, 2018

      • yvanzo
        there is no guideline, it's open, community agreement is expressed with vote
      • 2018-12-01 33554, 2018

      • Vexatos has quit
      • 2018-12-01 33525, 2018

      • Vexatos joined the channel
      • 2018-12-01 33546, 2018

      • BabyJesus666 has quit
      • 2018-12-01 33522, 2018

      • xplt joined the channel
      • 2018-12-01 33526, 2018

      • xplt is now known as xplt_
      • 2018-12-01 33520, 2018

      • xplt_ has quit
      • 2018-12-01 33533, 2018

      • reosarevok
        dominikh: if you mean for genres, we have one "marked" genre, while the others currently aren't
      • 2018-12-01 33539, 2018

      • reosarevok
        But for non-genres, there's nothing specific, no
      • 2018-12-01 33553, 2018

      • dominikh
        reosarevok: right, for non-genre. I just noticed a lot of duplicate tags, like the aforementioned game,game music,vgm – which all express the same idea
      • 2018-12-01 33522, 2018

      • dominikh
        so of course part of me wishes for that data to be normalized :P
      • 2018-12-01 33558, 2018

      • reosarevok
        An option would be to make a bot that adds the other two when one is there, then it's "normalized" ;p
      • 2018-12-01 33531, 2018

      • dominikh
        bonus points for nefariousness if it also downvotes the other two?
      • 2018-12-01 33519, 2018

      • CatQuest
        -1 to the nefariousness
      • 2018-12-01 33527, 2018

      • CatQuest
        but the other idea i propose hartily
      • 2018-12-01 33550, 2018

      • dominikh
        I'm torn on that idea. It does mean that if the original tag was wrong, and nobody has downvoted it yet, the bot would end up adding another incorrect tag
      • 2018-12-01 33546, 2018

      • Cyna joined the channel
      • 2018-12-01 33524, 2018

      • reosarevok
        True. But tags are not right or wrong, you just agree with them or not :p
      • 2018-12-01 33546, 2018

      • reosarevok
        If I think Bach is video game music, then it is! :D (for me) - maybe I'm making a video game that uses Bach :p
      • 2018-12-01 33553, 2018

      • dominikh
        in that case I propose a plethora of new relationships so that we can record the absolute truth :P
      • 2018-12-01 33548, 2018

      • reosarevok
        Even Wikidata doesn't try to do that and they have allll the relationships :p
      • 2018-12-01 33501, 2018

      • CallerNo6 has quit
      • 2018-12-01 33509, 2018

      • CallerNo6 joined the channel
      • 2018-12-01 33529, 2018

      • xplt joined the channel
      • 2018-12-01 33535, 2018

      • xplt is now known as xplt_
      • 2018-12-01 33506, 2018

      • Leo_Verto_ joined the channel
      • 2018-12-01 33505, 2018

      • Leo_Verto has quit
      • 2018-12-01 33506, 2018

      • Leo_Verto_ is now known as Leo_Verto
      • 2018-12-01 33522, 2018

      • outsidecontext joined the channel
      • 2018-12-01 33538, 2018

      • peaveyman has quit
      • 2018-12-01 33518, 2018

      • peaveyman joined the channel
      • 2018-12-01 33502, 2018

      • Leo_Verto_ joined the channel
      • 2018-12-01 33507, 2018

      • Leo_Verto has quit
      • 2018-12-01 33507, 2018

      • Leo_Verto_ is now known as Leo_Verto
      • 2018-12-01 33530, 2018

      • outsidecontext has quit
      • 2018-12-01 33553, 2018

      • Toast joined the channel
      • 2018-12-01 33528, 2018

      • simukis joined the channel
      • 2018-12-01 33508, 2018

      • Cyna has quit
      • 2018-12-01 33532, 2018

      • D4RK-PH0ENiX has quit
      • 2018-12-01 33532, 2018

      • D4RK-PH0ENiX joined the channel
      • 2018-12-01 33549, 2018

      • CatQuest is now known as lutefix
      • 2018-12-01 33559, 2018

      • c1e0 joined the channel
      • 2018-12-01 33534, 2018

      • lutefix is now known as CatCat
      • 2018-12-01 33541, 2018

      • zykotick9 joined the channel
      • 2018-12-01 33526, 2018

      • CallerNo6 is now known as CallerOhNo6
      • 2018-12-01 33541, 2018

      • c1e0_ joined the channel
      • 2018-12-01 33527, 2018

      • c1e0 has quit
      • 2018-12-01 33521, 2018

      • c1e0_ has quit
      • 2018-12-01 33545, 2018

      • Toast has quit
      • 2018-12-01 33559, 2018

      • Toast joined the channel
      • 2018-12-01 33540, 2018

      • Jybz joined the channel
      • 2018-12-01 33513, 2018

      • Toast has quit
      • 2018-12-01 33515, 2018

      • dominikh
        hm, question about the actual database: when entities get merged, redirects are being added to _gid_redirect tables. does that imply the original rows with the old gids get deleted?
      • 2018-12-01 33501, 2018

      • reosarevok
        Yeah
      • 2018-12-01 33529, 2018

      • reosarevok
        But relationships etc are transferred to the entity they got merged into first
      • 2018-12-01 33535, 2018

      • dominikh
        right. I'm playing around with some software/database designs that rely heavily on MB data, using a local version of the database. if entities can be deleted, I'll have to keep that in mind when designing my foreign keys :)
      • 2018-12-01 33509, 2018

      • CallerOhNo6
        ^ entities can *also* be outright deleted.
      • 2018-12-01 33524, 2018

      • dominikh
        does that ever happen to entities that aren't spam?
      • 2018-12-01 33548, 2018

      • CallerOhNo6
        ideally "hardly ever", but it can happen.
      • 2018-12-01 33510, 2018

      • reosarevok
        dominikh: it also happens if someone just adds, say, an artist that does exist, but doesn't use it
      • 2018-12-01 33528, 2018

      • reosarevok
        (adding at least one relationship, even if it's just a link, avoids that)
      • 2018-12-01 33551, 2018

      • CallerOhNo6
        oh, good point. I forgot about that.
      • 2018-12-01 33531, 2018

      • dominikh
        right. those cases are probably the easiest to handle with my use case. if nothing uses it, I won't, either. merges prove far more difficult. imagine an experimental music database/player that pretends to live in a world where everything is tagged with musicbrainz IDs.
      • 2018-12-01 33543, 2018

      • dominikh
        files are stored as their track IDs
      • 2018-12-01 33509, 2018

      • dominikh
        a bunch of postgresql triggers can probably take care of it, though
      • 2018-12-01 33501, 2018

      • CallerOhNo6
        Cool. I'd like to see how that comes together.
      • 2018-12-01 33505, 2018

      • dominikh
        unlikely to turn into anything user-friendly, on account of all the databases that need setting up and maintaining, but it may be a nice toy for the nerds among us
      • 2018-12-01 33548, 2018

      • CallerOhNo6
        I guess one other (hopefully rare) case you'd need to consider is when something is merged in error, and then needs to be recreated (with a new MBID).
      • 2018-12-01 33533, 2018

      • dominikh
        that pretty much requires manual intervention and retagging, won't it
      • 2018-12-01 33506, 2018

      • CallerOhNo6
        not always, but yeah
      • 2018-12-01 33507, 2018

      • CallerOhNo6
        e.g. recordings might be incorrectly merged, but the release ID remain unchanged
      • 2018-12-01 33513, 2018

      • dominikh
        yeah, I'll probably only store track IDs and figure out the rest via joins. reduce the risk of IDs disappearing
      • 2018-12-01 33554, 2018

      • dominikh
        at any rate, early days. will see how many issues I run into
      • 2018-12-01 33505, 2018

      • slurpee- joined the channel
      • 2018-12-01 33532, 2018

      • Slurpee has quit
      • 2018-12-01 33501, 2018

      • m1dgard
      • 2018-12-01 33521, 2018

      • m1dgard
        if not, i'll open a merge edit
      • 2018-12-01 33552, 2018

      • Rotab
        thats one old release
      • 2018-12-01 33503, 2018

      • Jybz has quit
      • 2018-12-01 33545, 2018

      • reosarevok
      • 2018-12-01 33550, 2018

      • lidel` joined the channel
      • 2018-12-01 33545, 2018

      • lidel has quit
      • 2018-12-01 33546, 2018

      • lidel` is now known as lidel
      • 2018-12-01 33548, 2018

      • m1dgard
        ftr: that described merge edit is now open: https://musicbrainz.org/edit/57782481
      • 2018-12-01 33520, 2018

      • slurpee- has quit
      • 2018-12-01 33519, 2018

      • svennidal has quit
      • 2018-12-01 33522, 2018

      • simukis has quit
      • 2018-12-01 33555, 2018

      • zykotic10 joined the channel
      • 2018-12-01 33556, 2018

      • zykotick9 has quit