pochmann/wca-data-tools

Tools for working with WCA data, e.g., auto-updating a local database using the WCA export and creating statistics. Not an official WCA tool.

WCA Data Tools

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.