Reading up on databases
7 deep · digging since dec 05, 25
- 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.
- What is a database transaction?
PlanetScale's blog post uses visualizations to explain database transactions, isolation levels, and ACID properties, sparking discussion on their intuitive presentation and underlying complexities.
- 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.
- Welcome to the Machine, a guide to building infra software for AI agents - me.0xffff.me
Infrastructure software must shift from human-centric design to AI-agent-centric design, emphasizing stable mental models, disposable workloads, and extreme cost efficiency.
- SQLite JSON at full index speed using generated columns
SQLite can index JSON fields at full B-tree speed by creating virtual generated columns with json_extract and indexing them.
- 100k TPS over a billion rows: the unreasonable effectiveness of SQLite
SQLite achieves over 100k transactions per second on a billion-row dataset by avoiding network overhead, though durability and HA remain trade-offs.