I.
Summary
Overview
A unified operations hub for Longhorn Sim Racing that replaced scattered spreadsheets and manual workflows with structured registration, officer-facing admin tools, and automated results processing — built as the system of record for membership, events, race competitions, content, and merchandise across the whole club.
II.
Breakdown
Highlights
- I.Single self-serve platform for membership, events, race competitions, content, and merchandise — used day-to-day by the whole club.
- II.Race-condition-safe event registration with Postgres FOR UPDATE row locks and automatic FIFO waitlist promotion.
- III.Automated results ingestion feeds driver statistics, leaderboards, and season standings out of a League → Season → Round → Session data model.
III.
Margin
Notes
- §Architected and shipped the platform end-to-end as a pnpm + Turborepo monorepo: Next.js 16 App Router with React Server Components, Prisma on PostgreSQL via Supabase, Supabase Auth with just-in-time user provisioning.
- §Role-based authorization across six roles (member, competition, officer, president, alumni, admin) backed by an email-allowlist bypass for admin seeding and a typed authz helper layer (`isAdmin()`, `requireAdmin()`).
- §Event registration with database-level FOR UPDATE locking to prevent capacity race conditions, a FIFO waitlist with automatic promotion on cancellations, and officer-facing admin tooling for attendance, approvals, and audit logging.
- §League → Season → Round → Session → Entry → Result data model, with automated race-results ingestion and computation pipelines powering driver statistics, leaderboards, and season standings.
- §Content layer (news posts, CMS pages) and a club merchandise storefront running under the same unified auth + role system.
- §Engineering workflow ownership: monorepo tooling (pnpm + Turborepo), Dockerized local Supabase stack, PR-gated CI (lint / typecheck / build), and the CODEOWNERS-enforced Digital Platforms review flow.
By the numbers
100+
drivers
50+
events
99.9%
uptime
Other work
In Development · 2024 — Present
Formula SAE EV Telemetry System
Distributed Real-Time Vehicle Telemetry & Analytics Platform
Next.js · TypeScript · Python
In Development · 2025 — Present
In-Vehicle Driver Dash System
Real-Time Driver Display for Vehicle State, Timing, and Energy Data
Real-Time Systems · WebSockets · HMI
In Development · 2026 — Present
Longhorn Racing Autonomous Platform
FSAE driverless simulation + control stack for Longhorn Racing's autonomous program.
ROS 2 · Python · Gazebo