chess-pipeline
chess-pipeline copied to clipboard
guidopetri
Pulling games from the Lichess API into a PostgreSQL database for data analysis.
It would be easier to handle stockfish analysis in its own luigi `Task`, with depth/fen/SF version parameters.
https://lichess.org/blog/X9PUixUAANCqFRSh/introducing-maia-a-human-like-neural-network-chess-engine Seems like an interesting new engine/approach. Is this useful as a feature somewhere?
Possible thing to look into: run some simple SQL queries and send summary notifications e.g. via Telegram with https://github.com/kha7iq/pingme .
The Lichess API now provides the full PGN in the JSON response to "games from a user" requests. Is this useful? What does the PGN look like exactly? It would...
I can imagine it would be useful to see uneven exchanges in the data - e.g. bishop vs knight (#10), rooks vs queen, rook + minor + pawn vs queen....
Several queries that use the tables (mainly `chess_games`, of course) are extremely slow - they take about 4-6 seconds to run. This can probably be improved via usage of indices,...
How much is a bishop worth, in time units? Sometimes, you can get away with playing a bullet game and blundering your queen away if the opponent only has a...
Some of the example analytics done should probably be added to the repo in a folder somewhere. Maybe some of the graphs too? It could be done in .md files.
A common comment about moves is that they feel "natural", e.g. recapturing pieces or developing pieces in a certain way (maybe I should post some examples of GMs saying this?)....
Metadata
Owner
Metadata
Pulling games from the Lichess API into a PostgreSQL database for data analysis.