track 03 · System design

PicknPay: an event-sourced order model

A solo full-stack e-commerce monorepo (Turbo and pnpm, React 19, Express) built around an 11-table event-sourced Postgres schema with order and address snapshots and OTP-verified delivery.

ShippedReact 19ExpressTurborepoPostgreSQLEvent sourcing

What it does

  • An 11-table event-sourced relational schema: orders are a history of events, not a mutable row.
  • Order and address snapshots so a past order stays correct when a customer later edits their address.
  • OTP-verified delivery and background jobs.

Caveat. Private repository, so there is no public link. Happy to walk through the schema in conversation.