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