Introducing Crunchy Data Warehouse: A next-generation Postgres-native data warehouse. Crunchy Data Warehouse Learn more

Latest posts from Greg Sabino Mullane

  • 8 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 13

    Greg Sabino Mullane

    Disclaimer

    This article will contain spoilers both on how I solved 2022 Day 13's challenge "Distress Signal" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More
  • 7 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 12

    Greg Sabino Mullane

    Spoiler Alert!

    This article will contain spoilers both on how I solved 2022 Day 12's challenge "Hill Climbing Algorithm" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More
  • 13 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 11

    Greg Sabino Mullane

    Spoiler Alert

    This article will contain spoilers both on how I solved 2022 Day 11's challenge "Monkey in the Middle" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More
  • 9 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 10

    Greg Sabino Mullane

    Spoiler Alert

    This article will contain spoilers both on how I solved 2022 Day 10's challenge "Cathode-Ray Tube" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More
  • 11 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 9

    Greg Sabino Mullane

    aoc2022 day8 snakegrid

    Spoiler Alert!

    This article will contain spoilers both on how I solved 2022 Day 9's challenge "Rope Bridge"

    Read More
  • 8 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 8

    Greg Sabino Mullane

    Spoiler Alert!

    This article will contain spoilers both on how I solved 2022 Day 8's challenge "Treetop Tree House" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More
  • 13 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 7

    Greg Sabino Mullane

    Spoiler Alert

    This article will contain spoilers both on how I solved 2022 Day 7's challenge "No Space Left On Device" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More
  • 5 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 6

    Greg Sabino Mullane

    Spoiler Alert

    This article will contain spoilers both on how I solved 2022 Day 6's challenge "Tuning Trouble" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More
  • 13 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 5

    Greg Sabino Mullane

    cargotable_moving

    Spoiler Alert!

    This article will contain spoilers both on how I solved 2022 Day 5's challenge "Supply Stacks"

    Read More
  • 5 min read

    How to Solve Advent of Code 2022 Using Postgres - Day 4

    Greg Sabino Mullane

    Spoiler Alert!

    This article will contain spoilers both on how I solved 2022 Day 4's challenge "Camp Cleanup" using SQL, as well as general ideas on how to approach the problem. I recommend trying to solve it yourself first, using your favorite language. This article is delayed from the actual puzzle's release. Also note that my solutions are seldom going to be the "best" solutions - they were solved as quickly as possible, and these articles will show my first solutions, with some minor reformatting and cleaning up.

    Hands on Tutorial

    Read More