All Topics
All Topics
Technology
Technology
Design
Design
Programming
Programming
Science
Science
News
News
Gaming
Gaming
Entertainment
Entertainment
Business
Business
Finance
Finance
Sports
Sports
Health
Health
Food
Food
Travel
Travel
Art
Art
Music
Music
Books
Books
Education
Education
Politics
Politics
Personal
Personal
No algorithm. No AI slop. No ads. Just RSS. Pro-human. Indie writers. Real journalism. Open web. Chronological. Hand toasted.

Turbolite: Experimental SQLite VFS for Direct S3 Querying with Sub-250ms Cold Latency

By

russellthehippo

2mo ago· 22 min readenCode

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 pulled
turbolite 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.
Snippet from the RSS feed
SQLite VFS with sub-100ms cold JOIN queries from S3 + page-level compression and encryption - russellromney/turbolite

You might also wanna read