News for hackers. Stuff that matters.

A comment on Advent of Code 2024. Parent comment

Re:Advent of Code 2024 by shawn_w on Sunday December 01, 2024 @10:59PM (#42292981)
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.
[ Parent | on HN ]
Re:Advent of Code 2024 by lyxell on Monday December 02, 2024 @03:10AM (#42294129)
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.
[ Parent | on HN ]