It's not immediately clear. How does this work over the network for multiple app servers (or does it)?
Is the DB hosted on something like nfs, or are writes synced to all app servers or something else?
Is the DB hosted on something like nfs, or are writes synced to all app servers or something else?
This is the sweet-spot for SQLite applications, but there have been explorations and advances to running SQLite across a network of app servers. LiteFS (https://fly.io/docs/litefs/), the sibling to Litestream for backups (https://litestream.io), is aimed at precisely this use-case. Similarly, Turso (https://turso.tech) is a new-ish managed database company for running SQLite in a more traditional client-server distribution.