Archive
Architecture, workflow, and implementation decisions from projects I have designed and shipped.
Operations / CRM
Structured capture, AI qualification, routing, and review
A lead intake workflow that turns inbound inquiries into scored, routed, and reviewable operating records.
Guided discovery
Tag-driven product matching for a liquor and smoke shop
A rule-driven product discovery tool that replaces endless-shelf browsing with a department → type → mode flow backed by product_tags in Supabase.
Operations surface
One operator, one interface, the whole shop
A Next.js-based admin layered over the Supabase schema: catalog management, merchandising, order fulfillment with Realtime, CSV inventory sync, and a contact inbox.
Data architecture
Department → type → subtype, modeled for a catalog that does not sit still
The product schema behind Beaver Trap: a hierarchical classification that survives monthly vocabulary changes without losing referential integrity.
Security / platform
RLS, storage, and auth for a single-repo storefront + admin
The Supabase side of Beaver Trap: Postgres schema, Row-Level Security, a public image bucket, Realtime on orders, and an explicit service-role boundary at checkout.