Litestream Writable VFS

SQLite’s backup buddy goes writable — fans cheer, safety hawks side‑eye

TLDR: Litestream’s new writable VFS lets apps read and now write SQLite databases straight from cloud storage, speeding Fly.io’s “Sprites” quick boot. Fans gush and ask for Postgres and multi-file magic, while skeptics demand safeguards against corruption from multiple writers and newbies ask how to try it without S3.

Fly.io just flipped the switch: Litestream’s magic “read from the cloud before the file even arrives” trick now does writes, too. Translation for normal humans: their tool can open your tiny app database straight from online storage and start answering questions instantly — and now it can save changes just as fast. It’s powering Fly.io’s speedy “Sprites,” which boot in under a second with massive storage. The crowd? Loud.

The hype squad is out in force. One fan flexed that Litestream + PocketBase “just works,” then asked if you could merge a bunch of friends’ database files on the fly — like playlist mashups for data. Another voice crashed the party with a reality check: what keeps two writers from corrupting stuff? They’re watching for “write leases” (a kind of hall pass so only one writer edits at a time) and liked the idea of pausing background syncing when writes start. Meanwhile, the Postgres faithful showed up like, “Cool story, but where’s our version?” And a hobbyist asked the most relatable question of all: how do I try this without Amazon‑style storage?

Even the site’s weird timestamps became a mini‑meme (“time travel release?”). Bottom line: fans see a future where tiny, fast databases rule, cynics want guardrails, and everyone’s wondering if this cloud‑first speed trick can scale beyond SQLite. Drama served hot, just like those Sprites.

Key Points

  • Litestream synchronizes SQLite databases with S3-compatible object storage to provide simple, fast data management with durability.
  • Fly.io’s Sprites rely on Litestream for a global orchestrator using per-organization SQLite databases stored on object storage.
  • Sprites’ disk storage uses JuiceFS with NVMe read-through caching, providing sub-second boot and 100GB durable storage; metadata uses Litestream SQLite.
  • Litestream VFS enables point-in-time SQLite queries directly from object storage prior to full database download.
  • The VFS has been made optionally read-write to support immediate writes and address steady-state performance needs.

Hottest takes

"anyone knows what is the equivalent of litestream for postgres?" — vivzkestrel
"stitch together a bunch of .db files (that share the same schema) in an ad-hoc way?" — xrd
"I’m still waiting on how they’ll prevent accidental corruption from multiple writers" — ncruces
Made with <3 by @siedrix and @shesho from CDMX. Powered by Forge&Hive.