Elkhorn Top Dogs
A production web platform for a Special Olympics Nebraska delegation, combining a public site, a members-only portal, and an admin console for running the club.
- React
- JavaScript
- Vite
- Supabase
- Postgres
- Vercel
Project overview
Elkhorn Top Dogs is a Special Olympics Nebraska delegation with the goal of bringing more teams to the Elkhorn area. It serves athletes, partners, volunteers, and families across six sports plus a monthly social club, and it was being run out of spreadsheets, Facebook posts, and email chains.
I offered to create a replacement for the existing systems. The result is three applications in one codebase: a public marketing site, a members-only portal gated behind admin-approved accounts, and an admin console the club's leadership uses to run day-to-day operations.
With 70+ active users, the site has become the central hub for all communication and coordination across the delegation.
Technical features
- Live content updatesPostgres change subscriptions across six tables, pushing an admin edit to every open browser in real time without a refresh.
- Fully self-managed contentInline editing of events, fundraisers, forms, sport descriptions, photos, and the calendar on the live site, with no separate CMS and no developer needed to keep it current.
- Secured database designEleven tables under Row Level Security with roughly 50 policies separating owners, members, admins, and the public, and business rules enforced as constraints rather than client-side checks.
- Complete administrative dashboardSeven-tab console covering account approval, family lookup, email distribution lists, jersey inventory, event scheduling, site content, and member birthdays.