Earlier quoted context omitted.
Can you elaborate a little bit more about how you partitioned it?
I simply added the "library id" as a prefix to almost every table's primary key. Every lookup specified it with an equality filter, so essentially it was thousands of standalone libraries in a single schema. One hiccup was that when the query cardinality estimator got confused, it would occasionally ignore the partition prefix and do a full scan somewhere, bloating the results by a factor of 2000x! This would cause d…
Ask HN: What is the most impactful thing you've built?
541–550 of 759 posts
Re: Ask HN: What is the most impactful thing you've built?
#542Re: Ask HN: What is the most impactful thing you've built?
#543God I am so inadequate
Re: Ask HN: What is the most impactful thing you've built?
#544Re: Ask HN: What is the most impactful thing you've built?
#545Earlier quoted context omitted.
I'll write it up.
If you do, let use know at hn@ycombinator.com and we'll put it in the second-chance pool ( https://news.ycombinator.com/pool , explained at https://news.ycombinator.com/item?id=26998308 ), so it will get a random placement on HN's front page.
Re: Ask HN: What is the most impactful thing you've built?
#546Earlier quoted context omitted.
I'm 25 and I'd totally take it on, but you're probably looking for an actual nonprofit if you want true survivability. As someone who has used this tool for at least 10+ years (as long as I've known what an IP address is), I'd love to help make sure it stays around.
Maybe it’s an option to found a nonprofit especially for this goal? If it doesn’t already exist anyway.
Re: Ask HN: What is the most impactful thing you've built?
#547Re: Ask HN: What is the most impactful thing you've built?
#548Let's Encrypt (along with the coauthors of https://abetterinternet.net/documents/letsencryptCCS2019.pdf and many other contributors). Now the world's largest public certificate authority!
Re: Ask HN: What is the most impactful thing you've built?
#549Re: Ask HN: What is the most impactful thing you've built?
#550First job out of college, I was at a consulting firm doing software development for DHS (Homeland Security). I got a lot of flack from my friends and family for "working for the devil", but the work was actually objectively good for society - basically there was a big data problem where when an immigrant trying to illegally cross into the US was apprehended, and if they were sick, their custody would be transferred f…