I'm using DuckDB for the first time for this year's Advent of Code and it's been a delightful experience so far. I was looking for something simple to set up and had more advanced functionality than what SQLite supports.
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.
spratzt|1 year ago
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.
thehours|1 year ago
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.