Sqlite is fine you need to read the extensive documentation though to get the most out of it. It also has terrible defaults. I think the author od this article

Sqlite is fine you need to read the extensive documentation though to get the most out of it. It also has terrible defaults. I think the author od this article missed sqlite_busy. Once you do have it set up correctly, are handling a single writer at the application level and have litestream set up your off to the races assuming your app can scale on a single box (it most likely can).