Scaling SQLite to 4M QPS on a Single Server

The epilogue mentions meltdown and spectre. I’m no expert on these, but wouldn’t the use case of a self hosted server where you install trusted applications only not be affected by meltdown and spectre?

My understanding was the w biggest worries with those bugs were precisely in the cloud, since they run untrusted code and run multiple users on the same hardware.

> Make RANDOM() deterministic (for some reason it’s non-deterministic by default)

What does making RANDOM() deterministic mean? Seems like it defeats the purpose of generating randomness.

I assume that is for the benchmark to have accurate results and not for normal operation.

This is from 2018, but still interesting.