Crunchy Data joins Snowflake.  Read the announcement

  • 8 min read

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

    Greg Sabino Mullane

    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 an...

    Read More
  • 3 min read

    Crunchy Postgres for Kubernetes 5.3 Release

    Greg Nokes

    We are excited to announce the release of  Crunchy Postgres for Kubernetes version 5.3 . We have been hard at work on a lot of new features that we cannot wait to get into your hands. You can get started on version 5.3 from our  Developer Portal or the  getting started tutorial . We have decided to highlight a few of our favorite new features and changes today. With the latest release of Crunchy Postgres for Kubernetes, we are excited to now natively support Postgres 15. Please note that Times...

    Read More
  • 13 min read

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

    Greg Sabino Mullane

    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 reformatti...

    Read More
  • 5 min read

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

    Greg Sabino Mullane

    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 cl...

    Read More
  • 14 min read

    Log Export Examples Using Crunchy Postgres for Kubernetes

    Bob Pacheco

    Many applications running on Kubernetes will send their output to standard error ( ) and standard out ( ). This is a convenient location for log aggregators to collect and consolidate logs. However, some applications like Postgres write their logs to disk so getting the Postgres logs to the log aggregator requires a few special tricks. Crunchy Postgres for Kubernetes recently introduced support for sidecar containers for both Postgres and PgBouncer pods. A sidecar is a container that runs alo...

    Read More
  • 13 min read

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

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 5's challenge "Supply Stacks" 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 cle...

    Read More
  • 5 min read

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

    Greg Sabino Mullane

    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 clea...

    Read More
  • 3 min read

    Postgres + Tailscale – A database you can trust with a simple VPN

    Craig Kerstiens

    If you are like us, Tailscale was an obvious tool to add to our network — as soon as we saw it, we knew we needed it. For those who haven’t tried Tailscale yet, it’s best described as a programmable, re-sizeable, distributed private network mesh. Yes, it’s that great. The better part is that Tailscale is fairly simple, and because it’s simple, it is easy to get correct. When we set out to build Crunchy Bridge we wanted to ensure you could build safely from day one. This included features suc...

    Read More
  • 7 min read

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

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 3's challenge "Rucksack Reorganization" 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 reformatti...

    Read More
  • 10 min read

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

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 2's challenge " Rock Paper Scissors " 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 a...

    Read More