News for hackers. Stuff that matters.
Re:LiteFS a FUSE-based file system for replicating SQLite by bbertelsen on Tuesday July 26, 2022 @04:22PM (#32243457)
Can you describe one or more use cases?
Re:LiteFS a FUSE-based file system for replicating SQLite by benbjohnson on Tuesday July 26, 2022 @04:40PM (#32243683)
One main advantage of LiteFS is being able to deploy a SQLite-based application and not have downtime during deploys. This is especially true in ephemeral systems like Kubernetes where pods will rollover.

Another use case is moving data close to users. If you're only targeting users in a single country then it's not as big of a deal but RTT from the US to Europe is ~100ms and US to Asia is ~250ms. That's a big latency hit depending on what you're trying to do.

Re:LiteFS a FUSE-based file system for replicating SQLite by qbasic_forever on Tuesday July 26, 2022 @04:45PM (#32243737)
It might be interesting for embedded scenarios where you need an always-available database but can't guarantee there will be a connection available consistently to a central database server.