Multiple apps using the same SQLite databases

[benbjohnson]

@gcv

What is the best option to share the same data between multiple applications?

Is it possible to share the same LiteFS cluster? What are the potential issues?

Yes, it’s possible to share a LiteFS cluster across apps as long as they’re in the same organization. You’ll just need to have the same FLY_CONSUL_URL set if you’re using Consul-based leasing and you’ll need to use the same lease key:

lease:
  type: "consul"
  consul:
    key: "mykey"

@gcv

Is it better to use one of the apps as a server and the others as a client connection to the server using private networking? Does it make sense to have a mix of server for writes and disk for reads?

It’s probably easiest to have your candidate nodes in the same app & region but LiteFS will work across any group of machines.