The History of the Database
From hierarchical and network models to Codd's relational revolution, the NoSQL wave, NewSQL, and the serverless present.
12 posts about databases
From hierarchical and network models to Codd's relational revolution, the NoSQL wave, NewSQL, and the serverless present.
The spatial index behind geographic databases, introduced by Antonin Guttman in 1984, and how bounding rectangles accelerate location queries.
SQL is more than fifty years old, has been declared obsolete more than once, and still runs the data layer of nearly every web application. Here is where it came from, the rival language it beat, and why nothing has managed to replace it.
A comprehensive technical guide to database replication, explaining the mechanics of read replicas, the critical tradeoff between consistency and availability, and the decision framework for using them effectively.
A deep, technical explanation of Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) databases, covering their internal mechanisms, core tradeoffs, and the decision framework for when to use each.
A comprehensive guide for engineers on using Redis for in-memory caching, covering core mechanics, common patterns like cache-aside, critical failure modes, and modern operational tradeoffs.
The log-structured merge-tree behind modern write-heavy databases, introduced by O'Neil and colleagues in 1996, and its compaction tradeoffs.
A technical overview of Cockroach Labs, the company behind the distributed SQL database CockroachDB, covering its history, technology, business model, and strategic tradeoffs for engineering leaders.
Oracle is a multinational technology corporation known for its relational database software, enterprise applications, and a growing portfolio of cloud infrastructure services.
Connection pooling is an essential performance optimization that reuses expensive network connections, but misconfigurations are a common and insidious cause of application slowdowns and outages.
A comprehensive overview of MongoDB Inc., the company behind the popular document database, covering its history, products, business model, and market position for a technical audience.
A comprehensive guide for engineers on the ACID properties of database transactions, with a deep focus on isolation levels, the concurrency anomalies they prevent, and the practical tradeoffs involved in choosing them.