The Grind

Using AI to learn, not to pretend I already know. One byte at a time.

Topics

Connection Pooling & Database Proxies

• Connection Pooling (General)
• Database Connection Pooling
• Query Distribution & Routing
• Query Hints & ORMs
• Prepared Statements vs DB Functions

Databases — Relational

• Row-Level Locks & MVCC
• Isolation Levels
• Optimistic vs Pessimistic Locking
• Deadlocks
• SKIP LOCKED & NOWAIT
• SQL Data Types
• Design: KV Store on SQL

Databases — Non-Relational

• Columnar Databases
• Graph Databases
• Wide Column Stores
• Polyglot Persistence

Databases — Core Concepts

• Storage Engines: B+ Trees vs LSM Trees
• Communication Protocols

System Design

• Design: KV Store
• Design: Slack Realtime Communication

Task Delegation

• Message Queues, Brokers & Streams
• Kafka Architecture

Python Deep Dive

• Threads & Locks
• Condition Variables
• Simple Message Queue
• Async & Event Loops

Tools

• Code Playground -- Run Python and Go snippets in the browser