I wonder if even the multiple servers and dedicated SQL server are overkill for most applications. The simplicity of running the whole thing on one machine usin

I wonder if even the multiple servers and dedicated SQL server are overkill for most applications. The simplicity of running the whole thing on one machine using SQLite, with Litestream or something like it for backups, is really seductive. Edit to add: and as you've pointed out before, the locality of having the database right there in the application process leads to really good performance.