jack_squat

7 ms·

1.
by jack_squat 2y ago
Like most online forums, HN discussions are dominated by people who like to spend all their time online arguing with people. It's the 80:20 principle, or the 90-9-1 principle. Largely these are early-20s, politically ignorant men, with
2.
by jack_squat 3y ago
My prediction is it'll be Cruise in red states and Waymo in blue states. I think they are done in SF but this will endear them in TX.
3.
by jack_squat 3y ago
I've done the Postgres skip locked thing at least three times and I'm currently doing it, but IMO it is actually more maintenance and overhead, not less -- at least when compared with the queues made available by the major cloud p
4.
by jack_squat 3y ago
Typically you try and avoid closing a connection on each request, you hand it back to a connection pool. The underlying session stays open and associated with the connection (if you have your pooler set up right), so subsequent requests sti
5.
by jack_squat 3y ago
The author's site is primarily poorly-researched and hyperbolic BS, mostly to provide cover for his political hot takes. Example: https://scottlocklin.wordpress.com/2021/11/20/us-public-heal...
6.
by jack_squat 3y ago
No piece of software has influenced my career and my thinking on design, user interfaces, and software quality as much as VIM. VIM made learning to code as fun as playing a game. Thank you Bram, you changed my life.
7.
by jack_squat 3y ago
When you use a surrogate key, you should still put a unique constraint on an alternate key. Multiple records for the same thing is a fundamental problem in a database.
8.
by jack_squat 3y ago
I also tend toward surrogate keys, and would also point out that the overhead concerns frequently weigh in favor of them as well (though not always). If your natural key is bigger than the appropriately sized surrogate key, and it will be r
9.
by jack_squat 3y ago
Atomicity doesn't mean "doesn't fail", it means "either fails or succeeds, but does not succeed halfway". There is nothing about what you are describing that is different from the behavior you'd get from a
10.
by jack_squat 3y ago
1NF bans relation-valued attributes, not repetition of attribute value across tuples in a relation. Mainstream SQL databases don't support relation-valued attributes, so any table you make in a relational database is 1NF. You can push
11.
by jack_squat 3y ago
From the Postgres docs, ON CONFLICT DO UPDATE guarantees an atomic INSERT or UPDATE outcome; provided there is no independent error, one of those two outcomes is guaranteed, even under high concurrency. This is also known as UPSERT — “UPDAT
12.
by jack_squat 3y ago
Am I alone in feeling there is nothing left to be said on this topic? Correct application design, and balancing that against the constraints of getting a product out the door, the requirements of a particular application, and the resources
13.
by jack_squat 3y ago
FTS is not the same as regex.
14.
by jack_squat 3y ago
RI has the same approximate population as AK. What people mean when they say land votes, is AK compared to NY. AK has a population of < 1M while NY has a population of > 8 million. Proportionally, Alaskans have > 8x the representat
15.
by jack_squat 4y ago
what the comment describes is actually a central point of the "Easy Way" book mentioned many other places in this thread.
16.
by jack_squat 4y ago
If something is "likely", I would assume it's more likely than not.
17.
by jack_squat 4y ago
Regarding trains anyway, a) there have been autonomous trains for decades and the numbers are increasing. b) there are 100x as many professional drivers as train conductors in the US - so it's easy to see why the focus on driving. That
18.
by jack_squat 4y ago
IMO if a solution requires users to address data by page, it's a sign that the search functionality is not good enough. In general a user doesn't want to find "page 3", they are looking for a record that has certain char
19.
by jack_squat 4y ago
I would suggest quitting coffee if you are curious about that. Do it on a Thursday and you will probably be fine by Monday. Try it for a couple weeks and evaluate, most likely your productivity will be unaffected. Your boss won't notic
20.
by jack_squat 4y ago
Do you think that's how it works? I have no idea, what's your evidence? California's actions seems pretty consistent with this to me: https://storage.courtlistener.com/recap/gov.uscourts.cand.31...
21.
by jack_squat 5y ago
Proxy war means no boots on the ground. The two of you agree.
22.
by jack_squat 5y ago
In my opinion "infinitesimal" is too small. I think at this point a nuke strike is a bigger risk than covid, for most.
23.
by jack_squat 5y ago
This is the R resource I recommend: https://www.amazon.com/Using-Introductory-Statistics-Chapman... Takes a weekend to work through the book and you get a statistics refresher as a bonus.
24.
by jack_squat 5y ago
The responses in this thread were unusually crazy/crass/rude before moderation apparently stepped in. I dunno if that was a glimpse of "unmoderated HN" or if this topic in particular draws out emotions.
25.
by jack_squat 5y ago
My understanding is cardiac deaths early in life are mostly caused by congenital issues that are more likely to shake out under stress, and those late in life are dominated by issues acquired via lifestyle. Among people under 35 (most athle
26.
by jack_squat 5y ago
Doesn't that all make sense? I'm not sure what the issue is here. The statistic that vaccinated people 18-59 are dying at twice the rate presumably true, so of course the reuters article doesn't deny it. The Reuters article p