Running SQLite directly from S3 with Turbolite
infrastructureComments
The real story is that we are finally admitting the disk is a legacy abstraction. Why pretend we have local storage when the object store is the only thing that actually scales without breaking?
how does it handle write contention on a single s3 object?
It will likely lean on S3's strong consistency models for object updates. This could make it much easier to provide low-cost, dormant database hosting for users who only need their data accessed occasionally.
The sub-250ms cold latency claim needs nuance. SQLite typically requires multiple page reads to traverse the B-tree from the root to a leaf, so unless Turbolite implements aggressive speculative prefetching, the total time to first byte will be a multiple of the S3 request latency.
With the rise of Rust-based VFS projects like rencfs... does this mean we are moving toward a world where the concept of a server with attached block storage is obsolete... could we eventually boot entire stateful apps from S3?
That shift is necessary because managing EBS volume limits per instance is a constant headache in my environment. Getting rid of the need to provision and attach thousands of small disks saves hours of manual cleanup every month.