Lien Bosmans·Aug 23One input, two problems, three recursions [AoC with SQL] [2025 Day 10]Day 10 is about pushing buttons. In part 1, each button connects to one or more light bulbs. Part 2 pushed all my buttons.
Lien Bosmans·Jul 23Geospatial shortcutting [AoC with SQL] [2025 Day 9]Coordinates! (Again!) Day 9 keeps it in the 2D plane, so only exes and whys. Today, the coordinates represent tiles.
Lien Bosmans·Jul 21Minimum spanning tree, maximum loading time [AoC with SQL] [2025 Day 8]On the eight day, we grow trees! The input is a bunch of 3D coordinates. The coordinates matter only little.
Lien Bosmans·Jul 16Dark paths require light recursion [AoC with SQL] [2025 Day 7]Time to gear up for some light recursion, because day 7 requires a for loop.
Lien Bosmans·Jul 8Flipping tables [AoC with SQL] [2025 Day 6]Day 6 is all about annoying input parsing. The numbers are space separated (sigh.) You have to combine numbers by column, not by row (why?)
Lien Bosmans·Jul 65 reasons why DuckDB is better than ElfDB [AoC with SQL] [2025 Day 5]On day 5, the elves give us a copy of their database as puzzle input. (Did we accidently choose the right tool for the job?)
Lien Bosmans·Jun 28Things SQL can but probably shouldn’t: moving toilet paper recursively [AoC with SQL] [2025 Day 4]The puzzle input on the fourth day are objects (@) and empty spots (.) organized in a 2D grid.
Lien Bosmans·Jun 27Picking digits the DRY way [AoC with SQL] [2025 Day 3]The puzzle input of day 3 is a bunch of integers. From their digits, we need to pick the ones that, when you put them next to each other...
Lien Bosmans·Jun 27Silly patterns made. Query to find all of them. Left each one unchecked. [AoC with SQL] [2025 Day 2]The second puzzle input of 2025 is a comma separated list of integer ranges (from-to,from-to, …). Our job is to figure out how many...
Lien Bosmans·Jun 26SQL used WINDOW FUNCTION! It was super effective! [AoC with SQL] [2025 Day 1]The first puzzle input of 2025 is a list of instructions, indicating if we need to turn a dial a given number of clicks left or right...
![One input, two problems, three recursions [AoC with SQL] [2025 Day 10]](https://miro.medium.com/v2/resize:fill:160:106/1*8UR7eZr3IxTPOFiUTGYRSQ.png)
![One input, two problems, three recursions [AoC with SQL] [2025 Day 10]](https://miro.medium.com/v2/resize:fill:320:214/1*8UR7eZr3IxTPOFiUTGYRSQ.png)
![Flipping tables [AoC with SQL] [2025 Day 6]](https://miro.medium.com/v2/resize:fill:160:106/1*RvqeJ8lLf51SjznorclLjQ.png)
![Flipping tables [AoC with SQL] [2025 Day 6]](https://miro.medium.com/v2/resize:fill:320:214/1*RvqeJ8lLf51SjznorclLjQ.png)