Ask HN: What is the most impactful thing you've built?
I'll start. For me, I think the most impactful thing I've ever built was an internal application for a FX trading desk that eventually went on to handle billions in daily trades.
It didn't use any fancy frameworks, just plain old CRUD on Java.
758 comments
[ 4.5 ms ] story [ 564 ms ] threadMany would read "I should be worth more than..." as "I should have more money than...", but that's exactly what the parent comment is railing against. In the corporate world, and especially in the startup space, money is often the metric that defines worth. In the parent comment's world, I imagine they would rather that not be the case, and by <some other metric> they would be worth more than these startups/"money is god programmers" that are "only" worth money.
It could've been put a bit more nicely by not implying the reader is a 'money is god programmer,' but otherwise it's a valid opinion, I think.
The irony I understood from the comment is that the metric the commenter suggests should be considered more strongly is how one treats others, and they do so in the same breath as talking down on some group of people, which would probably take a few points off of their value as measured by that metric. The irony, in my mind, does not hinge on whether or not they'd be more valuable than the subjects of their missive but rather on the fact that their actions conflict with their value system.
If you'd please review https://news.ycombinator.com/newsguidelines.html and stick to the rules when posting here, we'd appreciate it.
I think it's telling that you frame your most impactful work in the context of how much better you are than other people, and how the world owes you something other people have because it's an unjust place, and the mindset probably does more harm to you than you'd realize. If you want to help people, do that, focus on that.
Also, as a new parent, my immediate thought is of course "WHO wasn't watching the kid??"
> Various degrees of hypothermia may be deliberately induced in medicine for purposes of treatment of brain injury, or lowering metabolism so that total brain ischemia can be tolerated for a short time. Deep hypothermic circulatory arrest is a medical technique in which the brain is cooled as low as 10 °C, which allows the heart to be stopped and blood pressure to be lowered to zero, for the treatment of aneurysms and other circulatory problems that do not tolerate arterial pressure or blood flow. The time limit for this technique, as also for accidental arrest in ice water (which internal temperatures may drop to as low as 15 °C), is about one hour.[84]
Also you can't just warm the body back to 38 degrees, it should be carefully brought up AFAIK.
AFAIK it was one of the top five biggest library systems in the world at the time.
I was asked to add some features that would have been too difficult in the old distributed system. Things like reading competitions, recommended reading lists by age, etc…
I watched the effect of these changes — which took me mere days of effort to implement — and the combined result was that students read about a million additional books they would not have otherwise.
I’ve had a far greater effect on the literacy of our state than any educator by orders of magnitude and hardly anyone in the department of education even knows my name!
This was the project that made realise how huge the effort-to-effect ratio that can be when computers are involved…
The part I added was built with ASP.NET 2.0 on top of Microsoft SQL Server 2005, and was eventually upgraded to 4.0 and 2008 respectively.
The only magic sauce was the use of SQLCLR to embed a few small snippets of C# code into the SQL Server database engine. This allowed the full-text indexing to be specialised for the high level data partitioning. Without this, searches would have taken up to ten seconds. With this custom search the p90 response time was about 15 milliseconds! I believe PostgreSQL is the only other popular database engine out there that allows this level of fine-tuned custom indexing.
I know you can tune the hell out of search performance, but that seems a bit too insane for what looks like a relatively unspecialized setup (Standard DB).
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 dramatic slowdowns randomly, and then the DB engine would often cache the inefficient query plan, making things slow until it got rebooted.
This is a very deep rabbit hole to go down. For example, many large cloud vendors have an Iron Rule that relational databases must never be used, because they're concerned precisely about this issue occurring, except at a vastly greater scale.
I could have used actual database partitioning, but I discovered it had undesirable side-effects for some cross-library queries. However, for typical queries this would have "enforced" the use of the partitioning key, side-stepping the problem the cloud vendors have.
Modern versions of SQL Server have all sorts of features to correct or avoid inefficient query plans. E.g.: Query Store can track the "good" and "bad" version of each plan for a query and then after sufficient samples start enforcing the good one. That would have been useful back in 2007 but wasn't available, so I spent about a month doing the same thing but by hand.
I love Steve Jobs' metaphor: computers as a bicycle of the mind [0]. Unfortunately, a lot of effort is concentrated on problems that scale to billions of people. There's a lack of attention to problems that would have a big effect for a relatively small number of people. It's a shame, because they're a blast to work on.
[0] https://www.youtube.com/watch?v=L40B08nWoMk
Nice work, but check your ego mate. Seems your growth hacking would have had zero result if those kids couldn't read to start with, so you could share some credit ;-)
https://news.ycombinator.com/newsguidelines.html
it's okay sir, we now know you as jiggawatts
Designed and deployed credit card readers used in gas pumps back in 1979. (Sold to Gasboy)
Wrote a fine tuner to allow communication between satellites (precursor to TDRSS days). Still used to this day.
Failover of IP in ATM switches (VVRP, PXE, secondary DHCP, secondary DNS, secondary LDAP, secondary NFS). While not invented here, it is still used today as this is a Common setup to this day.
Printer drivers for big, big high-speed Xerox printers on BSD. Still used to this day by big, big high-speed printers.
Also, early IDS products (pre-Snort) at line-speed. Sold to Netscreen.
Easy zero-setup of DSL modem before some BellCore decided to complicate things (thus exploding their field deployment budgets; Southwestern Bell/Qwest enjoyed our profitable zero-setup). Sold to Siemens.
1Gps IDS/IPS before selling it to 3Com/Hewlett-Packard Packard.
Now, I'm dabbling in a few startups (JavaScript HIDS, Silent Connections, replacing the systemd-temp).
Impact? It is more about personal pride but its impacts are still being felt today.
Have you made more than a typical SWE?
It is one of those traits where a mind clicks and said "this is it and how" and surprisingly gets into the most illusive hyperfocus/high-energy mode (without using any drug).
Slow-path network processing (arguably me) was commercially made in Ascom Timeplex in 1982 and someone else leaked it to Cisco (or ripping AT's patent off). I got that from observing how different river bends (re)connect year-after-year while doing trout fishing trips.
Money-wise, I am disabled, got abled, disabled again in different way, re-enabled, now just coasting with my own ideas: JavaScript Host-Based Intrusion Detection/Protection System, being one of them. And an portable AirPod detector (for home/auto/travel) is another idea. And DNSSEC for within private enterprise is almost done.
Money is not my thing but it does help greatly in the pursuit of my ideals (so many hardwares, so many test equips).
And a typical enterprise NIDS would not be able to see beyond those encrypted packet containing JS over 2-way-signed TLS/SSL, or HTTPv3 (QUIC) (or a few other E2E protocols).
Since JavaScript won't be banned (unlike Adobe Flash/ActionScript, BTW Adobe's JavaScript is still being used within PDF files) anytime soon, this is another example of seeing a void and rushing to fill its need for the betterment of Internet citizens.
Just yesterday, another "this is it and how" moment came to me: this Python PDF guy (and a few PDF experts) got me thinking "this is how to remove or make inert the JavaScript inside PDF": https://news.ycombinator.com/item?id=33646951
Care to develop more on the potential attacks here?
Most recently,
https://www.sciencedirect.com/science/article/abs/pii/S09505...
But which side should assume the responsibility of this JS-defanging effort into text-based? Client or server? Postal said "be liberal in what you receive and conservative in what you send". So, being conservative (in this respect), server has to be minimalistic (including denial of programmability).
Real problem remains, too much accessibility of programming is being made available to let client-side take it in ... in a gullible way.
And no amount of Sideshow Barker (not a dig on HN's Sideshow Barker) can fix this, until one of the MAANG decides "enough".
Meanwhile, the wild Wild West shall continue.
But, I "share" my money with those who provided me and others with things, like farmers, truckers, construction workers, plumbers, electricians, architects, textile workers, drafters, crafts-folks, artists, custodial, medical specialists, government workers, educational specialists, sanitation folks, engineers, engineers, engineers. Did I repeat that? Yes, more engineers.
I'm quite sure you do share your money too (and probably may not know the true extent of your reach).
Hack the Planet
We then worked on a baremetal automation system that worked through IPMI to completely automate the burn in process -remotely starting servers as soon as they got their IP registered, PXe booting them to the burn in image, and then kicking off the testing process. We had a way overkill rabbitmq system to collect streaming logs from every server as they ran, and all orchestrated via rethinkdb change feeds. I think it is still the most complex software project I have done. Basically one python file would launch 7 separate python processes, each their own rethinkdb change feed. This predated docker otherwise it probably would have been 7 docker containers haha.
Nothing hits you in the feels than having customers thanking you for improving their quality of life, or a child thanking you for giving a parent more years of life.
Is it - what is the thing I made that the most people use? A core service within AWS. Very insane scale.
Is it - what is the thing I made that I think will be the most intrinsically "beneficial" to society? Probably https://contractrates.fyi I've done a lot of freelancing myself and there really doesn't seem to be any single community or hub for freelancers that isn't trying to squeeze every last dollar out of them. I'm trying to make a thing that is legitimately helpful and completely free.
It's been a little over 5 years since I started, and I'm still super stoked about my work. I still enjoy doing the research, rewriting guides a dozen times, and answering reader mail. People seem really grateful for it, and it means a lot to me.
Don't forget your tax return too. If you didn't work the full year, you'll get money back.
https://videohubapp.com/ && https://github.com/whyboris/Video-Hub-App
What I did that is most impactful is that I've been giving at least 10% of my income to cost-effective charities for over 10 years now (see Giving What We Can - thousands of others do the same). This amounts to almost $100,000 given to charity which translates to thousands of people protected from malaria for many years of their lives.
[1] according to my personal benchmarking/use cases and anecdotal experience, no promises.
I’ve worked on minor stuff that was foundational to Google’s commercial offerings, but I think that isn’t as high impact and probably someone else would have done that as well or better. For the Wikipedia stuff, for good or ill, I owned some of those decisions.
It was what you'd call a community-run webhost, but at a time when such things weren't common. The main innovation was making it easy for multiple people to administer and hand over websites: we'd noticed that student society websites tended to get lost or rebuilt every year, because they were run under people's personal accounts which stopped working when they graduated.
Funniest part was, I open sourced it. Then a few years and an acquisition later the parent company tried to sell us a tool for converting caption files based off my own code.
https://github.com/jasonrojas/node-captions
Not trying to bait a copyleft vs permissive argument, I'm genuinely interested.
querySelectorAll wouldn't ever appear without jQuery which got its idea from Simon's idea.
And even then querySelectorAll was so poorly implemented that it didn't even have any useful helper methods.
Datasette, Django, and Lanyrd.
> Locating elements by their class name is a widespread technique popularized by Simon Willison (http://simon.incutio.com) in 2003 and originally written by Andrew Hayward (http://www.mooncalf.me.uk)
[0] Page 91 from "Pro JavaScript Techniques" by John Resig.
My most impactful thing I've done outside of paid work is a website running on Django. I could live without queryBySelector or their descendants, but not without Django.
Thank you, Simon.
Then thinking, I suppose you could do it by (exactly the method you used), but never actually doing it because if it were that simple, someone would have already done it.
Actually, seeing the date, I realize this predates me even leaving high-school, which makes it even more atrocious that I never knew of it!
(from https://static.simonwillison.net/static/2003/getElementsBySe...)