After taking over the role of PAPO OY statistician, in 2021, Ryan started developing a new OY points system to account for the new OY rules for that year. The new system was designed to calculate points automatically as opposed to manually having to update the points in a spreadsheet, and also had a web interface so that points could be viewed throughout the year to promote more competition.

The first iteration was a Python script tied to a SQL database which would import the results and calculate the points. This was connected to a simple client side react app which displayed the points and some basic statistics.

This system worked but was quite slow at calculating points, so it was rewritten from the ground up last year using Next.js and using SQL views for points calculation. While this was being done, there was interest for the scope of the project to expand to other leaderboard based competitions, firstly the Nelson OY series and then NOL/NSL points, so the data was restructured to allow this to happen.

The new website makes use of static generation so is much faster but still contains dynamic statistics and leaderboards. You can find it here.

Future plans are to integrate the backend with O-Zone to allow for even faster turnaround after an event is finished, calculating as soon as results are uploaded. Additionally there is opportunity to add more options and more granularity on the statistics pages.