Litestream Writable VFS

Source: fly.io Date: 2026-03-20 URL: https://fly.io/blog/litestream-writable-vfs/

Summary

Engineering writeup introducing Litestream’s writable VFS mode, which allows SQLite databases to be queried and written directly from S3-compatible object storage without downloading the full database first. Writes go to a local temporary buffer and sync periodically — eventual durability, not strong consistency. A background hydration mode serves queries remotely while pulling the full database in the background. Explicitly scoped to Sprites’ cold-start storage problem, not general-purpose use.

Implications

Edge deployment economics / local-first architecture. The writable VFS is the missing piece in the Sprites + Litestream stack: if agents can read and write SQLite from S3 without a full download, Sprites can boot instantly with full database access and only pay the hydration cost in the background. The durability trade-off (eventual, not strong) is acceptable for the agent-workspace use case — agents writing scratch state and intermediate results don’t need ACID guarantees. This is the storage primitive that makes Sprites genuinely competitive with persistent-storage alternatives like EBS volumes or Render’s managed disks, at a fraction of the startup latency.