How We Built the First Zero-Disk, S3-Tiered Storage Engine for SQLite
Summary
Rivet introduces a zero-disk, S3-tiered storage engine for SQLite, detailing how the Rivet virtual filesystem enables on-demand page reads and tiered storage. The piece lays out eight constraints guiding design, explains the hot tier and chunking, and discusses backups and point-in-time recovery.