swid

7 ms·

31.
by swid 1y ago
There is no objectively correct way to do the merge, but there are ways that are obviously wrong.
32.
by swid 1y ago
Async/await themselves are not that much magic really, it's a bit of syntactic sugar over promise chains. Of course, understanding promises is its own bag. ChatGPT explanation: https://chatgpt.com/share/68c304
33.
by swid 1y ago
After thinking about it more, yes I agree with your take. Maybe it can even delete different ids using an =.
34.
by swid 1y ago
Most of what you say I agree with. But if this outer query is run only once with version A there is a caveat with where it says “where id = X”. This cannot match more than one X at a time. So that forces the inner query to be run once, as
35.
by swid 1y ago
The comment about = is mine and I thought about rewriting that part of the comment after the fact. It is soooo hard to explain these things without writing a book. The reason = mean it runs once is because the outer query will only run onc
36.
by swid 1y ago
I wrote this to a deleted comment, but even if the CTE was materialized, the subquery of the CTE would still not be... For instance, with the stand alone query: DELETE … WHERE id IN ( SELECT id … LIMIT 1 FOR UPDATE SKIP LOCKED )
37.
by swid 1y ago
It is allowed to be a planner choice though! Very surprising, but if you understand the docs, it will follow that it is not actually a bug. It could change in the future and has changed in the past apparently - but that change was to give
38.
by swid 1y ago
I think arguably there is no bug here, but the blog doesn't do a good job of explaining the issue and their fix may work because they remove the CTE and switch to `=`, but they prove they don't understand why the difference when t
39.
by swid 1y ago
I see what you saying, but it is very subtle, wouldn’t you agree? Under a different plan, the inner query would only be evaluated once, it is hard to mentally parse how it will first find the rows with the group id and then pass into the su
40.
by swid 1y ago
This is interesting - I don’t expect undefined behavior like this. Should the query delete more than one row or not? The blog post doesn’t really give answers - it isn’t obvious to me that the second query can’t be executed in the exact sa
41.
by swid 2y ago
The comment you are replying to is saying the chance of error decreases with more pilots since there is redundancy. They are not saying it’s like too many chefs in a kitchen.
42.
by swid 2y ago
At a household or personal level, phones just don’t use much energy. But then again, Apple does sell a lot of phones. I wouldn’t really be concerned though. Even if phones did use twice the energy as before, it would still be under a dolla
43.
by swid 2y ago
And this is exactly why you should not rely on AI without fundamental understanding. That would only be true if the payout odds are even. And in my comment I explicitly say not 1:1 payout. Go ahead and ask the AI for clarification, I’m sur
44.
by swid 2y ago
You state the case of no knowledge vs knowing 50/50 probability are equivalent, but they are clearly not. If you have no data but one side is actually heavily favored to win, you cannot determine how much you should bet on that probabi
45.
by swid 2y ago
Lets says I have a coin. I have no data on it. I do not know if it will come up heads or tails or if it is a fair coin. I throw the coin N number of times and determine the coin is fair. I still do not know which side the coin will come u
46.
by swid 2y ago
I worked on compilers at Fortify which does static code analysis, and it's always surprised me SSA does not come up more in context about how to write clean, maintainable, and secure code. SSA makes auditing code for dataflow issues mu
47.
by swid 2y ago
There is a fun post that explores this idea via an anime called Death Note. https://gwern.net/death-note-anonymity
48.
by swid 2y ago
Demonstrably, humans do think, and arguably demonstrably, early life would go down a path of simple predictions (in the form of stimulus -> response). And demonstrably, evolution did lead to human level intelligence. So I don’t think th
49.
by swid 2y ago
It seems to me predicting things in general is a pretty good way to bootstrap intelligence. If you are competing for resources, predicting how to avoid danger and catch food is about the most basic way to reinforce good behavior.
50.
by swid 2y ago
Weather patterns have a daily/ seasonal rhythm… the strength and direction of the wind will have some distribution that is different at different times of the day. Temperature and humidity as well, like the other poster said.
51.
by swid 2y ago
I’ve heard clips of hot water being poured vs cold water, and if you heard the examples, you would probably guess right too. Time of day seems almost easy. Are there animals noises? Those won’t sound the same all day. And traffic too. E
52.
by swid 2y ago
I like the definition proposed in the post - all possible mazes should be equally likely. A function could return the same maze each time and pass the criteria above.
53.
by swid 2y ago
My male friend once left the room with two girls I didn’t know very well; one of whom he was dating. We were all around 20 years old. In the ten minutes he was gone, they looked up his sign and his girlfriend decided they were not compatib
54.
by swid 2y ago
You make the bubble after you are already moving in the direction you want to go. The bubble will keep moving. What else would it do? Out of all the questions, this is not a hard one…
55.
by swid 2y ago
I saw the giraffe less than a year ago at Maker Faire, so they have kept it working.
56.
by swid 2y ago
If I am testing something I believe works and is ready, prior to testing, I will tell you it is almost ready. Then if we test it and it fails acceptance testing, I might learn there is a problem that takes some time to fix. I did not arrive
57.
by swid 2y ago
I could have sworn I have seen this in the past, but I am not sure exactly where. Thinking about it; it probably would have been part of OIDC and not directly addressed by OAuth... maybe someone can find it for me, or maybe I misspoke when
58.
by swid 2y ago
According to spec, when someone uses oauth to try and log into an existing account for the first time, you must require the user to login through their normal method and then prompt them to link the login account. However, the identity prov
59.
by swid 2y ago
Are you questioning if physics is computable? Even if it is not fully, we must be able to approximate it quite well. Suppose we scan more than just the person, but a local environment around them and simulated the whole box. The update tha
60.
by swid 2y ago
The LLM teaches itself the rules of the simulation by learning to predict what happens next so well. Presumable, running a human simulation by brute forcing physics at a scale large enough to represent a human is completely infeasible, but

More ›