Day 6 of #adventofcode solutions using #python

Not sure if today's challenge is solvable with SQL.

You can find the solution here github.com/ifoukarakis/...

Huh, part 2 done as well!

Instead of using a recursive CTE to implement topological sort, simply counting numbers of pages that need to go before current did the trick.

github.com/ifoukarakis/...

Day 5 of #adventofcode solutions using #python and #duckdb

Only part 1 using DuckDB. Something's off with topological sorting.

You can find the solutions here: github.com/ifoukarakis/...

Day 4 of #adventofcode solutions using #python and #duckdb.

SQL felt easier to implement than Python!

You can find the solutions here: github.com/ifoukarakis/...

There is a typo, it's actually day 3.

Day 2 of #adventofcode solutions using #python and #duckdb.

Regex and `QUALIFY` did the trick!

github.com/ifoukarakis/...

#sql part had an interesting challenge: build all possible sublists of a list of rows by removing a single item. Self-CROSS JOIN did the trick!

Day 2 of #adventofcode solutions using #python and #duckdb

github.com/ifoukarakis/...

Day 1 of #adventofcode solutions using #python and #duckdb.

github.com/ifoukarakis/...

Let's try something different for #adventofcode. I'll try to implement the solutions using #duckdb.

GitHub - ifoukarakis/advent-of-code-2024: Solutions to Advent of Code 2024 Solutions to Advent of Code 2024. Contribute to ifoukarakis/advent-of-code-2024 development by creating an account on GitHub.

Last time I attempted #adventofcode was 2020. Let's try again. In the (unlikely) case anyone's interested to tag along, here's my solutions github.com/ifoukarakis/...

a record is being played on a turntable with a swirl on it ALT: a record is being played on a turntable with a swirl on it

TIL there's no emoji for vinyls.

All right, let's do this one last time!