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

  • 8 min read

    pgAdmin for All of Your Postgres Kubernetes Clusters

    Ben Blattberg

    We recently announced the latest update of Crunchy Postgres for Kubernetes 5.5 . In this version 5.5 update, we would like to highlight a key feature: the introduction of a new pgAdmin API. The notable changes in this feature include: • The ability to manage all Postgres clusters through a single interface • Automatic cluster detection • A new custom resource file for pgAdmin The ability to manage all Postgres clusters through a single interface Automatic cluster detection A new custom resource...

    Read More
  • Use Github Actions on Pull Requests to Automate Postgres on Crunchy Bridge

    Christopher Winslett

    Automating pull requests to deploy staging applications is a game changer for large teams performing shipping quality products. Using Crunchy Bridge ’s CLI or API, you can easily automate the entire process for these staging deployments. The simplest workflow would look something like the following: In this example, during the “Create Postgres Cluster”, we’ll create a hobby-0 cluster for Postgres. Then, when the PR is closed the cluster will be torn down. We keep it simple for this example, bu...

    Read More
  • 6 min read

    PostGIS Day 2023 Summary

    Elizabeth Christensen

    We hosted our annual PostGIS day a couple weeks ago with some great talks on a big variety of topics within open-source GIS. Here is a summary of the themes I saw take shape across the day’s events that will point you towards the recordings, depending on your interests. A full playlist of PostGIS Day 2023 is available on our YouTube channel. If you’ve spent time with developers this year you know that folks love to tell you the details and reasoning behind their tech stack and the GIS communit...

    Read More
  • 5 min read

    Announcing Crunchy Postgres for Kubernetes 5.5

    Andrew L'Ecuyer

    We're excited to announce the release of Crunchy Postgres for Kubernetes 5.5. Included in this release are great updates to database administration, monitoring, connection pooling and more. Specific highlights include: • An updated pgAdmin experience, including the ability to deploy one pgAdmin for use with multiple Postgres clusters • Easier installation of the metrics and monitoring tools, along with the added ability to monitor standby clusters • Updates to PgBouncer including support for pre...

    Read More
  • 8 min read

    Advent of Code in PostgreSQL: Tips and Tricks from 2022

    Greg Sabino Mullane

    I’ve nearly finished solving the 2022 series in Advent of Code in PostgreSQL on our blog, many of these are available on our browser based Postgres playground as well. As many of you embark on your own Advent of Code adventures for 2023 this week, or maybe watch from afar, I wanted to pull together some themes, recommendations, tips, and tricks that I’ve seen work with the solutions. If there’s anything I’ve learned, it’s that you can solve almost anything with PostgreSQL! Before you do anyt...

    Read More
  • 25 min read

    Fun with Postgres ASCII Map and Cardinal Directions

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 23's challenge "Unstable Diffusion" 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. Tech used in this Day: • The file_fdw Foreign Data Wrapper • Materialized (and not materialized) CTEs aka Common Table Expressions • Custom data types • Various handy functions like string_to_table and array_agg and unnest • Tweaking the plan_...

    Read More
  • 21 min read

    Fun with Postgres Text File Mazes, Charts, and Routes

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 22's challenge "Monkey Map" 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. Tech used: • The file_fdw extension to read the input • Unlogged tables • Sequences • Building and modifying arrays via regexp_split_to_array and array_remove • More ASCII animation! The file_fdw extension to read the input Unlogged tables Sequences Bui...

    Read More
  • 8 min read

    Fun with Postgres Looped Functions and Linear Progressions

    Greg Sabino Mullane

    This article will contain spoilers both on how I solved 2022 Day 21's challenge "Monkey Math" 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. Tech used: • The file_fdw extension to read the input • Functions such as regexp_substr • Unlogged tables The file_fdw extension to read the input Functions such as regexp_substr Unlogged tables As always, we will use file_fdw to put our text input into...

    Read More
  • Postgres + Citus + Partman, Your IoT Database

    Craig Kerstiens

    Postgres is a robust data platform . Yes, it's more than a boring old relational database. It has rich indexing, data types (including JSON ), and so much more. It also has support for a variety of extensions that can further broaden it's already great functionality. Two of those extensions when coupled together make Postgres a very compelling approach for IoT architectures. Today we're going to start from the ground up on how you would design your architecture with Postgres along with the Ci...

    Read More
  • Designing Your Postgres Database for Multi-tenancy

    Craig Kerstiens

    If you're building a B2B app chances are it's multi-tenant, meaning one customer data is separated and doesn't intermingle with other customer data. When building the app itself you'll typically have some URL route defining the specific tenant. When it comes to your database there are a number of design patterns that you can use that offer different advantages, trade-offs, and scaling opportunities. When you begin building your app, time to market is essential, but you don't want to make decisio...

    Read More