Reading up on databases
6 deep · digging since dec 05, 25
- 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.