So far produces statistics from WCA data for speedsolving.com forum posts. Automatically updates a local database using the WCA export. Not an official WCA tool.
You write queries in *.in
textfiles and the tool runs them and produces *.out
textfiles that contain the results nicely formatted and documented, ready to copy&paste into the forum. Some examples in this repository were posted here: Female Podiums, Average 3x3 time by year, FMC statistics per year.
What you need and where to get it (if you don't have it already):
- Python 3 (to run the tool)
- MySQL Community Server (to hold the WCA export data)
- A database and user, see the settings section at the start of the tool.
- MySQL Connector/Python (so Python can access the database)
There's a speedsolving.com thread about it.