Databases

DB Technologies

• Apache Druid (Analytics OLAP)
• Surreal DB (Graph DB "NextSQL") HN

Indexing

• https://use-the-index-luke.com/

Postgres

• Why does Neon use Paxos instead of Raft, and what’s the difference?
• Postgres Internals
• Postgres Tips- 9 Ways to Shoot Yourself in the Foot with Postgres
• Transaction Isolation in Postgres, explained
• Zero downtime Postgres upgrades

SQLite

• Turning SQLite into a distributed database
• Scaling SQLite to 4M QPS on a Single Server (EC2 vs Bare Metal)
• SQLite, Past Present & Future
• How SQLite Helps You Do ACID
• SQLite the only database you will ever need in most cases

ACID

• Jepsen: Distributed Systems Safety Research
• Overview of Consistency Levels in Database Systems

ACID Series By Brandur

• ACID
• HTTP Transactions
• Job Drain
• Idempotency Keys

Migrations

• How to safely run DDL operations without interrupting production

Misc

• What's the big deal about embedded key-value databases like RocksDB?
• Log Structured Merge Trees
• SQL Style Guide
• Build your own disk based KV store in Go
• Database Fundamentals