Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Scaling SQLite to 4M QPS on a Single Server (expensify.com)
38 points by exec on Nov 12, 2021 | hide | past | favorite | 4 comments


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: