LapLytics

Inspiration

Race teams and enthusiasts lacked easy tools for importing, visualizing, and analyzing complex race data. Official results, lap times, and telemetry were all trapped in giant CSVs—with insights buried under manual processing. I wanted to make racing data analysis instant, visual, and useful for everyone.

What it does

Laplytics lets users upload a full suite of race CSV files—results, lap times, sections, telemetry—and automatically transforms them into interactive dashboards, insightful charts, and driver comparisons. You get instant visibility into trends, outliers, driver performance, and lap analytics with no manual Excel work.

How we built it

Backend is in Python (FastAPI, DuckDB, Polars) to handle massive CSV files and perform fast, scalable data processing. On the frontend, React, shadcn/ui, and Recharts are used to deliver a modern, intuitive dashboard experience. Vite powers the build; Tailwind makes styling snappy and consistent. Everything is designed for high-speed multi-file ingest and real-time chart updates.

Challenges we ran into

Handling huge telemetry files—millions of rows—without slowdowns

Data cleaning especially because most datasets are not normalized or uniform

Getting browser cookie/auth setup right for secure data uploads

Ensuring clean separation of user sessions and dashboard state

Accomplishments that we're proud of

Interactive comparison charts and trendlines for drivers and laps

User-friendly UI responding instantly to uploads, filters, and metric changes

Solving those gnarly CORS and CSS config headaches for a flawless deploy!

What we learned

How to best use DuckDB and Polars for real-time dataframes in web apps

Advanced React patterns for dashboard interactivity

Cookie management for secure, cross-origin web applications

The importance of a clean config and build pipeline for production

What's next for Track data analysis

Add cloud-based team dashboards and result sharing

Real-time streaming analysis for live telemetry

Deeper lap breakdowns (sector, tire, weather impact)

Expand support to more motorsport formats and custom user metrics

Built With

• duckdb
• fastapi
• javascript
• python
• react