mayhem: going to start making dinner soon, but if it's shortish I do
2024-04-16 10738, 2024
reosarevok
What is it?
2024-04-16 10753, 2024
mayhem
doubt its shortish. :)
2024-04-16 10739, 2024
reosarevok
Well, ask and I'll see when I find the time? :)
2024-04-16 10749, 2024
reosarevok
Or if it's urgent, I can have dinner later 😅
2024-04-16 10755, 2024
mayhem
I would like to have a query that fetches all of the artists and their origin country. skip all artists who do not have a country associated and resolve all areas that are more fine grained than country.
2024-04-16 10704, 2024
mayhem
not urgent. but I suspect tricky.
2024-04-16 10732, 2024
reosarevok
Hmm
2024-04-16 10753, 2024
mayhem
wait. dinner at 17h?
2024-04-16 10716, 2024
reosarevok
Dinner at 17:30 to 18 :)
2024-04-16 10732, 2024
mayhem
still about 3 hours early.
2024-04-16 10747, 2024
huhridge has quit
2024-04-16 10749, 2024
reosarevok
Well, sure, we're still somewhat on an Estonian schedule :) But the EU lunch hours are actually 12:30 to 13:30, so it's almost Estonian
2024-04-16 10752, 2024
reosarevok
Anyway
2024-04-16 10726, 2024
reosarevok
Does your DB have the area_containment materialized table?
2024-04-16 10743, 2024
reosarevok
If so, it shouldn't actually be too hard
2024-04-16 10748, 2024
mayhem
I'm working from an MB replica on wolf.
2024-04-16 10702, 2024
reosarevok
Assuming the replica has the materialized tables built it should be fine
2024-04-16 10706, 2024
mayhem
it does
2024-04-16 10730, 2024
mayhem
clue me what descendant, parent and depth are?
2024-04-16 10703, 2024
mayhem
or write me a query.
2024-04-16 10704, 2024
mayhem
wait.
2024-04-16 10709, 2024
mayhem
sudo write me a query
2024-04-16 10711, 2024
mayhem runs
2024-04-16 10739, 2024
reosarevok
lol
2024-04-16 10744, 2024
reosarevok
I can look into a query after dinner :)
2024-04-16 10749, 2024
mayhem
ok.
2024-04-16 10751, 2024
mayhem
thanks.
2024-04-16 10755, 2024
lucifer
mayhem: yes, should be done soon. was interrupted by other stuff.
2024-04-16 10711, 2024
mayhem
no rush, I just worked out a much better result format
2024-04-16 10715, 2024
lucifer
>I would like to have a query that fetches all of the artists and their origin country. skip all artists who do not have a country associated and resolve all areas that are more fine grained than country.
2024-04-16 10718, 2024
mayhem
hopefuly that won't screw you up too much.
2024-04-16 10719, 2024
lucifer
we have this already no?
2024-04-16 10726, 2024
mayhem
do we? where?
2024-04-16 10745, 2024
Rotab has quit
2024-04-16 10746, 2024
lucifer
there's a labs api endpoint to get country by artist mbid
2024-04-16 10723, 2024
mayhem
yea and that query is horrible and super slow. always times out.
2024-04-16 10738, 2024
Rotab joined the channel
2024-04-16 10743, 2024
mayhem
I didn't know about that materialzed table. should make this much easier.
2024-04-16 10749, 2024
Tarun_0x0 joined the channel
2024-04-16 10722, 2024
lucifer
mayhem: ah cool, yes the table and we also fetch the entire data for spark so we have it cached there.
2024-04-16 10744, 2024
mayhem
good good.
2024-04-16 10754, 2024
qookie has quit
2024-04-16 10707, 2024
Rotab has quit
2024-04-16 10708, 2024
qookie joined the channel
2024-04-16 10749, 2024
Rotab joined the channel
2024-04-16 10748, 2024
qookie has quit
2024-04-16 10702, 2024
qookie joined the channel
2024-04-16 10712, 2024
lucifer
bitmap: hi! if i use `musicbrainz_ro` to access to the database on musicbrainz standby database that would ensure that i can't write to the database even by error, right?
2024-04-16 10742, 2024
bitmap
lucifer: yes, it should only have select granted
2024-04-16 10756, 2024
lucifer
great, thanks!
2024-04-16 10752, 2024
bitmap
(you can also do SET TRANSACTION READ ONLY if you're worried about that)
2024-04-16 10704, 2024
lucifer
makes sense
2024-04-16 10713, 2024
lucifer
mayhem: do you still need the top level counts?
2024-04-16 10736, 2024
lucifer
for how many recordings are there for a given tag.
[musicbrainz-server] 14yellowHatpro opened pull request #3238 (03master…MBS-13533-fixes-yellowhatpro): MBS-13533: Fix order of cover art in release group artwork https://github.com/metabrainz/musicbrainz-server/…
mayhem: when you say "artist and country" do you mean names, MBIDs, both?
2024-04-16 10707, 2024
reosarevok
And when you say "resolve all areas that are more fine grained than country" it just means "give the country", right?
2024-04-16 10754, 2024
lucifer
bitmap: does the consul service pgbouncer-slave exist under a new name?
2024-04-16 10756, 2024
lucifer
*now
2024-04-16 10755, 2024
bitmap
lucifer: no it should be the same
2024-04-16 10714, 2024
huhridge joined the channel
2024-04-16 10748, 2024
reosarevok
mayhem: also, when you say "origin country" do you mean "their country" or do you specifically care about "begin area"?
2024-04-16 10744, 2024
lucifer
aerozol: hi! sorry i had figured too many issues last time to fix so i never scheduled the meeting for oauth stuff. but its working now, sort of and will you be available later today or tomorrow to meet and discuss some UI/UX stuff?
2024-04-16 10716, 2024
reosarevok
mayhem: I *think* this should do more or less what you want:
Although I guess if they have an artist area that is a country *and* part of a country, that'll be duplicated (Netherlands, Curaçao etc vs Kingdom of the Netherlands is probably the main one, but also Puerto Rico vs US IIRC)
2024-04-16 10700, 2024
reosarevok
bitmap: can you think of a better way to avoid that than just make the two queries separately and just say "if the artist has a direct country ignore the parent country"?
2024-04-16 10706, 2024
monkey[m] has quit
2024-04-16 10721, 2024
bitmap
I guess you can left join on area again with type = 1 in the join condition, then use coalesce to prefer the direct country
2024-04-16 10728, 2024
kilos_ has quit
2024-04-16 10741, 2024
kilos_ joined the channel
2024-04-16 10741, 2024
yvanzo
bitmap, reosarevok: May I deploy perl 5.38 PR to the test branch for `test.mb.o`?
2024-04-16 10709, 2024
reosarevok
I'm not using test.mb - bitmap might be tho
2024-04-16 10757, 2024
yvanzo
bitmap: Please let me know if you think that it is needed to deploy it to test.mb.o because I already tested it locally, and I don’t expect much changes but emails are disabled on test.mb.o anyway.
2024-04-16 10733, 2024
yvanzo
*which are
2024-04-16 10719, 2024
bitmap
yvanzo: I have the eaa branch running on test.db atm, but you may replace it if needed. (I don't see an urgent need if the tests all pass)
bitmap: possibly yes, especially given it's taking so many hours :)
2024-04-16 10732, 2024
Kladky has quit
2024-04-16 10715, 2024
huhridge joined the channel
2024-04-16 10737, 2024
huhridge has quit
2024-04-16 10732, 2024
aerozol[m] joined the channel
2024-04-16 10732, 2024
aerozol[m]
lucifer: Hey! I am around today/tonight for a meeting. Just looking at a international planner tool atm...
2024-04-16 10705, 2024
aerozol[m]
Anytime between your 10.30 - 12.30am would work for me! Or feel free to ping me when you’re up and ready
2024-04-16 10712, 2024
yellowhatpro has quit
2024-04-16 10758, 2024
aerozol[m]
Does anybody have strong feelings about reviews in CB that are the start of a review, and then ‘read more’ with a link to a review site? (looks like the same user wrote both, so no plagiarism)
2024-04-16 10701, 2024
aerozol[m]
It’s not against the rules, but we could consider adding something. I have no strong feelings on it, it seems fine - a bit annoying when links eventually die.
2024-04-16 10751, 2024
aerozol[m]
A user has started adding a bunch of them. Kind of nice that someone sees CB as visible enough to do so! Possible via LB
