100k TPS over a billion rows: the unreasonable effectiveness of SQLite

kept by eddie dec 05, 25

SQLite achieves over 100k transactions per second on a billion-row dataset by avoiding network overhead, though durability and HA remain trade-offs.

Deep dive into Turso, the “SQLite rewrite in Rust”
Turso rewrites SQLite in Rust to enable a new database engine compatible with SQLite's file format while addressing C's memory safety issues and adding support for concurrent writes.
also on #databases, PostgreSQL, SQLite, Hacker News, #software-engineering, #developer-tools
debloat.dev — replace the junk
debloat.dev lists open-source alternatives to replace bloated vendor software, featuring projects like VSCodium, Immich, and Home Assistant with licensing and user ratings.
also on Syncthing, #software-engineering, #developer-tools
Maybe we don't need a server
Syncthing syncs files directly between devices without a server, and the author imagines a future where calendars, contacts, and email are just synced files.
also on Syncthing
An interactive visualization that follows a single HTTP request through its entire ~200ms life — DNS, TCP, TLS, the kernel, Node's event loop, Postgres, and back
The visualization walks through a single HTTP request's ~211 ms journey, showing DNS, TCP, TLS, kernel, Node event loop, Postgres, and rendering.
also on #databases, #performance, #developer-tools
AI inference just plays by different rules
AI inference workloads demand unprecedented concurrency and throughput, exposing cloud storage limits that require a decoupled, software-defined layer to avoid catastrophic failures.
also on PostgreSQL, #performance