Post

Silly me. Turns our Advent of Code challenges have two parts in them, and who knew, the second part is harder 🙈 I went back and implemented the second part of the second day challenge. This might be interesting to you regardless of EdgeQL, read if you like math or SQL too. 🧵

First, the challenge: adventofcode.com/2024/day/2 TL;DR: a bunch of numbers in text. Every line of numbers is a "record". How many records are ordered with elements differ only by 1, 2, or 3? A record is also fine if it satisfies these rules without one of its elements. 😱

Let's break this scary (no so!) query apart. First, split the incoming string into an array of strings/lines and convert it into a set:

Then we want to just parse the records into arrays of integers -- so much easier to work with!

Now the sweet part, time to test every record we prepared against the "good record" requirements:

But remember, we just need to find if there's ONE way for a record to satisfy the rules:

Tying it all together, finally: