Only had a chance to skim the LiteFS article, but one use case closer to my heart would be blue-green deployments against the same SQLite database for zero-downtime deployments. Conceptually, I think I could use LiteFS to the same effect as distributed, but would love to see a write-up or any gotchas likely to occur.

I don’t think there’s too much difference to “regular” distributed SQLite, but I’ll have to think about that.