zeroimpl

6 ms·

211.
by zeroimpl 5y ago
Anybody know if there any performance/query plan differences between the following? WHERE details->'attributes'->>'color' = 'neon yellow' And WHERE details['attributes'][&
212.
by zeroimpl 5y ago
Hash tables perform poorly when they need to be resized periodically as the table grows (as everything needs to get rehashed). Using a tree structure instead ensures consistent performance.
213.
by zeroimpl 5y ago
Definitely agree here. I’ve never associated a physical ruler with the verb rule.
214.
by zeroimpl 5y ago
You could also do that even better with plain <img> tags, so that's not really a special attack vector.
215.
by zeroimpl 5y ago
The other door is not irrelevant. When you first picked a door, there was a 33% chance it was right, and a 67% chance one of the other two doors was right. Once the other door got opened, it is still a 67% chance that the other two doors is
216.
by zeroimpl 5y ago
There’s an important difference between Turing machines and computers: unlimited memory. For a computer with limited memory, of course you can determine whether a program halts, because if it doesn’t halt then eventually the state machine m
217.
by zeroimpl 5y ago
I’m similar - rarely drink and dislike most alcoholic drinks - except that I have found certain flavors I like. Usually it’s sweetened wines, or cider. Also it’s often about pairing - the acidity or tartness sometimes just hits the spot. Go
218.
by zeroimpl 5y ago
So what do they do for men? Is there something other than "Mr" which is routinely used to identify male children?
219.
by zeroimpl 5y ago
Fun fact - if you don’t like Java erasing types by default, you can just pass them along manually yourself. There’s a bunch of ways to do this, but I’ll just leave this one trick here. Instead of: List<Integer> x = new ArrayList
220.
by zeroimpl 5y ago
I’d just solve this by passing in a Class<S extends Iterable<R>> arg and making the returned list be an instance of this class, instead of forcing the input collection type to be the same as the output collection type.
221.
by zeroimpl 5y ago
The note that savepoints in postgresql don’t perform well is news to me. They are used extensively in different applications. Even in plpgsql, any time you catch an exception, it’s using savepoints under the hood. Perhaps there is room for
222.
by zeroimpl 5y ago
I suspect query #2 would have performed better if they used a COALESCE instead of an OR condition. One of the most important optimization lessons you can learn is not to use OR for any join conditions. Eg instead of this: ON (customer
223.
by zeroimpl 5y ago
Umm.. virtually no join on tables with more than a handful of rows is done as a cartesian product. A suitable set of columns is used to sort or hash each side of the join, such that the actual join logic is basically linear performance (eac
224.
by zeroimpl 6y ago
On the other hand, now that the name change is done, if there are more protests then nobody will waste time talking about whether Github should change the branch name. This time, people were talking about it even before Github did anything,
225.
by zeroimpl 6y ago
The irony here is two much
226.
by zeroimpl 6y ago
> For a good number of years, I've been (foolishly, as it turns out) using the included Apache httpd to run small localhost-only stuff on my Mac laptop. In recent times, I found that every upgrade of the OS would revert my httpd.co
227.
by zeroimpl 6y ago
Shouldn’t the title of the submission match the title of the article? Anatomically correct suggests something very different.
228.
by zeroimpl 6y ago
This answer is right. The original question isn't asking anything about parsing, they are trying to search for specific tags, which is a great use for a regex. Yes, it will probably return some invalid matches unless you go out of your
229.
by zeroimpl 6y ago
The ad company isn't going to trust any data which is routed through the backend of your web server. Otherwise spoofing page views/clicks is trivial. The next step is to get a CDN to proxy both www.example.com and tracker.example.
230.
by zeroimpl 6y ago
I’m sure they could make stringify work, since numbers in JSON can be arbitrarily large. But parsing JSON and having it return BigInt instead of Number just isn’t going to be able to work by default. I guess because of this, making stringif
231.
by zeroimpl 6y ago
The seller of the app knows practically nothing about the buyer, basically just the IP address when they launch the app, and other vague details.
232.
by zeroimpl 6y ago
That was option #3: Store this object in a table and load it in the function. Storing it in a Table and accessing the elements by selecting from the Table. This can be a heavy overhead. While I can’t don’t know for sure ho
233.
by zeroimpl 6y ago
Perhaps the purpose is to list colors in a specific order, such as to show to the user in a desired order? And before you argue that dictionaries can still be iterated in order, you better check the sibling threads where people are arguing
234.
by zeroimpl 6y ago
It is a minefield, but we all walk it all the time. A new mime type doesn’t really help because the parser doesn’t check the mime type, it assumes the programmer did that. I’m not against making a new mime type or specification, but there a
235.
by zeroimpl 6y ago
Rather than keep making new variants of JSON, it'd be nice if somebody could convince some mainstream language maintainers to just update their built-in JSON parser to add optional features like skipping over comments and not caring ab
236.
by zeroimpl 6y ago
If the only metrics you are comparing is price and purification level, then of course you won't want a Dyson. But there are other important objective metrics such as size and loudness which deserve to be a part of any scientific comp
237.
by zeroimpl 6y ago
Whenever I see “go home and bite [his] pillow”, I’ve always assumed the person spoke quickly and/or skipped a word, which the editor thought should be added. It never occurred to me before now that the editor actually replaced a word!
238.
by zeroimpl 6y ago
They support index-only scans now, so there is some sort of optimization which bypasses the table lookup, at least in certain cases.
239.
by zeroimpl 6y ago
The 8-bit vs 10-bit aspect is entirely unrelated to the HDR vs SDR aspect. 10-bit is just added precision in your numbers, and ought to be interpreted as adding more decimal places (makes more sense when you imagine the values going from 0-
240.
by zeroimpl 6y ago
I loved reading, but hated every book I had to read in high school. Just couldn't relate to them. Only later did I realize most of them were pretty good and meaningful.

More ›