What it does
Manages prize drawings during the event. Syncs prize inventory from a MySQL database managed by the website team, runs drawings through D1, and writes winners back to MySQL on finalization. Invalidates KV cache entries so display kiosks update in near real-time.
FCC data enrichment
When a winner is drawn, the system looks up their amateur radio callsign in the FCC ULS database to pull name and location data, reducing manual data entry and errors during fast-paced live drawings.
Technical details
- Cloudflare Workers API for drawing logic and prize management
- D1 for drawing state and winner records
- MySQL sync for prize inventory (read) and winner data (write-back)
- KV cache invalidation triggers near-real-time kiosk updates
- FCC ULS callsign lookup for winner data enrichment
- Audit trail for every drawing action