https://lichess.org/@/ProgramFOX/blogProgramFOX's Blog2026-02-01T13:13:00.792Zhttps://lichess.org/@/ProgramFOX/blog/aix-efficiently-storing-and-querying-chess-game-collections/7wVZlqIX2026-02-01T13:13:00.792Z2026-02-01T13:13:00.792ZAix: Efficiently storing and querying chess game collections<img class="ublog-post-image" width="880" height="550" src="https://image.lichess1.org/display?fmt=webp&amp;h=550&amp;op=thumbnail&amp;path=0FtpcDQPsHc6.webp&amp;w=880&amp;sig=49a63a346429571de34303358e39c563c307fdfe" /><br />The Lichess database contains over 7 billion chess games played on Lichess. To make it easier to query these games, I have released the open-source Aix extension for DuckDB and the accompanying Aix-compatible Lichess database.ProgramFOX