Posts about Advent of Code
How to Solve Advent of Code 2022 Using Postgres - Day 4
Day 4 of AOC we have new hands on SQL for helping the Elves cleaning up camp. Postgres solutions include the function split_part(), the int4range data type, and range operators.
5 min readHow to Solve Advent of Code 2022 Using Postgres - Day 3
Day 3 of AOC we have lots of great SQL for organizing a rucksack. Postgres solutions for this one include functions for length(), left(), right(), regexp_replace(), COLLATE commands, window function lag(), and more.
7 min readHow to Solve Advent of Code 2022 Using Postgres - Day 2
Day 2 of AOC we have sql for transforming raw data into game analysis of paper, rock, scissors. Included is a nice custom function and great examples for IF/ELSE, CTEs, and more.
10 min readHow to Solve Advent of Code 2022 Using Postgres - Day 1
Greg is doing the Advent of Code using PostgreSQL and he is going to share a few of his tricks. Day 1 he uses file_fdw to connect to the text file provided. Along with a couple grouping and sum queries, he has a quick solution for you.
4 min read
