#metabrainz

ruaok, zas: would it be possible to upgrade the wiki.musicbrainz VM to a newer OS version? it's on xenial now, which has PHP 7.0. if we could go to focal with 7.4, that would be ideal.

Morning!

iliekcomputers: ping

Good Morning!

legoktm: yes, but it would be perhaps safer to build a new VM from scratch, and migrate

that works too :)

IIRC that's what we did last time

ishaanshah: pong

Morning!!

morning!

mooooin!

iliekcomputers: Hi, I think I found a way to make the daily activity query faster

Can you have a look at the sql query plan once

I found this online service which provide a notebook like environment for spark

It's pretty cool, we can even get the plots directly inline

Also I am talking about the query plan for `result_without_zero_hours.explain()`

the second step is not necessary, it's just filling in the hours which have 0 listens

Truncate the listened_at to get the hour and then an equality check. Hmm. The explain seems reasonable.

Cool, I will productionise it then

Wow. Never even knew "productionise" was a word, but it is :D

ishaanshah: you will soon be able to run pyspark in jupyter notebooks

Not exactly jupyter notebook but a similar environment based on it

wow, the linked in UI is freaking terrible. it keeps getting worse and worse.

Its confusing

The mobile app always shows old posts :/

Is there an actual point to LinkedIn? I always assumed it was a place for career people to show off

Also, ruaok: https://tickets.metabrainz.org/browse/MBS-10967 - I think it makes sense, but it's probably going to be seen as a political statement by some, so making sure you're ok with me implementing this? :)

MBS-10967: Add Kosovo to the list of release countries

reosarevok: yeah, that and recruiters

(it only recently got marked as a country at all in MB due to that same issue)

reosarevok: I'm ok with that.

wow, the latest merge of master into timescale-final had zero merge conflicts.

Ok, thanks!

reosarevok: LinkedIn sometimes helps connecting with good people and those good people share good resources. Might help in getting referrals too

Is referral that thing where someone tells "they are a good worker and stuff" when you apply for some other company?

Yes its quite the same

But I totally agree people show off a lot on it

People were showing off Arctic Code Vault Contributor batch. I guess almost everyone got it. Whats the point in show off

unless I missed a notifcation, I wasn't included on the code vault... I guess I dont have enough code up there. :)

I never even heard of the vault thing :D

i do not understand the point of code vault

it mostly seems to be for pr purposes

ruaok: I guess everyone who contributed befor feb 2020 got it

_lucifer: No

Github just put a backup of all the code on it till feb 2020 into the code vault so that in case their DB gets destroyed at any moment the copy till feb 2020 is safe for generations to com

yeah i understand that but how would that work out

they are storing it on film reels

how will they regenerate the repos from it

good morning

ruaok: you have that badge on your profile

See highlights section

_lucifer: the same way they stored it. Lol

the svalbard seed bank (from which they inspired the arctic code vault) truly makes sense but the code vault doesn't

i checked their website they will provide a guide on how the data could be recovered so ok

but its more of a time capsule

PROJECT SILICA is even more ambitious

they are planning to store data in quartz crystals using lasers for 10000 years

Thats awesome

> they are planning to store data in quartz crystals using lasers for 10000 years

yeah, and whoever tries to read that will get some crypting "DLL not found" error.

Who's got a working minidisk player at home?

You mean CD player?

I always find long-term technological promises are highly optimistic

shivam-kapila: ahh, thanks. that's what I missed.

You're welcome :)

The only people that owned functioning mini disc players and readers were bad guys with nefarious plans on said discs in Sony movies.

No, I mean minidisk, but I guess that's my point :) Technology evolves too fast for us to remember formats from 20 years ago, so how the hell do they think we'll be able to read any technology in 10000 years?

right, Mr_Monkey

Those will be kept in museums.

it is merely for historical and cultural purposes

heck, who has a working zune subscription?

Like the cave engravings?

yeah

Well, those are direct and do not need any translation.

the spark build is failing, the int and unit tests are passing, but everything is marked as failing. wth?

ruaok: the snapshot tests are failing

not sure why though

Mr_Monkey: can you tell me what does this mean :p

which ones are the snapshot tests?

where can I look?

At the end of the log

I can't (although I did learn some when i was a kid), but Champolion found out how :D

It looks like I introduced the error in a prev PR

I will fix it

oh that is npm stuff?

Mr_Monkey: haha

yeah

ishaanshah: ah, thanks for taking this on. I've been working to fix the build all morning and it keeps getting worse. :) :)

ruaok: No worries at all :)

Even the spark build is failing

Ryzen but wait for 4000 series