A Lo Cubano Boulder Fest is a Cuban salsa festival in Boulder, Colorado. I built the festival website and the system behind it: online ticket sales, Stripe and PayPal checkout, QR-code tickets with Apple and Google wallet passes, door check-in, ticket transfer, email, and an admin dashboard for the organizers.
The system runs on Vercel with a Turso (libSQL) database. The 2026 edition ran May 15 to 17, 2026.
Events and ticket types live in a versioned config file that the build loads into the database, and the build also applies the SQL migrations. A cart holds inventory while the buyer pays, through Stripe Checkout or a PayPal order, and checkout validates promo codes. Each ticket gets a TKT-prefixed ID and a signed QR token, and wallet passes come from passkit-generator for Apple Wallet and the Google Wallet REST API.
Brevo sends the order and ticket emails and holds the newsletter lists. Failed sends go to a retry queue that a scheduled job drains, and a Brevo webhook records delivery, bounce and unsubscribe events for newsletter subscribers. At the door, a camera page scans the QR code and the validate endpoint allows one scan per ticket. The admin console signs in with a password and a TOTP code and covers refunds, transfers, manual entry, bulk import and audit logs. Six Vercel Cron jobs handle reservation cleanup, event status, email retry, email delivery monitoring and log retention.