05 case studies ยท all running in production
Work
Each one is live and run by me. Each covers the problem, how it's built, what was hard, and what it does today.
WARN Index
US layoff notices from 47 states and DC in one searchable place. When a state's site changes and a scraper breaks, an agent reproduces it and opens the fix as a pull request.
34scraper breaks fixed by reviewed PR
Live
- Python
- Playwright
- PostgreSQL
K3s homelab platform
A small production platform in a closet. GitOps with Flux, a review app for every pull request, managed Postgres, and full observability.
1,300merged pull requests
Live
- Kubernetes
- K3s
- Flux
Flock camera map
A map of 336,000 Flock Safety surveillance devices and license plate readers that doesn't track the people looking at it.
336Kdevices mapped
Live
- MapLibre
- PMTiles
- tippecanoe
r12d
Privacy-first QR stickers, short links, a photo inventory and lost-and-found for households and small businesses.
1stored row per code per day, not per scan
Live
- Django
- PostgreSQL
- S3
Restroom QR ad network
Venues put QR stickers in their restrooms, patrons scan them, and ad revenue is split across venues by traffic.
10ratings before a venue ranks
Live
- Django
- PostgreSQL
- ntfy
Before this
Employer work at Zonar Systems
- more traffic after moving legacy customers onto cloud microservices
- 417x
- cut in SQL query times
- 96%
- ARR no longer at risk after fixing config bugs in a legacy C++ codebase
- $6M