3 ms·
I've become really interested in SQLite when I heard about Litestream. What kind of deployment strategies do folks use to deploy SQLite and Litestream for produ
by sakopov 4y ago
I've become really interested in SQLite when I heard about Litestream. What kind of deployment strategies do folks use to deploy SQLite and Litestream for production use? Also, AFAIK writes can only be done via master instance, so how do you control read/writes from multiple app instances?
- markusw 4y agoHave a look at the followup article that touches on distributed SQLite with LiteFS. :)
- 0cf8612b2e1e 4y agoOnly 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.
- markusw 4y agoI don’t think there’s too much difference to “regular” distributed SQLite, but I’ll have to think about that.