Scaling SQLite to 4M QPS on a Single Server

[exec]

https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-qps-on-a-single-server/

[addicted]

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.

[commandersaki]

> 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.

[div72 → commandersaki]

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

[cmacleod4]

This is from 2018, but still interesting.