4 ms·
As every year, I try to solve it with 1 sql statement for every challenge, https://gitlab.com/feike/adventofcode/-/tree/master/2024 https://gitlab.com/feike/adv
by feike 2y ago
As every year, I try to solve it with 1 sql statement for every challenge,
https://gitlab.com/feike/adventofcode/-/tree/master/2024 https://gitlab.com/feike/adventofcode/-/tree/master/2024, likely going to get stuck again around day 12/13 or so!
- lyxell 2y agoAwesome! Thanks for sharing. It feels good to have some company in this, I will follow your progress! I created a repo for my solutions here: https://github.com/lyxell/aoc2024-sqlite https://github.com/lyxell/aoc2024-sqlite Update: Wow. Reading your solutions was a real eye-opener for me. It never struck me that one can exploit the fact that unmaterialized CTE's will not be evaluated for rows that is not needed by another SELECT and one can use this the same way one uses laziness in Haskell. This is great stuff, thanks again for sharing!
- deleted 2y ago[deleted]