logiqx.github.io

World Cube Association (WCA)

Projects relating to the World Cube Association (WCA), plus the Senior Rankings that I created and maintain.

Rankings

wca-ipy

Project to produce (un)official rankings for the senior cubing community from official WCA results.

Frequent updates are initiated by Jenkins and the mobile-friendly senior rankings are hosted by GitHub Pages.

Docker + Jenkins + Python + SQL, GNU General Public License v3.0

wca-ipy-www

This project is used for the live website and is updated automatically by Jenkins (running in AWS) throughout the day.

Frequent updates are initiated by Jenkins and the mobile-friendly senior rankings are hosted by GitHub Pages.

HTML + JavaScript + CSS, GNU General Public License v3.0

Competitions

scw-comp

Python project for the weekly competition of Senior Cubers Worldwide.

Results and profiles are converted from Markdown to HTML, resulting in a simple website hosted by GitHub pages.

Docker + Python, GNU General Public License v3.0

Database

wca-db

This project includes a number of scripts to download and optimise the WCA results export.

It is used by the senior rankings and for other statistical projects using the WCA database.

Docker + Jenkins + MariaDB + SQL, GNU General Public License v3.0

wca-stats

This project contains a collection of statistics produced from WCA database via SQL queries.

The majority of these queries were created in response to requests in the Facebook group WCA Statistics.

SQL, GNU General Public License v3.0

wca-spv

The project name “wca-spv” is an abbreviation of “World Cube Association - Single Person View”.

This project was used for some ad-hoc data exploration within the WCA database.

SQL, GNU General Public License v3.0

Web

worldcubeassociation.org

This repository contains all of the code that runs on worldcubeassociation.org, forked from thewca/worldcubeassociation.org.

I have made a couple of small tweaks to the results processing which are now in the main project.

Ruby, GNU General Public License v3.0