#databases
Wiki 14
- Building a Go Transaction Linter How léon h built transactioncheck after shipping a transaction leak bug to production
- Charles Leifer's Blog Python and database systems engineer at charlesleifer.com; peewee ORM, SQLite/Postgres deep-dives, Redis internals, well-aged opinions
- IngoDB — AI-Native Adaptive Database Self-morphing LSM document store in Rust; reactive indexing from query patterns, Liquid AST for AI agents
- LSM Tree Write-optimized storage: append-only MemTable/SSTable design behind Cassandra, RocksDB, LevelDB
- LSM Trees and NoSQL Storage LSM tree architecture; MemTable, WAL, SSTables, Bloom filters, compaction strategies, and failure modes
- Please stop calling databases CP or AP Kleppmann (2015): CAP's definitions are too narrow to classify real databases, most of which are neither CP nor AP, so drop the labels
- Postgres LISTEN/NOTIFY Can Actually Scale How DBOS took Postgres LISTEN/NOTIFY from 2.9K to 60K writes/sec by batching notifications
- Prefer Strict Tables in SQLite Evan Hahn on why STRICT tables (fixed column types) beat SQLite's default flexible typing, plus the mechanics of type affinity
- Redis and the Cost of Ambition Leifer on Redis's feature-set inflation tracking each year's HN trend, the protocol second-system effects, and Valkey as the market's verdict
- ScyllaDB's trie-based SSTable index Replacing Summary.db + Index.db with a page-packed prefix tree: up to 3x read throughput
- SQLite in Production WAL mode can block short-lived readers, plus a pragma blueprint with two of its claims corrected
- The Secret Life of Data in Valkey Kyle Davis on Valkey's hidden encoding layer, where one byte over a threshold costs 77% more memory
- Things You Didn't Know About Indexes Common index pitfalls (composite order, functions) and lesser-known types (partial, covering, functional)
- Ursa: Iceberg-First Storage Engine for Kafka StreamNative's diskless Kafka storage engine — writes directly to S3 as Iceberg/Delta tables, 10x cheaper
Toolbox 1
- transactioncheck Go linter catching database calls that use the outer repo instead of the transaction handle
Books 7
- Concurrency Control and Recovery in Database Systems Bernstein's out-of-print, freely distributed source text on serializability, 2PL, MVCC and recovery
- Database Design and Implementation Sciore's build-it-as-you-read course growing SimpleDB from disk pages up to a working RDBMS
- Database Internals: A Deep Dive into How Distributed Data Systems Work Petrov's two-part survey of storage engines and the distributed side of database systems
- Designing Data-Intensive Applications (2nd ed.) Kleppmann on the tradeoffs behind storage engines, replication, and stream processing
- On Transactional Concurrency Control Graefe reframing 2PL, OCC, MVCC and snapshot isolation under one coherent model
- Readings in Database Systems (5th ed., the Red Book) The Red Book — annotated database-papers reading list with the editors' framing essays
- Transaction Processing: Concepts and Techniques Gray and Reuter end to end on locking, logging, two-phase commit and fault tolerance