Core concepts
The building blocks. Explained clearly.

Core Mechanics: In plain terms, ACID ensures a group of database operations either finishes completely or leaves no visible trace (Atomicity), keeps enforced schema rules intact (Consistency), shields concurrent readers from partial work (Isolation), and survives process crashes once flushed to non-volatile storage (Durability).
Visual & Structural Flow: Covers the Write-Ahead Log (WAL) + Multi-Version Concurrency Control (MVCC) commit and recovery pipeline (SQL Client -> Buffer Pool + MVCC -> WAL fsync -> CLOG + Heap Pages), the Write Skew sequence under Snapshot Isolation (Tx 1 Dr. Alice & Tx 2 Dr. Bob), and the ACTIVE -> COMMITTED / ABORTED (40001) retry state machine.
Trade-Offs & Production: Choose READ COMMITTED for independent single-row updates, REPEATABLE READ for multi-query snapshot consistency, and SERIALIZABLE (or a shared guard-row lock followed by every writer) when invariants span multiple rows. Local WAL fsync protects against single-node power loss—not disk corruption or site-wide outages.
Failure Modes & Application: On serialization (40001) or deadlock (40P01) errors, roll back explicitly, apply jittered backoff, retry the entire transaction from BEGIN, and keep external HTTP or webhook calls outside the transaction.
A handbook for software systems
Complex systems. Clear thinking.
Learn how engineering systems work, where they fail, and how to make sound design decisions.

Newly Published
Write-Audit-Publish (WAP) isolates unvalidated DAG outputs in a staging branch or prefix, runs automated data-quality gates, and promotes to production via an atomic metadata pointer swap.
The Mercator URL Frontier separates crawl priority (Front Queues) from per-host politeness (Back Queues) so high-priority domains are crawled fast without DDoSing any single origin server.
Fill-in-the-Middle (FIM) rearranges code around the cursor into `<PRE> prefix <SUF> suffix <MID>` so autoregressive models condition on both preceding and following code.
Hybrid RAG combines dense HNSW vector search with sparse BM25 lexical search via Reciprocal Rank Fusion (RRF), enforces document-level ACLs via pre-filtered Roaring Bitmaps, and reranks Top-50 -> Top-5 with a Cross-Encoder.
Real-time presence uses periodic WebSocket heartbeats into TTL-backed Redis keys (`SETEX 45s`) with online/offline hysteresis, paired with hybrid push/pull fan-out for small vs. massive channels.
Time-of-Check to Time-of-Use (TOCTOU) race conditions occur when state validated in step 1 changes before step 2 mutates it; Atomic Compare-And-Swap (CAS) closes the gap in a single indivisible operation.
Find your starting point
The building blocks. Explained clearly.
Real requirements. Concrete designs.
Patterns in the context that matters.
How to structure, reason, and prepare.
Write-Audit-Publish (WAP) isolates unvalidated DAG outputs in a staging branch or prefix, runs automated data-quality gates, and promotes to production via an atomic metadata pointer swap.
Learn by doing
Connect services, data, and scale.
Turn requirements into clean abstractions.
Make the logic work, then make it efficient.