reosarevok: Yeah, do my work for me, see if I care :p
2018-09-18 26132, 2018
zas
70% of hits on the mb website yesterday were from (verified) googlebot (1277045 hits) and yet searching for an small unknown band existing in the db, indexed (search with site:musicbrainz.org shows it) doesn't appear at all over 15 pages of results... discogs appears on 5th page, qobuz on 7th, official sites on 1st/2nd pages, but musicbrainz absolutly nowhere over 15 pages. It sucks.
2018-09-18 26157, 2018
zas
any SEO expert around ? ;)
2018-09-18 26114, 2018
reosarevok
Mr_Monkey: if you do the programming, I'm happy to do the asking :p
2018-09-18 26110, 2018
LordSputnik
Mr_Monkey: we should do a more general database cleanup, as well as fixing the invalid relationships
2018-09-18 26135, 2018
LordSputnik
Things like deduplicating alias/identifier tables
2018-09-18 26127, 2018
LordSputnik
until yesterday, the site code re-inserted all the aliases for every entity every time it was edited due to a code bug
2018-09-18 26131, 2018
Mr_Monkey
LordSputnik: Yes, that sounds sane :) Are there already scripts for cleanup operations?
2018-09-18 26140, 2018
Mr_Monkey
Oof.
2018-09-18 26156, 2018
LordSputnik
Nope, not currently
2018-09-18 26123, 2018
LordSputnik
We should write some and put them in bb-sql/scripts
2018-09-18 26128, 2018
Mr_Monkey
Yep
2018-09-18 26105, 2018
LordSputnik
Yeah, it was due to the set handling code, which was fixed and moved into bb-data this summer. It's now unit tested to make sure nothing gets duplicated
2018-09-18 26125, 2018
Leo_Verto
KassOtsimine, sorry, I didn't realize that
2018-09-18 26116, 2018
KassOtsimine
no prob
2018-09-18 26125, 2018
KassOtsimine
i was feeling grumpy :)
2018-09-18 26141, 2018
zas
reosarevok: i just noticed we don't ask for a disambiguation when creating a new RG having the same name of an existing one, as we do for artists. Asking for one would reduce a lot duplicates, is there any suggestion/ticket you're aware of for this ?
2018-09-18 26115, 2018
reosarevok
We mostly don't enter rgs by hand, but automatically
2018-09-18 26143, 2018
KassOtsimine
zas: if on the same artist maybe. but else it could get pretty hairly quickly. other thna that good idea!
2018-09-18 26116, 2018
zas
i mean we can ask for disambiguation as well as confirmation when a new RG of the same name exists for the same artist
LordSputnik: I'll create a ticket for it so it doesn't disappear. I still suck at SQL and I feel like I would fuck it up without realising. Would you have the bandwidth to take care of those cleanup operations (not the creator deduping or anything like that)?
2018-09-18 26144, 2018
KassOtsimine
it might even help against duplicate releases
2018-09-18 26105, 2018
zas
just created those (artist called releases "EP", perhaps it should be self-titled, but that's the same)
2018-09-18 26111, 2018
zas
in general, i think we should have better safe checks to prevent common mistakes to happen (like creating a new RG when not needed, which is VERY often)
2018-09-18 26142, 2018
zas
or check packaging set to None on a physical release, or to anything but None on digital releases
2018-09-18 26126, 2018
zas
chhavi_: ^^ included in your plan ?
2018-09-18 26107, 2018
KassOtsimine
zas: well not setting packaging on physical release ,.. often i don't know waht packaging my dumb library has wrecked so i know not which it is
2018-09-18 26120, 2018
zas
that's not what i say
2018-09-18 26127, 2018
KassOtsimine
oh? i missunderstood
2018-09-18 26151, 2018
zas
CD packaging = None is VERY rare (we should warn about it, not forbid it)
2018-09-18 26112, 2018
KassOtsimine
oh no explisitly *not set* but explisitly set to *none* ah
2018-09-18 26128, 2018
zas
and digital release with packaging digipak is also uber-rare
2018-09-18 26132, 2018
KassOtsimine
now i get
2018-09-18 26115, 2018
zas
same for capitalization rules, they have to be linked directly from release editor (depending on selected languages), a new editor hardly knows about then.
2018-09-18 26138, 2018
LordSputnik
Mr_Monkey: Yeah, I can do that at some point
2018-09-18 26151, 2018
LordSputnik
Happy to have that assigned to me
2018-09-18 26153, 2018
zas
Having better infos from the start would reduce a lot edits
2018-09-18 26131, 2018
KassOtsimine
:o I thought cap rules where! yes i agree
2018-09-18 26145, 2018
Mr_Monkey
LordSputnik: Thanks, that would be very helpful. I don't think it's a huge rush as it doesn't currently keep anyone from using the site or database correctly, if I'm not mistaken.
2018-09-18 26109, 2018
reosarevok
Merging! Merging! There are two Lovecrafts! ;)
2018-09-18 26116, 2018
reosarevok
I guess there is a ticket for that though
2018-09-18 26146, 2018
KassOtsimine
oh no two lovecrafts?! thats like dividing by zero!
2018-09-18 26145, 2018
zas
rather than merging entities, i'd like to prevent them from the start (whenever it makes sense), it reduces the amount of work for all, and the size of the db....
2018-09-18 26103, 2018
KassOtsimine rolls
2018-09-18 26116, 2018
reosarevok
Both are needed ;)
2018-09-18 26122, 2018
zas
of course
2018-09-18 26127, 2018
zas
:))
2018-09-18 26130, 2018
KassOtsimine
i rememember *distinctly* saying something like this about recrordings when NGS was happening
2018-09-18 26131, 2018
reosarevok
But yeah, that too
2018-09-18 26152, 2018
KassOtsimine
;)
2018-09-18 26153, 2018
reosarevok
KassOtsimine: not much to be done with that though was there? Other than risking merging the wrong recordings automatically
2018-09-18 26115, 2018
reosarevok
That was a mess we couldn't probably solve properly in any way :/
2018-09-18 26135, 2018
KassOtsimine
¯\_(ツ)_/¯
2018-09-18 26139, 2018
reosarevok
LordSputnik, Mr_Monkey: what should happen with introductory notes by editors? New work too?
2018-09-18 26145, 2018
KassOtsimine
oh shit that's a thing that's separatr? D:
2018-09-18 26149, 2018
Mr_Monkey
In the near future, yes, I think so. There isn't currently the correct work type, though.
2018-09-18 26142, 2018
Mr_Monkey
The other options is to only have the relationship between a Creator and an Edition. I'm open to opinions.
2018-09-18 26144, 2018
ruaok
huh. our "temporary" FreeDB gateway has been in operation for 11 years and is still getting 2 requests per second.
I will very soon open a big discussion about the BookBrainz schema and how everything fits. I know the discussion has been had before, but I want more :)
2018-09-18 26147, 2018
ruaok
we kill the gateway and the next day brexit happens. should be a fun week.
outsidecontext, zas, samj1912: does one of you know if something has changed in the way picard handles exceptions? I'm pretty sure picard 1 basically caught every single exception, so you could at least save already correctly associated albums etc. this does not seems to be the case anymore with picard 2
2018-09-18 26135, 2018
Mr_Monkey
"Congratulations! MetaBrainz Foundation has been selected as a Google Code-in 2018 mentoring organization." Woop wooop !
2018-09-18 26124, 2018
rsh7
yayy!
2018-09-18 26100, 2018
bukwurm joined the channel
2018-09-18 26141, 2018
LordSputnik
Damnit, I guess we need some tasks then!
2018-09-18 26123, 2018
SirLagz29 joined the channel
2018-09-18 26126, 2018
SirLagz29 has quit
2018-09-18 26154, 2018
CatQuest
ok wtf. how am I supposed to select that Neil *wrote* https://bookbrainz.org/edition/ef52527a-f68b-4106… ? i tried in both ends. in nei'ls end and in this. i only get every at other than "wrote" what?
2018-09-18 26149, 2018
Mr_Monkey
CatQuest: That's an Edition you're looking at. The 'wrote' relationship is between a Creator and a Work
but in for example mb, we have the "artist credit on the release"
2018-09-18 26108, 2018
Mr_Monkey
I think that's from a previous version with no constraints for relationships.
2018-09-18 26123, 2018
CatQuest
wich is separate from the "various roles through relationships(on works)"
2018-09-18 26127, 2018
CatQuest
yes
2018-09-18 26143, 2018
CatQuest
but it's.. very unclear and frustrating becasue I didn't know hat :)
2018-09-18 26144, 2018
Mr_Monkey
If you edit the relationship by re searching for "The Sleeper and the Spindle" for example, 'wrote' isn't in the available relationships anymore
2018-09-18 26158, 2018
CatQuest
yea so i'm not gonig ot do that ;)
2018-09-18 26104, 2018
Mr_Monkey
:D
2018-09-18 26152, 2018
CatQuest
but my point still stands. "publicist" is a filed in an edition, but "author" isn't. that is really really weird
2018-09-18 26107, 2018
CatQuest
field*
2018-09-18 26116, 2018
Mr_Monkey
Agreed. The relationships between entities, and sometimes the entities themselves, aren't quite clear.
2018-09-18 26125, 2018
CatQuest
anyway what this means in order to link a *book* with a *writer of said book* you have ot create 3, three. thngis: publicatio for the edition, and thne a woork to link edition/book to the autor. not.. ideal
2018-09-18 26106, 2018
Mr_Monkey
Yes, I found it quite confusing when I first played with the website.
2018-09-18 26110, 2018
CatQuest
ideally I should only *have* to create the "edition", the publication(editiongroup) to be autocreated or be abl to l ink to an old one :)
2018-09-18 26144, 2018
CatQuest
i still don't really groc the differnce between a "work" and a" publication" in the grant sense of things. books are often considered the work in and of themselves
2018-09-18 26145, 2018
Mr_Monkey
I Think There's A Ticket For That™
2018-09-18 26101, 2018
CatQuest
much like contemporary albums
2018-09-18 26151, 2018
CatQuest
(where i onte, you have works for the individual recordings, but not a work for the release/album as a whole (unless we're talking concept album or classicla work, but these are not the "album" as a work, but the album is the mendioum of the work yadda yadda))
2018-09-18 26153, 2018
reosarevok
CatQuest: a short story collection has a lot of works, but isn't necessarily a work in itself - yet it's a publication / edition
2018-09-18 26133, 2018
reosarevok
Even most classic novels reissued nowadays have at least two works, arguably: the actual novel, and some extra introduction text by an expert telling you about it :)
