See Advent of Code website for puzzle descriptions.
Solutions with DuckDB SQL:
- Day 01: Secret Entrance
- Day 02: Gift Shop
- Day 03: Lobby
- Day 04: Printing Department
- Day 05: Cafeteria
- Day 06: Trash Compactor
- Day 07: Laboratories
- Day 08: Playground
- Day 09: Movie Theater
- Day 10: Factory
- Reddit post that inspired solution for part 2: [2025 Day 10 (Part 2)] Bifurcate your way to victory!
- Day 11: Factory
- Day 12: Christmas Tree Farm
Articles that explain the solution:
- Should you solve programming puzzles with SQL? (Wrong question!) Could you? (YES!!) [AoC 2025]
- SQL used WINDOW FUNCTION! It was super effective! [AoC with SQL] [2025 Day 1]
- Silly patterns made / Query to find all of them / Leave each one unchecked [AoC with SQL] [2025 Day 2]
- Picking digits the DRY way [AoC with SQL] [2025 Day 3]
- Things SQL can but probably shouldn't: moving toilet paper recursively [AoC with SQL] [2025 Day 4]
- 5 reasons why DuckDB is better than ElfDB [AoC with SQL] [2025 Day 5]
- Flipping tables [AoC with SQL] [2025 Day 6]
- Dark paths require light recursion [AoC with SQL] [2025 Day 7]
- Minimum spanning tree, maximum loading time [AoC with SQL] [2025 Day 8]
- Geospatial shortcutting [AoC with SQL] [2025 Day 9]