In June 2022 Ukrainian community of free and open-source developer education Kottans launched their new frontend course. The rules were as usual: the ones who are motivated enough to go through most self study tasks before the specified date — Part 1 — gained access to lectures and code reviews — Part 2. Thus a small number of volunteer teachers could work with 15 to 30 motivated students instead of spreading among 300 (number of students who completed at least one task).
I was such student myself in 2018–19 and had an idea back then: to have a statistics that can show "the state of the race". Finishing of the task is self-reported: you send the task name followed by #done into the group chat. Back then I just downloaded chat history in JSON and wrote few filtering scripts to find relevant messages and extract task names and formed a simple HTML page with static data (can you spot me?):
In 2022 I finally decided to make something more complete. I reached out to a community member responsible for the info bot that is added to community chats and wrote a module that catches #done messages and logs them to a database. Then I wrote a SvelteKit app that forms a table based on this data. Almost 2 000 data points, here it is: