Week notes: Tbilisi, clinched titles, and tables that tell you

As the first week of August rolled around and I embarked on a well deserved two-weeks long vacation in the relatively cooler highlands of Tbilisi, Georgia and its rocky beaches, I turned my attention to the finer points of clearly communicating the drama that unfolds towards the end of a football season. I'd been running the staging environment for about 11 weeks and there were only a few league matches left.

A quick look around some of the activated leagues and countries showed that there were league groups where the champions were already known, and the same could be said for the teams that would be relegated. None of that was obvious from glancing at the table though. You had to sit down and do the arithmetic yourself, which is not the kind of homework a manager should be doing on my behalf. So this also opened the door to correctly communicating to managers the results of their league season - alerting the incoming champions the moment it became mathematically confirmed and also letting relegated teams know of their fate.

Managers now get a message the moment their league campaign is mathematically confirmed and also at the end of the season. While working on this, I realized that some of the aggregated queries that were used to compute league standings needed fixing.

I also worked on ensuring that data-grids in the game (powered by AgGrid) had the right pagination controls as well as filters and sorting that created a unified feel throughout the game. On the admin side, I added knobs and controls for toggling email notifications and deciding if we wanted to use LLMs to enrich certain messages.

Till next time,

Oladapo.