Search

Lessons (18)

• Database Relations & Foreign Keys

  … Good schemas make invalid states hard or impossible to save. ![Relations: foreign keys connect one-to-one, one …

• DBMS Foundations, Keys & Normalization

  … Start from functional dependencies, split tables only when the split preserves necessary relationships, and stop when the design …

• N+1 Queries, Loading & Pagination

  Prevent hidden query explosions, load relations intentionally, and paginate large changing lists without scanning the past. The hidden …

• SQL vs NoSQL Databases

  Relational tables or flexible documents? Understand how each stores data, the four NoSQL families, ACID vs BASE, and …

• Database Internals, Replication and Scaling

  … CPU cost. Choose database types by access pattern: relational, document, key-value, wide-column, graph, time-series, search …

• Finding Service Boundaries with DDD

  … how contexts relate Relationship Meaning --- --- Customer / Supplier Downstream team's needs influence the upstream team's API Conformist …

• Replication, Partitioning & Sharding

  … Prefer colocating related data, asynchronous aggregates and explicit workflows. Do not shard because it sounds scalable; exhaust indexing …

• Code Smells & Refactoring

  … One change needs edits in 10 files Move related code together 9 Dead code Unused functions, flags, commented …

• Domain-Driven Design: Strategic Design

  … how contexts relate A context map shows the bounded contexts and the relationships between them, which are as …

• ACID, Transactions & Locks

  … either both commit or both roll back. ![A transaction either commits all related changes or rolls back; locks …

• Authentication, Authorization & API Security

  … 5k in their own department" ReBAC (relationship-based) Permissions from relationships "You can edit docs shared with you …

• Normalization & Denormalization

  … one fact, one home Normalization organizes a relational database so a fact is stored once, in the table …

• What Is Apache Kafka?

  … key, value, timestamp, headers One newspaper story Topic A named stream of related events, e.g. orders A …

• Clean Architecture

  … wires it all up Related names you'll hear - Hexagonal Architecture / Ports & Adapters (Alistair Cockburn): same idea. Ports …

• Topics, Partitions & Offsets

  … Topics A topic is a named stream of related events: orders , payments , page-views , user-signups . bash kafka …

• Onion Architecture & Clean vs Hexagonal vs Onion

  … postgres, stripe (Hexagonal adapters) How these relate to Layered architecture mermaid flowchart TB subgraph L["Layered: dependencies point …

• Creational Patterns: How to Make Objects

  … You never mix a Victorian chair with a Modern sofa. Problem: you need to create families of related …

• Domain-Driven Design: Tactical Patterns

  … The tactical DDD building blocks and how they relate](/img/architecture/ddd-tactical.svg) Building block One-line …