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.
2020-07-20 20215, 2020
ballenby joined the channel
2020-07-20 20237, 2020
ballenby has quit
2020-07-20 20217, 2020
ballenby joined the channel
2020-07-20 20232, 2020
MFCR_ColbyRay has quit
2020-07-20 20210, 2020
antlarr has quit
2020-07-20 20231, 2020
sumedh joined the channel
2020-07-20 20236, 2020
ballenby has quit
2020-07-20 20254, 2020
ballenby joined the channel
2020-07-20 20214, 2020
v6lur_ joined the channel
2020-07-20 20245, 2020
sumedh has quit
2020-07-20 20211, 2020
v6lur has quit
2020-07-20 20253, 2020
sumedh joined the channel
2020-07-20 20219, 2020
ishaanshah
Morning!
2020-07-20 20223, 2020
ishaanshah
iliekcomputers: ping
2020-07-20 20247, 2020
antlarr joined the channel
2020-07-20 20257, 2020
eharris has left the channel
2020-07-20 20248, 2020
shivam-kapila
Good Morning!
2020-07-20 20254, 2020
zas
legoktm: yes, but it would be perhaps safer to build a new VM from scratch, and migrate
2020-07-20 20254, 2020
legoktm
that works too :)
2020-07-20 20203, 2020
legoktm
IIRC that's what we did last time
2020-07-20 20254, 2020
iliekcomputers
ishaanshah: pong
2020-07-20 20230, 2020
diru1100
Morning!!
2020-07-20 20223, 2020
jmp_music joined the channel
2020-07-20 20229, 2020
jmp_music
morning!
2020-07-20 20209, 2020
MajorLurker_ has quit
2020-07-20 20237, 2020
ruaok
mooooin!
2020-07-20 20204, 2020
v6lur_ has quit
2020-07-20 20258, 2020
ishaanshah
iliekcomputers: Hi, I think I found a way to make the daily activity query faster
I found this online service which provide a notebook like environment for spark
2020-07-20 20209, 2020
ishaanshah
It's pretty cool, we can even get the plots directly inline
2020-07-20 20206, 2020
ishaanshah
Also I am talking about the query plan for `result_without_zero_hours.explain()`
2020-07-20 20258, 2020
ishaanshah
the second step is not necessary, it's just filling in the hours which have 0 listens
2020-07-20 20214, 2020
ballenby has quit
2020-07-20 20252, 2020
v6lur joined the channel
2020-07-20 20258, 2020
iliekcomputers
Truncate the listened_at to get the hour and then an equality check. Hmm. The explain seems reasonable.
2020-07-20 20237, 2020
djwhitey has quit
2020-07-20 20204, 2020
v6lur has quit
2020-07-20 20206, 2020
v6lur joined the channel
2020-07-20 20255, 2020
MajorLurker joined the channel
2020-07-20 20236, 2020
MajorLurker has quit
2020-07-20 20255, 2020
ballenby joined the channel
2020-07-20 20238, 2020
sumedh has quit
2020-07-20 20233, 2020
ballenby has quit
2020-07-20 20207, 2020
ballenby joined the channel
2020-07-20 20235, 2020
SothoTalKer has quit
2020-07-20 20217, 2020
SothoTalKer joined the channel
2020-07-20 20254, 2020
ishaanshah
Cool, I will productionise it then
2020-07-20 20238, 2020
reosarevok
Wow. Never even knew "productionise" was a word, but it is :D
2020-07-20 20201, 2020
Gazooo has quit
2020-07-20 20211, 2020
Gazooo joined the channel
2020-07-20 20248, 2020
shivam-kapila
ishaanshah: you will soon be able to run pyspark in jupyter notebooks
2020-07-20 20225, 2020
shivam-kapila
Not exactly jupyter notebook but a similar environment based on it
2020-07-20 20219, 2020
ruaok
wow, the linked in UI is freaking terrible. it keeps getting worse and worse.
2020-07-20 20227, 2020
ruaok should close his account
2020-07-20 20205, 2020
shivam-kapila
Its confusing
2020-07-20 20243, 2020
Darkloke joined the channel
2020-07-20 20244, 2020
shivam-kapila
The mobile app always shows old posts :/
2020-07-20 20230, 2020
reosarevok
Is there an actual point to LinkedIn? I always assumed it was a place for career people to show off
2020-07-20 20230, 2020
reosarevok
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? :)
2020-07-20 20231, 2020
BrainzBot
MBS-10967: Add Kosovo to the list of release countries
2020-07-20 20245, 2020
iliekcomputers
reosarevok: yeah, that and recruiters
2020-07-20 20259, 2020
reosarevok
(it only recently got marked as a country at all in MB due to that same issue)
2020-07-20 20208, 2020
ruaok
reosarevok: I'm ok with that.
2020-07-20 20214, 2020
ruaok is always in favor of small countries
2020-07-20 20243, 2020
ruaok
wow, the latest merge of master into timescale-final had zero merge conflicts.
2020-07-20 20247, 2020
reosarevok
Ok, thanks!
2020-07-20 20206, 2020
shivam-kapila
reosarevok: LinkedIn sometimes helps connecting with good people and those good people share good resources. Might help in getting referrals too
2020-07-20 20212, 2020
reosarevok
Is referral that thing where someone tells "they are a good worker and stuff" when you apply for some other company?
2020-07-20 20221, 2020
reosarevok knows so little about how the real capitalist world operates :p
2020-07-20 20213, 2020
shivam-kapila
Yes its quite the same
2020-07-20 20234, 2020
shivam-kapila
But I totally agree people show off a lot on it
2020-07-20 20242, 2020
shivam-kapila
People were showing off Arctic Code Vault Contributor batch. I guess almost everyone got it. Whats the point in show off
2020-07-20 20226, 2020
ruaok
unless I missed a notifcation, I wasn't included on the code vault... I guess I dont have enough code up there. :)
2020-07-20 20243, 2020
MajorLurker joined the channel
2020-07-20 20251, 2020
reosarevok
I never even heard of the vault thing :D
2020-07-20 20233, 2020
_lucifer
i do not understand the point of code vault
2020-07-20 20249, 2020
_lucifer
it mostly seems to be for pr purposes
2020-07-20 20256, 2020
shivam-kapila
ruaok: I guess everyone who contributed befor feb 2020 got it
2020-07-20 20204, 2020
shivam-kapila
_lucifer: No
2020-07-20 20201, 2020
shivam-kapila
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
2020-07-20 20251, 2020
_lucifer
yeah i understand that but how would that work out
the svalbard seed bank (from which they inspired the arctic code vault) truly makes sense but the code vault doesn't
2020-07-20 20233, 2020
_lucifer
fair point shivam-kapila
2020-07-20 20236, 2020
djwhitey joined the channel
2020-07-20 20258, 2020
_lucifer
i checked their website they will provide a guide on how the data could be recovered so ok
2020-07-20 20211, 2020
_lucifer
but its more of a time capsule
2020-07-20 20201, 2020
_lucifer
PROJECT SILICA is even more ambitious
2020-07-20 20228, 2020
_lucifer
they are planning to store data in quartz crystals using lasers for 10000 years
2020-07-20 20248, 2020
shivam-kapila
Thats awesome
2020-07-20 20227, 2020
ruaok
> they are planning to store data in quartz crystals using lasers for 10000 years
2020-07-20 20242, 2020
ruaok
yeah, and whoever tries to read that will get some crypting "DLL not found" error.
2020-07-20 20249, 2020
Mr_Monkey
Who's got a working minidisk player at home?
2020-07-20 20220, 2020
shivam-kapila
You mean CD player?
2020-07-20 20221, 2020
Mr_Monkey
I always find long-term technological promises are highly optimistic
2020-07-20 20223, 2020
ruaok
shivam-kapila: ahh, thanks. that's what I missed.
2020-07-20 20243, 2020
shivam-kapila
You're welcome :)
2020-07-20 20203, 2020
ballenby
The only people that owned functioning mini disc players and readers were bad guys with nefarious plans on said discs in Sony movies.
2020-07-20 20216, 2020
Mr_Monkey
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?
2020-07-20 20213, 2020
_lucifer
right, Mr_Monkey
2020-07-20 20232, 2020
shivam-kapila
Those will be kept in museums.
2020-07-20 20239, 2020
_lucifer
it is merely for historical and cultural purposes
2020-07-20 20251, 2020
ruaok
heck, who has a working zune subscription?
2020-07-20 20252, 2020
shivam-kapila
Like the cave engravings?
2020-07-20 20201, 2020
_lucifer
yeah
2020-07-20 20207, 2020
Mr_Monkey
Well, those are direct and do not need any translation.