Indeed there are trade offs, and high write applications are a weak spot of this approach. But for low to medium write applications (ie most applications?), SQL

Indeed there are trade offs, and high write applications are a weak spot of this approach. But for low to medium write applications (ie most applications?), SQLite WAL [1] option performs really well. We implement application level caching via a X-Query-Cache header[2], in that case, you're serving directly from redis. This set up can scale really, really well. [1] https://www.sqlite.org/wal.html https://www.sqlite.org/wal.html [2] https://www.lite-engine.com/docs.html#caching https://www.lite-engine.com/docs.html#caching