Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Sesse__
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
24 ms
·
421.
▲
by
Sesse__
1y ago
It was explained in the manual, if you didn't warez the game. :-) (I looked it up many years later, you can find the manual online these days.) But it's not that useful, since it only gives you latitude and only a rough idea at th
422.
▲
by
Sesse__
1y ago
I played a bunch of Civ 1, but the newer ones are just too complicated for me. Like, at some point I tried Civ V (with the expansion pack) and there's just so much _stuff_. World Congress? Civics? Great Missionaries? How am I supposed
423.
▲
by
Sesse__
1y ago
Many languages have exceptions, which are essentially COME FROM.
424.
▲
by
Sesse__
1y ago
It doesn't matter. URI is basically a format and nothing else. (foo://bar123 would be a URI but not a URL because nothing defines what foo: is.) URLs and URNs are thingies using the URI format; https://news.ycombin
425.
▲
by
Sesse__
1y ago
> Some famous programmer once wrote about how links should last forever. You're probably thinking of W3C's guidance: https://www.w3.org/Provider/Style/URI > But he was wrong, it should be /foo
426.
▲
by
Sesse__
1y ago
JPEG even has a special code from “the rest from here is all zeros, so we stop this block now”. The entire format is pretty much organized around trying to get as many zero coefficients as possible.
427.
▲
by
Sesse__
1y ago
You mean something like L*ab, right, not HSL? HSL is a pretty terrible approximation to human vision.
428.
▲
by
Sesse__
1y ago
If you exclude two-letter words, you are also excluding nearly all overlaps and parallel plays.
429.
▲
by
Sesse__
1y ago
The very good reason is that there's simply not a lot of heap allocations going on. It's easy to check; run perf against e.g. ffmpeg decoding a big file to /dev/null, and observe the distinct lack of malloc high up in th
430.
▲
by
Sesse__
1y ago
AFAICS, it wasn't “just perf”; it was doing a differential profile between the C and Rust versions, with manual matching up. (perf diff exists, but can't match across the differing symbol names, and few people seem to use it.)
431.
▲
by
Sesse__
1y ago
> If you don't know what the end of your array is, you've got bigger problems. That's called “a pointer”. Not all ways of representing arrays and spans come with explicit lengths. > These protests that "I can'
432.
▲
by
Sesse__
1y ago
> The correct answer to the common question of "how do you reverse an array" is that you don't reverse it. You read it backwards. This only works if you can easily find the end during iteration. Which you cannot in e.g. th
433.
▲
by
Sesse__
1y ago
_Fitting_ in the instruction cache isn't hard, but you'd also ideally let there be room for some other code as well :-) For a hash map lookup, where the hashing is frequently inlined a couple of times, code size matters.
434.
▲
by
Sesse__
1y ago
Am I right in that RAPIDHASH_UNROLLED is now mandatory and the function is thus much larger now?
435.
▲
by
Sesse__
1y ago
I know. But like I said, my German German teachers (all three of them, IIRC) used “Akkusativ Objekt”.
436.
▲
by
Sesse__
1y ago
Interestingly, several different ways of analysis are in use. I first learned German as a third language and then moved to a German-speaking country, and realized that the way German-speaking people think about their grammar is often differ
437.
▲
by
Sesse__
1y ago
Why do they feel the need to call NAT64 by some new weird “4via6” name?
438.
▲
by
Sesse__
1y ago
So you are not talking about attacking old code at all, but networking stacks that are indeed actively developed? That feels like a very different ball game from attacking Win98, even if the platform they are running on top of is old.
439.
▲
by
Sesse__
1y ago
Now I'm curious, how do you attack DOS? I mean, it comes without networking support, and if you have local access, you're already privileged.
440.
▲
by
Sesse__
1y ago
Any bug whatsoever involving NAT traversal?
441.
▲
by
Sesse__
1y ago
Not sure if you can call it “rarely”; it is very common in application programming. But it is never sent over the wire (unless there is some very buggy IP stack somewhere), which is probably why you did not encounter it in entry-level route
442.
▲
by
Sesse__
1y ago
And for a short while, it was the most common use of IPv6 on the public Internet! Now largely dead and gone.
443.
▲
by
Sesse__
1y ago
Indexes that point directly to the disk column are also significantly faster to access; it is a persistent pain point for OLAP on InnoDB that all secondary indexes are indirect. You can work around it by adding additional columns to the ind
444.
▲
by
Sesse__
1y ago
I don't know if AMD allows more or fewer _situations_, but empirically, I'm seeing a lot of total cycles lost to this on Zen 2 and 3, and much less on the Intel CPUs I've been testing (mostly Skylake derivatives and Alder Lak
445.
▲
by
Sesse__
1y ago
I find Clang generally a bit too eager to combine loads. This is especially bad when returning structs through the stack; you typically write them piecemeal in some function, return, and then the caller often wants to copy it from the stack
446.
▲
by
Sesse__
1y ago
IN is fine. The biggest problem comes with NOT IN, which has NULL semantics that makes life difficult for the planner. It is consistent but rarely what the user wants. NOT EXISTS is typically better there.
447.
▲
by
Sesse__
1y ago
The output of a query absolutely will depend on the plan. In ANSI SQL you're right it cannot (up to ordering), which is why ANSI SQL doesn't have anything like random() or nondeterministic user functions. But nearly all databases
448.
▲
by
Sesse__
1y ago
More to the point: The SQL standard doesn't talk about semijoins at all, it conceptually evaluates the WHERE clause for each and every row. So the question is whether the subquery is guaranteed to give the same result each and every ti
449.
▲
by
Sesse__
1y ago
How big are your headers and footers, really? If caching them is worth the extra complexity on the client plus all the pain of cache invalidation (and the two extra requests in the non-cached case).
450.
▲
by
Sesse__
1y ago
FWIW, VTune will definitely give you estimates of port allocation efficiency. (I believe you can also somehow squeeze it out of perf, but I've never really tried.)
More ›