Chess Analysis Application - BigQuery + Cloud Run Deployment

[Filpill]

Hi all,

Just wrapping up a chess analysis application I’ve deployed to GCP using Cloud Run.

My application is publicly accessible at the following URL:

Dash

I’m using the chess.com API and I wanted to get an idea of what openings people were playing on the platform (at the top ELO brackets).

The data is modeled into BigQuery tables and uses a live connection to query data into the Dash app.

Dozens of opening variations exist per “opening type” and there are thousands of unique openings in total. Therefore, I’ve used a mapping table to group similarly named openings together to make it easier to parse through the data.

Please feel free to have a click around the dashboard.

If there is any feedback on the design or datapoints which would further enrich this analysis, it would be much appreciated

[Yusuf]

This is impressive Flip. Can you share the code

[Filpill]

Yeah can do, all the code is here: chess_analysis/dash/chess_app/main.py at main · Filpill/chess_analysis · GitHub

Feel free to have a look around.

[AnnMarieW]

Hi @Filpill

Thanks for sharing the link to your GitHub. The README.md is fantastic!

Great description of the project structure and how you build the backend.

I encourage everyone to check it out – here’s a preview of just one of the sections:

[Yusuf]

Yes many thanks Filpill