Skip to content
81

Awesome Database Development

Awesome materials about database development.

1.6k stars86 forks40 entriesLast push Nov 8, 2026 (8 days ago)License none

This page lists names, links and short descriptions. The original list on GitHub is the source and belongs to its authors.

Introduction

Readings in Database Systems

In 3 lists

Designing Data-Intensive Applications

The "Bible" for understanding how data systems actually work under the hood.

In 2 lists

How does a relational database work

(2015)

Elements Of Scale: Composing And Scaling Data Platforms

(2015)

Apache Kafka, Samza, and the Unix Philosophy of Distributed Data

(2015)

System programming >Linux kernel

Understanding the Linux Kernel

Understanding the Linux Virtual Memory Manager

ext4 Data Structures and Algorithms

Storage Device >Media

Hard Disk Drive (HDD)

How HDD Works

(Video)

The Development of HDD Technique

(Video)

Solid-State Drive (SSD)

How Flash Memory Works

(Video)

Coding for SSDs - What every programmer should know about SSDs

Storage Device >Interface

A History of PC Buses - From ISA to PCI Express

(Video)

Serial Attached SCSI (SAS)

Understanding SCSI

(Video)

Serial AT Attachment (SATA)

PCI Express (PCIe)

NVM Express (NVMe)

Relational database >SQL

How We Built a Cost-Based SQL Optimizer

(Cockroach Labs, 2018)

How We Built a Vectorized SQL Engine

(Cockroach Labs, 2019)

Relational database >OLTP

How CockroachDB Does Distributed, Atomic Transactions

(Cockroach Labs, 2015)

How online schema changes are possible in CockroachDB

(Cockroach Labs, 2016)

Living Without Atomic Clocks

(Cockroach Labs, 2016)

Serializable, Lockless, Distributed: Isolation in CockroachDB

(Cockroach Labs, 2016)

CockroachDB’s Consistency Model

(Cockroach Labs, 2019)

Relational database >Miscellaneous

The relational model for database management

(1990)

Link may be dead

PostgreSQL 14 Internals

(2023)

In 3 lists

Transaction

Linearizability versus Serializability

(2014)

Distributed transaction

Distributed consistency at scale: Spanner vs. Calvin

(2017)

NewSQL database systems are failing to guarantee consistency, and I blame Spanner

(2018)

Consistency without Clocks: The FaunaDB Distributed Transaction Protocol

(Fauna, 2018)

Link may be dead

Demystifying Database Systems, Part 1: An Introduction to Transaction Isolation Levels

(Fauna, 2019)

Link may be dead

Demystifying Database Systems, Part 2: Correctness Anomalies Under Serializable Isolation

(Fauna, 2019)

Link may be dead

Demystifying Database Systems, Part 3: Introduction to Consistency Levels

(Fauna, 2019)

Link may be dead

Demystifying Database Systems, Part 4: Isolation levels vs. Consistency levels

(Fauna, 2019)

Link may be dead

Distributed system

CAP Twelve Years Later: How the "Rules" Have Changed

(2012)

Lessons learned and the future

Notes on Distributed Systems for Young Bloods

(2013)

In 2 lists

What I Learned From Programming Databases

(2016)

See category
91

Awesome Postgres

dhamaniasad/awesome-postgres

A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql

Fresh★ 12k53 entriesPushed 10 days ago
91

Awesome PocketBase

benallfree/awesome-pocketbase

A collection of PocketBase community resources.

Fresh★ 1.2k95 entriesPushed today
89

awesome-mysql

shlomi-noach/awesome-mysql

A curated list of awesome MySQL software, libraries, tools and resources

Fresh★ 2.6k111 entriesPushed 28 days ago
87

Awesome MongoDB

ramnes/awesome-mongodb

:leaves: A curated list of awesome MongoDB resources, libraries, tools and applications

Fresh★ 2.7k188 entriesPushed 9 days ago
84

Awesome Database Tools

mgramin/awesome-db-tools

Everything that makes working with databases easier

Fresh★ 5.4k320 entriesPushed 1 month ago
70

Awesome SQLAlchemy

dahlia/awesome-sqlalchemy

A curated list of awesome tools for SQLAlchemy

Active★ 3.1k29 entriesPushed 5 months ago