- Understanding Atomicity in ACID
- Understanding Consistency in ACID
- Understanding Isolation in ACID
- Understanding Durability in ACID
- Secure PostgreSQL 🔒
- How Postgres Makes Transactions Atomic
- PostgreSQL LISTEN/NOTIFY
- Zero downtime Postgres upgrades
- Postgres TOAST: The Greatest Thing Since Sliced Bread?
- Herding elephants: Lessons learned from sharding Postgres at Notion
- PostgreSQL reconsiders its process-based model
- How to Manage Connections Efficiently in Postgres, or Any Database
- Optimizing Database Design: PostgreSQL Data Type Selection Best Practices and More
- Zero downtime Postgres migration, done right
- An Overview of Distributed PostgreSQL Architectures
- Geographically distributed Postgres for multi-tenant applications
- How to Get the Most out of Postgres Memory Settings
- How Postgres stores data on disk – this one's a page turner
- SQL vs NoSQL
- Build a simple database
- One Giant Leap For SQL: MySQL 8.0 Released ✨
- MongoDB is to NoSQL like MySQL to SQL — in the most harmful way
- Building Robust Systems with ACID and Constraints ✨
- Awesome Database Learning
- Things I Wished More Developers Knew About Databases 🚧
- Maximizing MongoDB Performance on AWS
- Read Consistency with Database Replicas
- Inconsistent thoughts on database consistency
- UUIDs are Popular, but Bad for Performance
- Mysql 8.0: UUID support
- Practical Problems with Auto-Increment
- Why UUID7 is better than UUID4 as clustered index in RDBMS
- Understanding Database Sharding
- An Unorthodox Approach To Database Design : The Coming Of The Shard ✨
- RUM Conjecture
- Spanner's High Availability Writes
- B-trees Require Fewer Comparisons Than Balanced Binary Search Trees