Litefs persistence

[ignoramous]

@olingern

My initial impression of the offering was that Litefs would allow me to use SQLite as a traditional database, saving network latency (which is true!); however, I think having to consider persistence of SQLite makes me think of it more as a globally distributed cache that is multi-region by default.

LiteFS cannot overcome the fact that Fly VMs have ephemeral storage (like EC2 does). Volumes (analogous to EBS) that you must attach are disks you’d attach if you needed persistent storage for any reason (let alone LiteFS). Even without volumes, LiteFS can still holds its own if multiple-VMs go down. Just not when ALL VMs go down.

@olingern

Question: Are there any plans to bake this in to the platform so that end users of SQLite/Litefs aren’t concerned with persisting their data?

I’ve been calling for it (a16z has been calling for it): Fly needs to have a managed database offering, rather than merely automated ones. LiteFS could be it. Or not. Not sure what their plans are, really.

Tough, if you’re looking for a fully-managed database, there are plenty like PlanetScale, Aurora Serverless v2, Cloudflare D1 etc.