On: Advent of Code 2024

[shawn_w]

I've solved some days in past years with sqlite + enough awk to transform the input into something that can be imported into a table. It can be a fun challenge.

[lyxell → shawn_w]

I’m allowing myself to convert the data to a csv and read it using ’.mode csv’.

I realized when solving todays problem that SQLite’s

  json_each("[" || T.c1 || "]")

Is useful for parsing comma separated rows into (row, col)-pairs as well.