ec changed the topic of #elliottcable to: a π―ππ ππ π―πππππππππ π―ππππππ slash sΝΜuΝΝpΝΝeΜΜΊrΜΌΜ¦iΜΌΜoΜΜ¬rΜΜ cΜΝα»₯Μ§ΝαΈ·Μ‘ΝΕ£ΝΜ || #ELLIOTTCABLE is not about ELLIOTTCABLE
Sgeo has joined #elliottcable
<pikajude>
siiiigggghhhhhhhhhhhhhhh
<pikajude>
before i picked up this project, someone had an intern move storage backends and now it's trying to use a k/v store as a relational database
<ljharb>
you can fix that by making it actually be an rdb
<ljharb>
which kv store?
<jfhbrook>
ljharb I woke up to 20+ notifications from that thread lmao
<jfhbrook>
for my own experiences nvm seems to add a low but potentially noticeable overhead to shell starts but nothing compared to conda holy crap
<jfhbrook>
that said, an almost nvm compatible version manager in reason? this sounds lulzy
<jfhbrook>
I bought a new laptop and I'm installing arch on it, which seems like a good opportunity to experiment on ridiculous shit
<jfhbrook>
also: that legit sucks that these clowns are confusing nvm and nodenv (???)
<pikajude>
actually no idea ljharb
<pikajude>
it's got a snappy fb-internal name
<pikajude>
i think it's based on uhhh
<pikajude>
hell it might even be developed in-house
<pikajude>
anyway it's perfectly functional but i checked the code just now and in order to query all datapoints for a user in a date range we list out all the dates that exist in that range, look up every key for those dates and check whether the value has the correct user ID
<pikajude>
which is a little traumatizing
<jfhbrook>
impressive
<jfhbrook>
do you at least fetch them all at the same time?
<pikajude>
yeah, the keys are all like u:1325463 s:baogeudriegaedauogu
<pikajude>
yeah there's a multiget operation
<pikajude>
but some users have thousands and thousands of datapoints either because they're test users used for automated jobs or because they do a lot of debugging work
<pikajude>
so it's quite slow
<pikajude>
also i'm not actually sure if the intern used multiget
<jfhbrook>
stiny! get me a danish! stiny! who converted this datastore to nosql??
<pikajude>
gotta give the interns something to do i suppose
<pikajude>
to be completely fair to them i went through a phase where i found out about nosql and tried to shoehorn it into whatever new project i built
<jfhbrook>
yeah my early career was mostly nosql
<pikajude>
although to again to be fair to myself, i was like 16 at the time
<pikajude>
i think?
<pikajude>
initial release of mongo was 2009, so i was probably 15
<jfhbrook>
I mean how old are you
<pikajude>
(2019 - 2009) + 15
<pikajude>
well, + 14 since i've not had my birthday yet
<jfhbrook>
huh
<pikajude>
guys i'm almost mid-20s
<pikajude>
yikes
<jfhbrook>
I was your age when mongo came out
<pikajude>
oh ok
<jfhbrook>
I graduated from college in 2011 w/ a masters so
<pikajude>
well, age is no guarantee of knowing not to use nosql for rdb usecases
<jfhbrook>
google says 22
<pikajude>
it does?
<pikajude>
for 2019 - 2009 + 14?
<jfhbrook>
no I mean I asked it 2009 - 1987
<pikajude>
oh ok
<jfhbrook>
which is my birth year
<pikajude>
neat
<pikajude>
kids of the 80s, enjoy
<pikajude>
i was born in 94
<jfhbrook>
cripes
<pikajude>
i'll be 25 this year, existential horror is setting in
<pikajude>
thought i'd have a mortgage and a wife by now
<jfhbrook>
you're about my sister's age
<jfhbrook>
ehhh I mean
<jfhbrook>
I'm 31 and have neither of those
<jfhbrook>
but I also only had vague notions of those things at best
<pikajude>
oh sure
<pikajude>
and i probably won't have them either by 31
<pikajude>
i expected there to be a point where i'd be like "oh ok, now i'm a grownup"
<pikajude>
no such luck
<jfhbrook>
there's this comic I used to read
<jfhbrook>
that has a bunch of stuff about that
<jfhbrook>
you don't really hit a transition zone, you just end up one day realizing that you're doing adult-y things
<pikajude>
yeah
<pikajude>
well i'm already doing that
<pikajude>
i own stocks and my name is on an apartment lease agreement
<jfhbrook>
right that's what I mean
<pikajude>
also my apartment is full of lego sets and stuffed animals
<pikajude>
keep the dream alive
<jfhbrook>
hah
<ljharb>
jfhbrook: yeah lulz
<pikajude>
i'm net -500 lines of code on the day
<pikajude>
feels good man
<jfhbrook>
nice
<jfhbrook>
2/4 of my big PRs are merged
<pikajude>
wooo
<pikajude>
so on top of our intern using a kv store for an rdb usecase, the information that was stored was *already* being stored in our logger tables
<pikajude>
so i just changed it to query those instead and deleted all the stuff that interacts with ZippyDB