Index
Selected systems
Six case studies, each written from the repository rather than from memory. Where a project cannot be shown publicly, that is stated plainly instead of dressed up.
- 01PeopleOSHR, attendance and statutory payroll for ~300 peopleTypeScriptNext.js 16React 19PostgreSQLPrisma 6decimal.js2026 · Systems & Platforms
- 02Ads Review AutomationA deterministic rules engine with an LLM allowed only to explain itPython 3pandasMeta Marketing API v25OpenAI APIgpt-4o-minigspread2026 · AI & Automation
- 03Slow Seller Decision EngineA recommendation per style, and a spreadsheet it cannot damageTypeScriptNext.js 15React 19Tailwind CSS 3Radix UIZod2025 · Decision Systems
- 04Order Export for Production PlanningRemoving the developer from a routine data requestPython 3.12FastAPIPydantic v2httpxtenacityJinja22026 · Internal Tools
- 05Seasonal Catalog Media Pipeline~1,000 images, 165 products, and no click-by-click afternoonPython 3.14Standard library onlyWordPress REST APIAdvanced Custom FieldsApplication PasswordsCSV2026 · AI & Automation
- 06Agent Session ObservabilityWatching a dozen AI coding sessions without tabbing through windowsNode.js 22 (ESM)Electron 34Server-Sent Eventsnode:fs streamsJSONL stream parsingVanilla JavaScript2026 · Developer Tooling
Also built
Sheets-Native Attendance System
A Google Apps Script system that turns a shared spreadsheet into a per-employee-permissioned, audit-logged timekeeping app — real range protections generated per row, cross-midnight shift handling, and a monthly payroll recap generated rather than re-typed.
Apps ScriptGoogle Sheets APIclaspHtmlService
Bridge — Local-First Work Tracker
A single-user offline project tracker built around one question: what is the next action, and if there isn't one, why not. Stalled work is made to look wrong rather than blank, and a project cannot be marked shipped until five handover items are ticked.
Next.js 15SQLiteDrizzleZod