>>106887458
>It's a fact that SQLite is superior if you have mostly reads
That's pre-mature optimization while your writes are a lot worse. Not good general advice.

>Hosting MySQL on the same VPS that you have your app code on can be done but it quickly gets complicated
Breaking away from the established n-tier architecture and using SQLite is what's getting complicated soon. There are no established patterns how to handle storage failure.

It's also pretty ironic that you are basically doing serverless by embedding a db. We wanted to move away from the serverless fad.