Comment by nprateem
2 years ago
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?
2 years ago
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?
This presentation is focused on the use-case of vertically scaling a single server and driving everything through that app server, which is running SQLite embedded within your application process.
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.
IIUC it does not work, the assumption here is that you can serve all your traffic with a single instance