I mean depending on how PG plans the query, it could be quicker to do it per-edit, since we have more information (a specific editor ID and whether the flag is set)
2024-02-20 05109, 2024
reosarevok
Hmm
2024-02-20 05111, 2024
reosarevok
Ok
2024-02-20 05120, 2024
reosarevok
I thought something like "UPDATE editor SET privs = privs - $BEGINNER_FLAG WHERE member_since > NOW() - INTERVAL '2 weeks' AND EXISTS (SELECT 1 FROM edit WHERE edit.editor = editor.id AND edit.autoedit = 0 AND edit.status = ' . $STATUS_APPLIED . ' OFFSET 9)" would do them all in one go
2024-02-20 05126, 2024
reosarevok
And be a lot faster than sending a ton of queries
2024-02-20 05128, 2024
reosarevok
But maybe not?
2024-02-20 05120, 2024
reosarevok
(I just realized we're doing "EXISTS (SELECT 1 FROM edit WHERE edit.editor = editor.id AND edit.autoedit = 0 AND edit.status = ' . $STATUS_APPLIED . ' OFFSET 9) AS has_ten_accepted_edits" every time we load an editor, which seems... eh)
2024-02-20 05103, 2024
bitmap
I don't think it will be slow whether it's done in one query or many
2024-02-20 05101, 2024
bitmap
just saying that even if the batch query only takes 1s, the edit check on its own (for a single editor ID) might take sub-1ms, and we probably aren't handling 1,000 beginners per hour
2024-02-20 05112, 2024
reosarevok
Well, we can try that then :)
2024-02-20 05115, 2024
bitmap
(the privs and member_since would already be loaded as part of the editor, so could be checked in Perl)
lucifer: I just logged into beta.lb without trouble, if that helps
2024-02-20 05125, 2024
lucifer
aerozol[m]: if you could do it on test.lb now, that would certainly help
2024-02-20 05130, 2024
lucifer
actually wait a sec
2024-02-20 05113, 2024
lucifer
yup ready now
2024-02-20 05116, 2024
aerozol[m]
No issues here
2024-02-20 05123, 2024
aerozol[m]
(just logged in again)
2024-02-20 05136, 2024
lucifer
thanks
2024-02-20 05104, 2024
aerozol[m]
lucifer: ansh: mayhem: monkey: isabelxxx posted some interesting background info and a github link to an existing ‘genre explorer’/map project that looks cool. If you’re interesting it’s on https://tickets.metabrainz.org/browse/LB-1509?
2024-02-20 05105, 2024
BrainzBot
LB-1509: Genre explorer
2024-02-20 05142, 2024
aerozol[m]
preeeettty
2024-02-20 05103, 2024
aerozol[m] uploaded an image: (888KiB) < https://matrix.moviebrainz.org/_matrix/media/v3/download/matrix.org/LmMQraihGDaMLhyqQtPGcexr/image.png >
2024-02-20 05124, 2024
aerozol[m] uploaded an image: (132KiB) < https://matrix.moviebrainz.org/_matrix/media/v3/download/matrix.org/qKjerqrgFjoZHpxxQXvSwZfB/image.png >
2024-02-20 05134, 2024
aerozol[m]
Also very cool to compare different databases (thanks @UltimateRiff for the find and post)
2024-02-20 05143, 2024
discordbrainz
<02UltimateRiff> one of the devs pinged me about it when they saw I created the ticket for the genre explorer~
i have set the threshold to 10 at the moment, i can do a run to generate the data tomorrow.
2024-02-20 05148, 2024
technmad
I have been going through issue tacker, I was looking for frontend related issue but had a harder time finding those. Is there a way to segregate those issues, any filter criteria in particular
2024-02-20 05115, 2024
bobbyflips joined the channel
2024-02-20 05120, 2024
bobbyflips has quit
2024-02-20 05158, 2024
ssam has quit
2024-02-20 05117, 2024
technmad has quit
2024-02-20 05105, 2024
aerozol[m]
lucifer: awesome, thanks for tackling this!
2024-02-20 05109, 2024
ssam joined the channel
2024-02-20 05155, 2024
aerozol[m]
technmad: did you have a project in mind? e.g. MusicBrainz, ListenBrainz, Picard, BookBrainz
2024-02-20 05148, 2024
discordbrainz
<09technmad> I'm currently looking into ListenBrainz
