Turbolite: Experimental SQLite VFS for Direct S3 Querying with Sub-250ms Cold Latency
By
russellthehippo
Hand-rolled, kettle-boiled, baked to perfection. Worth every minute at the bakery.
Summary
Turbolite is an experimental SQLite VFS (Virtual File System) written in Rust that enables direct querying of SQLite databases stored in S3 object storage with sub-250ms cold latency for point lookups and JOIN operations. The system leverages the decreasing latency gap between local storage and cloud object storage, taking advantage of fast S3 services like S3 Express One Zone. Turbolite also provides page-level compression using zstd and AES-256 encryption for data at rest, which can be used independently of the S3 functionality. The project is experimental and carries risks including potential data corruption.
Key quotes
· 4 pulledturbolite is a SQLite VFS in Rust that serves point lookups and joins directly from S3 with sub-250ms cold latency.
It also offers page-level compression (zstd) and encryption (AES-256) for efficiency and security at rests, which can be used separately from S3.
turbolite is experimental. It is new and contains bugs. It may corrupt your data. Please be careful.
Object storage is getting fast. S3 Express One Zone delivers single-digit millisecond GETs and Tigris is also extremely fast. The gap between local disk and cloud storage is shrinking, and turbolite exploits that.
You might also wanna read
EloqDoc: MongoDB-Compatible Distributed Document Database with Cloud Object Storage Foundation
EloqDoc is a MongoDB-compatible, high-performance distributed document database that uses cloud object storage as its persistent foundation
Chroma Introduces wal3: A Write-Ahead Log Built on Object Storage with Lock-Free Algorithm
The article introduces wal3, Chroma's new write-ahead log system that combines a 30-year-old lock-free algorithm with S3's newest conditiona
Google enters AI agent runtime race as the infrastructure layer becomes commoditized
Google repositioned Antigravity as a platform for developing and managing teams of autonomous AI agents at its I/O conference. The platform
bit.ly·8h agoPostgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d agoPostgres-Backed Durable Workflow Execution: An Alternative to External Orchestration Systems
This article explains the concept of durable workflow execution using Postgres as the backing database, as implemented by the DBOS system. I
dbos.dev·3d agoCloudflare Integrates Claude Managed Agents for Developer Deployment
Cloudflare has added support for Claude Managed Agents, enabling developers to deploy, run, and manage Claude AI agents within the Cloudflar
