awesome-dbdev
github.com/huachaohuang/awesome-dbdev ↗Awesome materials about database development.
Use this list with your AI agent
Add the Context Awesome MCP server to Claude, Cursor, or any MCP client, then ask:
"Show me sql resources from awesome-dbdev"
Installation instructions →What's inside
Relational database
- Access Path Selection in a Relational Database Management SystemSQL
- Alibaba Hologres: A Cloud-Native Service for Hybrid Serving/Analytical ProcessingHSAP
- Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational DatabasesOLTP
- Amazon Aurora: On Avoiding Distributed Consensus for I/Os, Commits, and Membership ChangesOLTP
- Amazon Redshift Re-inventedOLAP
- AnalyticDB: Real-time OLAP Database System at Alibaba CloudOLAP
Transaction
- A Critique of ANSI SQL Isolation Levels
- A Critique of Snapshot Isolation
- Causal Memory: Definitions, Implementation and Programming
- Generalized Isolation Level Definitions
- Granularity of Locks and Degrees of Consistency in a Shared Data Base
- How to Make a Multiprocessor Computer That Correctly Executes Multiprocess Program
Storage Device
- A History of PC Buses - From ISA to PCI ExpressInterface
From ISA to PCI Express
- Coding for SSDs - What every programmer should know about SSDsMedia
What every programmer should know about SSDs
- Hard Disk Drive (HDD)Media
- How Flash Memory WorksMedia
- How HDD WorksMedia
- NVM Express (NVMe)Interface
Distributed system
- Amazon DynamoDB: A Scalable, Predictably Performant, and Fully Managed NoSQL Database Service
including Alexa, the Amazon.com sites, and Amazon fulfillment centers, made trillions of API calls to DynamoDB, peaking at 89.2 million requests per second, while experiencing high availability with single-digit millisecond performance. Since the launch of DynamoDB in 2012, its design and implementation have evolved in response to our experiences operating it. The system has successfully dealt with issues related to fairness, traffic imbalance across partitions, monitoring, and automated system operations without impacting availability or performance. Reliability is essential, as even the slightest disruption can significantly impact customers. This paper presents our experience operating DynamoDB at a massive scale and how the architecture continues to evolve to meet the ever-increasing demands of customer workloads.
- Anna: A KVS for Any Scale
- Autoscaling Tiered Cloud Storage in Anna
- Bigtable: A Distributed Storage System for Structured Data
- Brewer’s Conjecture and the Feasibility of Consistent, Available, Partition-Tolerant Web Services
- CAP Twelve Years Later: How the "Rules" Have Changed
Testing and deployment
Introduction
Storage Engine
- Bitcask: A Log-Structured Hash Table for Fast Key/Value DataHash table
- bLSM: A General Purpose Log Structured Merge TreeLSM-tree
- Building a Bw-Tree Takes More Than Just Buzz WordsB-tree
- Cache Craftiness for Fast Multicore Key-Value Storage
- Cache-Oblivious Streaming B-treesB-tree
- Cost/Performance in Modern Data Stores
Distributed transaction
- Calvin: Fast Distributed Transactions for Partitioned Database Systems
- Consensus on Transaction Commit
- Consistency in Non-Transactional Distributed Storage Systems
- Consistency without Clocks: The FaunaDB Distributed Transaction Protocol
- Demystifying Database Systems, Part 1: An Introduction to Transaction Isolation Levels
- Demystifying Database Systems, Part 2: Correctness Anomalies Under Serializable Isolation
Showing a sample of 163 resources. View the full list on GitHub →