Wesley Harding

The part that keeps it running

SYSTEMS

Six sheets, drawn like the engineering documents they are — the schema, the pipelines, and the guarantees underneath everything the front shows.

  1. 01

    Database architecture

    normalized · indexed · row-level secure · ACID · triggers · WAL

    Sheet 01 — database architecture drawn as a circuit board: tables as chips, foreign keys as copper traces
    On the homepage
  2. 02

    The analytics pipeline

    event ingestion · BRIN-indexed · real-time rollups · view time · conversion

    Sheet 02 — analytics pipeline: raw events flowing into a BRIN-indexed table, rolled up every 5 minutes
  3. 03

    Routing & APIs

    typed routes · versioned endpoints · the machine-facing navigation

    Sheet 03 — a versioned, typed route table with one request traced through auth into its handler
  4. 04

    Auth, sessions & payments

    signature-verified webhooks · RLS · idempotency · the ledger

    Sheet 04 — a Stripe webhook checked for signature and idempotency before it ever reaches the ledger
  5. 05

    Servers, workers & observability

    cron · queues · logs · who finds out first when something breaks at 2am

    Sheet 05 — cron and queued workers feeding structured logs, alerting on failure
  6. 06

    Shipping safely

    migrations · backups · CI · preview deploys · rollback

    Sheet 06 — lint, test, build, and preview before every promotion to production, with rollback one switch away