--- title: "Litestream VFS" url: https://daily.dev/posts/litestream-vfs-6w045q5zt source_url: https://fly.io/blog/litestream-vfs/ type: article source: "Fly.io" published: 2025-12-11T17:43:56.360Z updated: 2025-12-11T17:44:18.666Z tags: ["backend", "sqlite"] reading_time: 9 upvotes: 45 comments: 1 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Litestream VFS **[Fly.io](https://daily.dev/sources/flydotio)** · 9 min read · 45 upvotes · 1 comments ## Summary Litestream VFS is a SQLite plugin that enables querying databases directly from object storage backups without downloading the entire database. It supports point-in-time recovery through SQL pragmas, allowing instant queries against historical database states. The system uses LTX file format for efficient page-level compaction, fetches only needed pages via S3 range requests, implements LRU caching for hot pages, and can maintain near-realtime replicas by polling backup storage every second. The VFS module works as a plugin to existing SQLite installations without requiring application modifications. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Community discussion Top comments from developers on daily.dev. **@gerhardjustolsen** · 0 upvotes > I hope I'm not kicking anyone, and I assume fly.io has fixed the issues. But, we had a major outage, using Lightstream on fly.io, including sever data loss in October, when we launched our website for a local festival. The problems only occured once we started getting actual traffic, less then 24 hours before the event. Several devs from our team of volunteers worked until 4 in the morning trying to restore service. In the end the organizers team had to spend hours in excel trying to prepare the lists of what events our participants got to go to and many of them didn't get their event... ## Similar posts on daily.dev - [Litestream v0.5.0 is Here](https://daily.dev/posts/litestream-v0-5-0-is-here-a2ph0wjhj) · Fly.io · 17 upvotes · 0 comments - [Litestream Writable VFS](https://daily.dev/posts/litestream-writable-vfs-iak6lqvkr) · Fly.io · 34 upvotes · 1 comments - [GitHub - russellromney/turbolite: SQLite VFS with sub-50ms cold queries from S3 \+ page-level compression and encryption](https://daily.dev/posts/github---russellromney-turbolite-sqlite-vfs-with-sub-50ms-cold-queries-from-s3-page-level-compres-9zseh6udt) · Hacker News · 13 upvotes · 1 comments - [SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers for Low-Latency App Servers](https://daily.dev/posts/sqlite-in-production-optimizing-wal-mode-concurrency-and-vfs-layers-for-low-latency-app-servers-wedvue3es) · Hacker News · 0 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/litestream-vfs-6w045q5zt)