This website serves as a historical archive for the Erie Adult Hockey League (EAHL) that existed in Erie, Pennsylvania from 2014 to 2018. The league was run by Dave Hinz, and we played many games at the Ice Center of Erie on 38th and McClelland (RIP). During that time, I created a web application to manage teams, players, registrations, schedules, standings, and statistics. Although the league no longer exists, I never took the website down or deleted the database.

The old website is a crusty .NET Framework 4 application running on Azure and SQL Server. Modernizing the codebase would have been a large effort. Since new data is no longer being entered into the site, I had the idea to create read-only views into the database and improve the UX of exploring teams, players, games, and statistics.

Over a few evenings, I converted the Azure SQL database to SQLite and wrote some SQL scripts on top of it. Since the data never changes, every page is now generated ahead of time with Astro and served as a plain static site from Cloudflare - no server or database involved when you visit. Even the player search runs right in your browser. I hope you enjoy the site - reach out to me if you'd like to say hi.