Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Sesse__
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
10 ms
·
181.
▲
by
Sesse__
10mo ago
Sure, not all posts want to be the end-all of the topic. :-) And yes, the Joel post is a good introduction, if a bit old by now. Notably, of course, it doesn't say anything about _processing_ Unicode text. (E.g., don't sort by cod
182.
▲
by
Sesse__
10mo ago
In contrast, I found it rather lacking. No discussion of the most common way to sort floats as bytes (shift the sign bit down and XOR the other 31 bits with the resulting masks), nor NaNs and +/-0 for that matter. Varint sorting introd
183.
▲
by
Sesse__
10mo ago
> I grouped all Unicode 17 case-folding rules But why are you using the case-folding rules and not the collation rules?
184.
▲
by
Sesse__
10mo ago
Typically it is defined by the collation. For the default collation, where all the weights are as in the file, it's none/accent/accent+case. But if you go to e.g. Japanese, you can have a fourth level of “kana-sensitive” (whi
185.
▲
by
Sesse__
10mo ago
It's why the Unicode Collation Algorithm exists. If you look in allkeys.txt (the base UCA data, used if you don't have language-specific stuff in your comparisons) for the two code points in question, you'll find: 004B ;
186.
▲
by
Sesse__
10mo ago
There are other free ACME-based providers, so switching should be fairly painless if needed. (I guess if you've issued CAA records or similar, you may need some manual intervention.)
187.
▲
by
Sesse__
10mo ago
Before LE, we did lots of OV (which you generally could get a couple of for free from somewhere). We had to dig up stuff like a heating bill, because evidently that is proof of organizational control to some people.
188.
▲
by
Sesse__
10mo ago
I haven't looked into it, but most of these tend to do clever tricks with CSS animations. https://dev.to/janeori/expert-css-the-cpu-hack-4ddj is by the same author, IIRC, and explains some of it. CSS alone is not
189.
▲
by
Sesse__
10mo ago
https://propjockey.github.io/css-conways-game-of-life/infini... as an example. No user interaction except to start.
190.
▲
by
Sesse__
10mo ago
CSS is Turing complete :-) You can find pure-CSS implementations of Game of Life, for instance.
191.
▲
by
Sesse__
10mo ago
You can certainly write slow CSS, and people do :-) JavaScript typically takes up more of the CPU time overall, though.
192.
▲
by
Sesse__
10mo ago
In general, you split up the WHERE condition at every top-level AND. Then you do either pullup or pushdown or both (it depends a bit on how your planner looks on the inside). In the end, you end up with the two cases being exactly the same
193.
▲
by
Sesse__
10mo ago
Postgres used to have plan caching inside the same session, and that was so disastrous that it was limited severely by default. Plan caching is very much a two-edged sword; cache too aggressively, and the situation will be different between
194.
▲
by
Sesse__
10mo ago
> In the examples given, it’s much faster, but is that mostly due to the missing indexes? You're saying “the missing indexes” as if you could add indexes for every join you're ever doing and that this would be faster than a has
195.
▲
by
Sesse__
10mo ago
It's not that nobody thought of it. Group pushdown has been a thing in papers for ~10 years at least, but it's hard to plan; your search space (which was already large) explodes, and it's always hard to know exactly how many
196.
▲
by
Sesse__
10mo ago
Well, running in CTR mode is really common now, and that ends up XORing the generated keystream into the plaintext… (CTR mode is essentially converting block ciphers into stream ciphers, if you want to see it that way.)
197.
▲
by
Sesse__
11mo ago
> This proof assumes that the area a triangle is some function k c^2 of the hypotenuse c where k is constant for similar triangles. It is elementary to show that the area of a triangle is base * height / 2. (It follows from the fact
198.
▲
by
Sesse__
11mo ago
> A single core webserver serving static files isn't going to be much faster than 1 ms per file, so you're around 1k rps. And that's assuming you files are all cached. What “is” is this? Already in 2005, I was serving imag
199.
▲
by
Sesse__
11mo ago
At the time when the Slashdot effect was at its peak, the limiting factors were probably RAM or bandwidth (third-party services was not as much a thing, and CPUs were generally able to push 10 Mbit/sec without much of a problem -- but
200.
▲
by
Sesse__
11mo ago
The blur happens on the GPU. HEVC encode also happens on the GPU (or at least a GPU-adjacent device; it's rarely a full-shader affair). If you were to use HEVC software encode with GPU blur, you'd need to send the camera data to t
201.
▲
by
Sesse__
11mo ago
Let's call it GDPR. :-)
202.
▲
by
Sesse__
11mo ago
I loaded it and got an LCP of ~350 ms, which is better than the ~550 ms I got from this very comment page.
203.
▲
by
Sesse__
11mo ago
You can do with a static dither pattern (I've done it, and it works well). It's a bit of a trade-off between banding and noise, but at least static stuff stays static and thus easily compressable.
204.
▲
by
Sesse__
11mo ago
This is my experience as well. Not a gamechanger, but definitely on the positive side.
205.
▲
by
Sesse__
11mo ago
It seems the DNS servers for lukefleed.xyz are subtly misconfigured, causing occasional connectivity problems: https://dns.squish.net/traverses/de494a9fe3310415f30369a9cb1... Or more precisely, lukefreed.xyz has NS rec
206.
▲
by
Sesse__
11mo ago
The article specifically points out that this isn't about optimization. A temporary will not be created even with -O0 (you can observe this by putting logging into the copy and move constructors).
207.
▲
by
Sesse__
11mo ago
Thanks! So you will indeed get a small amount of data, but nearly nothing tied to a specific user profile.
208.
▲
by
Sesse__
1y ago
It indeed isn't, but I've seen my share of systems where nobody checked if cargo arrived. (The code was checked in without any benchmarks done, and after many years, it was found that the macros used were effectively no-ops :-) )
209.
▲
by
Sesse__
1y ago
This makes attempts of cargo-culting __attribute__((aligned(64))) without benchmarking even more hilarious. :-)
210.
▲
by
Sesse__
1y ago
What data _is_ there to extract BFU, really, if you can't break the secure element? I mean, the main storage isn't decrypted yet, right?
More ›