This is something that I am a huge fan of, particularly from a latency & performance perspective. NVMe + SQLite is a hell of a package deal. If you just need to

This is something that I am a huge fan of, particularly from a latency & performance perspective. NVMe + SQLite is a hell of a package deal. If you just need to go as fast as possible no matter what, this is a great place to start. At the highest end the hosted solutions can outpace SQLite but it's like that meme [0]. That said, I'm working on a new contract/project that is somewhat antagonistic to the idea of using SQLite on the server. The biggest reasons are due to employees needing direct (transactional) access to the live data and the ability to do online schema changes. There are ways to force this with additional tools, but I'm finding that just paying for MSSQL provides a lot of uplift on this particular problem. The possibility that other employees already have experience with tools like SSMS should not be overlooked when making technology decisions. People are generally the biggest bottleneck in any business. [0] https://knowyourmeme.com/memes/look-what-they-need-to-mimic-a-fraction-of-our-power https://knowyourmeme.com/memes/look-what-they-need-to-mimic-...