Advent Of Code 2020

I just completed #AdventOfCode in #SQL – Day 11 – “Seating System”

Game of Life implementation with the help of the MODEL clause and also in PL/SQL, showing the limits of SQL

I just completed #AdventOfCode in #SQL – Day 10 – “Adapter Array”

WHAT THE SITH DID I JUST DO IN PLAIN SQL?

I just completed #AdventOfCode in #SQL – Day 9 – “Encoding Error”

Who said you HAD to use a set-based approach when writing SQL?
Part 2 shows that we *can* implement complex recursive algorithms if we want.

I just completed #AdventOfCode in #SQL – Day 8 – “Handheld Halting”

Did you ever debug an infinite loop of a simple command-based program with the help of SQL? Very, very fun!

I just completed #AdventOfCode in #SQL – Day 7 – “Handy Haversacks”

It’s all about recursive subqueries today, one of the most important elements to make SQL turing complete.

I just completed #AdventOfCode in #SQL – Day 6 – “Custom Customs”

Window functions are so powerful – and sometimes a good bit of baseline data can make your SQL pretty efficient.

I just completed #AdventOfCode in #SQL – Day 5 – “Binary Boarding”

Binary sequences are fun, too bad Oracle doesn’t provide a convenient function to convert them.
Also: LAG and LEAD are your friends!

I just completed “Passport Processing” – Day 4 – #AdventOfCode 2020 in #SQL

It’s all about how you get from unstructured to structured data

I’ve completed “Toboggan Trajectory” – Day 3 – #AdventOfCode 2020 in SQL.
Recursive Subqueries and PIVOT for the win!

I just completed “Password Philosophy” – Day 2 – #AdventOfCode 2020 in pure #SQL