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.