[carbonatom]

For me the biggest limitation is replicating the SQLite across machines. If my app is running on multiple nodes, then we need to write/use some tooling to replicate the database file across nodes. With that comes the problem of figuring out how we want to handle error scenarios like failed replication, partial replication and such other things.

And these are all hairy problems. At that point it might be just simpler to use a centralized Postgres or a proper distributed database.