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

  • 4 min read

    Timezone Transformation Using Location Data & PostGIS

    Rekha Khandhadia

    Imagine your system captures event data from all over the world but the data all comes in UTC time giving no information about the local timing of an event. How can we quickly convert between the UTC timestamp and local time zone using GPS location? We can quickly solve this problem using PostgreSQL and PostGIS. This example assumes you have a Postgres database running with PostGIS. If you’re new to PostGIS, see PostGIS for Newbies . 1. Timezone Shape file Overview: For World Timezone shape fil...

    Read More
  • 9 min read

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

    Greg Sabino Mullane

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

    Read More
  • 11 min read

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

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 9's challenge "Rope Bridge" 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 clean...

    Read More
  • 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