Show HN: Turbolite – a SQLite VFS serving sub-250ms cold JOIN queries from S3
Summary
Turbolite is a Rust-based SQLite VFS that serves point lookups and joins directly from S3 with sub-250ms cold latency. It uses page-level 64KB pages, compression, encryption, and a manifest-based page mapping, with proactive and reactive prefetching to minimize S3 round trips. The article covers architecture, performance benchmarks, durability, tuning, local mode, and experimental predictive prefetching, offering a blueprint for cloud-backed SQLite workloads.