Litestream VFS
2 days ago
- #Litestream
- #Backup
- #SQLite
- Litestream is a free, open-source backup/restore system for SQLite.
- Litestream VFS allows querying SQLite databases directly from S3 backups without downloading the entire database.
- Point-in-time recovery (PITR) is possible with Litestream, enabling queries against past database states.
- LTX, a SQLite data-shipping file format, enables efficient compaction by skipping redundant page versions during restores.
- Litestream VFS uses an LRU cache to minimize S3 calls by caching frequently accessed database pages.
- Litestream supports near-realtime replication by polling S3 for incremental updates.
- The system is designed for simplicity and production use, with Fly.io relying on it for critical APIs.