Table of Contents

Preface

  1. Who this book is for
  2. Naming Conventions

Chapter 1: Hardware

  1. Computer Components
  2. Amazon Web Services

Chapter 2: Database Models

  1. Relational Databases (RDMS or RDBMS)
  2. Key Value Stores
  3. Document Stores
  4. Graph DBMS
  5. RDMS vs. Graph

Chapter 3: Relational Deep Dive

  1. ACID Compliance
  2. Write Ahead Log (WAL)
  3. How Postgres Stores Data
  4. How Postgres Stores Updates and Deletes
  5. Postgres Vacuums
  6. Column Order Matters

Chapter 4: Database Tuning

  1. PostgreSQL Config

Chapter 5: Schema Design

  1. “Has Many” Relationships
  2. “Has One” Relationships
  3. “Many to Many” Relationships
  4. Define the Relationship
  5. What is a UUID?
  6. Using UUIDs as Keys
  7. NULLs represent the Unknown state

Chapter 6: Indices

  1. Btree Index
  2. Gin Index
  3. GiST Index
  4. Trigrams in Gin or GiST Indices

Chapter 7: Query Optimization

  1. Explain Explained

Appendix: Database Vocabulary