Howdy!
My name is Linh Pham (he/him/they) and I am the person behind the Wait Wait Don't Tell Me! Stats Page. I am also an IT/DevOps Engineer that works on automating and orchestrating applications.
Python is my it thing when it comes to programming or playing around with the data that I've collected over the years from Wait Wait... Don't Tell Me!. I still dabble around in C#, PHP and JavaScript when I have chance to do so. I definitely want to play around with Swift and Go when I have the free cycles.
Also, feel free to checkout my GitHub Gists.
Mastodon: qlp@linh.social | Flickr: questionlp | linhpham.org | blog.linh.social
Wait Wait Stats Page Projects
If you are interested in taking a gander at the code for the Stats Page and its supporting and related components, check out the repos listed below. The projects are published under the terms of Apache License 2.0 (unless otherwise noted in the repo's LICENSE file).
Sites
The current version of the Stats Page, Graphs and Reports web applications are developed in Python and built top of the Flask micro web app framework. The Stats API is developed in Python and built on top of FastAPI.
Library
A Python library was created to query, collect and return data from the Wait Wait Stats database. Package for the library are available on PyPi at: https://pypi.org/project/wwdtm/
Documentation for version 2 of the Stats Library is available at docs.wwdt.me.
Database Schema
The data that I've collected is stored in a MariaDB/MySQL database and I've published the schema for it in its own repo.
Database Export
A Python program has been created to export the contents of each table in the Wait Wait Stats Database as individual JSON files.
Slugify Names
A Python program has been created to generate slug strings for guests, hosts, locations, panelists and scorekeepers, which are used throughout the libraries and applications listed above.
Previous Versions
The following projects have been superceded by newer versions that including some significant structural and/or framework updates
Versions 2 and 3 of the Stats Page were developed in PHP, with version 3 using the now deprecated Silex framework. I've published the code in case anyone is interested at looking at the progression of the Stats Page over the years.