4 ms·
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 sy
by nprateem 3y 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?
- vander_elst 3y agoIIUC it does not work, the assumption here is that you can serve all your traffic with a single instance
- fractaledmind 3y agoThis 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/ https://fly.io/docs/litefs/), the sibling to Litestream for backups (https://litestream.io https://litestream.io), is aimed at precisely this use-case. Similarly, Turso (https://turso.tech https://turso.tech) is a new-ish managed database company for running SQLite in a more traditional client-server distribution.