Skip to content
48

Awesome Database Development

Awesome materials about database development.

1.6k stars87 forks40 entriesLast push Mar 30, 2024 (2 years 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)

In 2 lists

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)

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)

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

(Fauna, 2019)

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

(Fauna, 2019)

Demystifying Database Systems, Part 3: Introduction to Consistency Levels

(Fauna, 2019)

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

(Fauna, 2019)

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
87

Awesome Postgres

dhamaniasad/awesome-postgres

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

Fresh★ 12k52 entriesPushed 1 month ago
86

awesome-mysql

shlomi-noach/awesome-mysql

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

Fresh★ 2.6k109 entriesPushed 7 days ago
84

Awesome PocketBase

benallfree/awesome-pocketbase

A collection of PocketBase community resources.

Fresh★ 1.2k92 entriesPushed today
83

Awesome Game Datasets

leomaurodesenv/game-datasets

:video_game: A curated list of awesome game datasets, and tools to artificial intelligence in games

Fresh★ 1.1k189 entriesPushed 9 days ago
82

Awesome MongoDB

ramnes/awesome-mongodb

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

Fresh★ 2.7k182 entriesPushed 11 days ago
75

Awesome Database Tools

mgramin/awesome-db-tools

Everything that makes working with databases easier

Active★ 5.3k320 entriesPushed 4 months ago