[flagged]
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…
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.
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…
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…
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...
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.
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.
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…
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 regular…
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…
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…
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…
FTS is not the same as regex.
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…
what the comment describes is actually a central point of the "Easy Way" book mentioned many other places in this thread.
If something is "likely", I would assume it's more likely than not.
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…
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…
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…
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...
Proxy war means no boots on the ground. The two of you agree.
In my opinion "infinitesimal" is too small. I think at this point a nuke strike is a bigger risk than covid, for most.
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.
[flagged]
[flagged]
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…
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.
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…
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…
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...
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.
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.
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…
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 regular…
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…
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…
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…
FTS is not the same as regex.
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…
what the comment describes is actually a central point of the "Easy Way" book mentioned many other places in this thread.
If something is "likely", I would assume it's more likely than not.
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…
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…
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…
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...
Proxy war means no boots on the ground. The two of you agree.
In my opinion "infinitesimal" is too small. I think at this point a nuke strike is a bigger risk than covid, for most.
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.