Sesse__

51 ms·

841.
by Sesse__ 3y ago
Here's MySQL's all-session-globals-in-one-place-class: https://github.com/mysql/mysql-server/blob/8.0/sql/sql_class... I believe I can safely say that nobody acknowledges and understands t
842.
by Sesse__ 3y ago
glibc and OpenSSL both have runtime detection of CPU features to switch between hand-coded versions of hot functions, so those two are probably the packages that will get the _least_ benefit from a recompilation.
843.
by Sesse__ 3y ago
The VSHRN trick is nice (I used it only two hours ago!), but it really does feel like a crutch; I don't understand why they couldn't simply implement a PMOVMSKB-like instruction to begin with (it cannot possibly be very expensive
844.
by Sesse__ 3y ago
mediamtx has 50 dependencies...
845.
by Sesse__ 3y ago
The paint phase of rendering can easily happen on the GPU, and more and more stuff will move to the GPU as time goes by. The style and layout phases… unlikely. Think of a GPU this way: If you could reasonably launch a thousand threads on th
846.
by Sesse__ 3y ago
I haven't been part of a small team building either, but the obvious small team doing RDBMSes is SQLite. Three people building the world's most popular software, and possibly the world's most robust database. They found a nic
847.
by Sesse__ 3y ago
> I’d rather be on the hook for a modern RDBMS than a modern browser. I've worked on both a RDBMS and a browser, and yes, I'm inclined to agree. In particular, it is largely acceptable for an RDBMS to pick a niche where you per
848.
by Sesse__ 3y ago
MAME/MESS has different goals; in particular, it strives for accuracy first and foremost. Hacks that reduce accuracy but improve playability and/or performance are generally not accepted by MAME, AFAIK, whereas something like Dolp
849.
by Sesse__ 3y ago
> I wonder how this will affect quirks such as A20 A20 was removed in Haswell (released pretty much exactly ten years ago).
850.
by Sesse__ 3y ago
That's a good use case for… a quite regular pipe? :-)
851.
by Sesse__ 3y ago
mmap should generally be avoided, not just for databases. It's useful for quick prototyping and for the specific case of demand-paging executables (which is really what it's made for!), but there are so many pitfalls overall. You
852.
by Sesse__ 3y ago
I don't think Carlsen demanded changing the cycle, so indeed. (Well, he voiced opinions ten years ago, but this time around, there were no negotiations AFAIK. Just him plain stating he wasn't likely to show up.) a.s.n is my site,
853.
by Sesse__ 3y ago
Carlsen was pretty clear on this all along. He said there was a _slight_ chance of him changing his mind if Firouzja won the Candidates, which he was nowhere near doing. The announcement after the Candidates was just the final confirmation.
854.
by Sesse__ 4y ago
“Superfast”, until you blow through your L1 cache, which happens pretty early on if you need 1 kB of table per byte in your key. Even in the L1 cache, it's hard to beat the mul: A multiplication (which can hash multiple bytes in the ca
855.
by Sesse__ 4y ago
> IMO, cmov was far more valuable back when it was new, because branches were more expensive then. Branches in general are cheaper now (since they are generally predicted better), but mispredicted branches are more expensive. They are si
856.
by Sesse__ 4y ago
Amdahl’s law is specifically about the futility of optimizing by removing hotspots... (Or rather, that it can only take you so far.)
857.
by Sesse__ 4y ago
Yes, it means you need a reboot at the very least, and initramfs integration.
858.
by Sesse__ 4y ago
Seemingly you cannot convert live to LUKS2; you'll need to unmount first. So that's a bit sad, and would probably make distro conversion a more complex. But I think maybe you can increase the number of PBKDF2 iterations? I heard a
859.
by Sesse__ 4y ago
If you give the empty_moov parameter, the MP4 mux can write to a pipe (or a network stream).
860.
by Sesse__ 4y ago
I've found the opposite to be true; the FFmpeg C API is pretty straightforward, although it tends to change a bit since the developers are deprecation-happy. The ffmpeg(1) CLI, though… that's crazy! I've mostly understood its
861.
by Sesse__ 4y ago
> Why people keep investing themselves into Goyal's one-man-fiefdom projects is a mystery to me. You gain some, you lose some. Kitty is really low-latency and renders most Unicode shenanigans correctly (the main exception being RTL
862.
by Sesse__ 4y ago
When trying to blend two different colors, for instance when you have antialiased white text on black background (or for that matter, fuchsia text on an image), there's a question on how you do the blending mathematically. The “obvious
863.
by Sesse__ 4y ago
> Sorry, I don't follow? SQLite also has durability problems on power loss. No, it doesn't. Once COMMIT returns, your data is durable. > You can use exactly the same method that SQLite uses to flush data to disk. Good luck w
864.
by Sesse__ 4y ago
What you are saying is generally correct, but: If you sample a 1 Hz sine at 2 Hz, you wouldn't get readings of 0, 1, 0, -1, etc.; you would get readings of 1, -1, 1, -1, etc., or if you're very unlucky, 0, 0, 0, 0, …! The _exact_
865.
by Sesse__ 4y ago
Polyphase filtering is less crazy than it initially sounds. Conceptually, you can think of it as: I have this signal in frequency f. I want to resample it to frequency (b/a)*f, where a and b are integers. (You can also do polyphase fil
866.
by Sesse__ 4y ago
But your durability goes down the drain on power loss or similar. Files are _really_ complicated to get durable.
867.
by Sesse__ 4y ago
I'd guess the “why” was “why on earth did they not have an antialiasing filter”, not “why did they downsample”. A good lowpass filter is easy to design, cheap to apply, and protects you from this kind of stuff.
868.
by Sesse__ 4y ago
> To add another misconception, the Nyquist frequency is a lower bound, below which you necessarily get aliasing. It doesn't say anything about whether said sampling rate is sufficient for reconstruction or whatever your intended us
869.
by Sesse__ 4y ago
I've worked on ultrasound systems that definitely worked this way, not just in theory but also in practice. Bandpass filter 20–40 kHz, sample directly at 40 kHz (giving 20 kHz bandwidth). No mixer step involved, but your spectrum becom
870.
by Sesse__ 4y ago
The big difference is that this preprocessing doesn't require a reversal step. JPEG's DCT requires an IDCT (and chroma conversion etc.), which the client needs to understnad and know about, while this merely introduces controlled

More ›