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, wrote some SQL scripts on top of it, and this is the result. I'm embarrassed to admit this version of the website is far better than the original both in terms of performance and user experience, but I had the benefit of 15 years of experience under my belt this time around. I hope you enjoy the site - reach out to me if you'd like to say hi.