What would a managed sqlite even look like? I can't tell if this is a real response or not...
Maybe a heroku that knows about your database file and automatically loads the latest version for you?
I kind of feel like GP is a troll comment, as there's no real value add for a managed SQLite.
If two copies of the DB accept writes at the same time, Litestream will just send backups to two different backup generations, and when you restore you'll only pull down one of those generations and won't receive the writes that landed in the other generations. All of your writes will still be in S3, they'll just be peppered across distinct backup snapshots and you can't get all the data back unless you separately restore all relevant generations and manually merge the restored databases.