4 ms·

There's also the alternative of having a cluster with one local DB in each node

• direwolf20 9mo ago
  Then you have massive synchronization problems if your data isn't almost read–only.
  • Gabrys1 9mo ago
    if your data isn't mostly read-only, then you're going to have an issue with SQLite. It doesn't nicely support parallel writers
  • CuriouslyC 9mo ago
    Not if you're sharding correctly.
    • bastawhiz 9mo ago
      You're going to shard your data so requests end up on the server that has the local database that has the right data? Really? Are you going to write a custom load balancer to do this, just so you can use sqlite sharded onto each box? And what happens if you add a new server or scale down? You need to re-shard your data?