Hacker News new | ask | show | jobs
by spratzt 555 days ago
Extraordinary!

I can’t think of any of the advent of code questions this year where a database would have been of any use.

Do tell us more.

1 comments

It's mostly a challenge I set for myself to see how far I could get using SQL! I've done the past couple years in Python and just wanted to change it up.

So far parsing the inputs has not been nearly as much of a hassle as I thought. I really like how DuckDB supports directly selecting from files (e.g. `select * from 'file.csv'`). I thought I was going to be spending more time creating schemas, running `copy`, etc.

Overall pretty nice quality of life experience so far, even if it is only to mess around with a few puzzles.

You could try participating in Advent of SQL[0]! It's a bit rough around the edges but fun nonetheless. [0] - https://adventofsql.com/