Crunchy Data joins Snowflake. Read the announcement
Marco Slot
Marco Slot
I've always found distributed systems to be the most fascinating branch of computer science. I think the reason is that distributed systems are subject to the rules of the physical world just like we are. Things are never perfect, you cannot get everything you want, you’re always limited by physics, and often by economics, or by who you can communicate with. Many problems in distributed systems simply do not have a clean solution, instead there are different trade-offs you can make. While at Cit...
Read MoreElizabeth Christensen
Elizabeth Christensen
If you’ve ever dug under the hood of Postgres a bit, you’ve probably heard about the page. This is the on-disk storage mechanism and it's limited to an 8kb size. But what happens when you have data bigger than that 8kb? TOAST is made. Postgres TOASTs data by splitting it up into smaller chunks. TOAST stands for The Oversized Attribute Storage Technique. TOAST happens automatically, you don’t set up anything, it just comes with Postgres out of the box. So why should you care? Well TOAST can impac...
Read MoreChristopher Winslett
Christopher Winslett
Since its launch, Ruby on Rails has been a preferred open source framework for small-team B2B SaaS companies. Ruby on Rails uses a conventions-over-configuration mantra. This approach reduces common technical choices, thus elevating decisions. With this approach, the developers get an ORM (ActiveRecord), templating engine (ERB), helper methods (like ), controller (ActiveController), directory setup defaults ( ), authentication methods ( ), and more. Multi-tenant is the backbone of B2B SaaS pro...
Read MorePaul Ramsey
Paul Ramsey
A common problem in geospatial analysis is extracting areas of density from point fields. PostGIS has four window clustering functions that take in geometries and return cluster numbers (or NULL for unclustered inputs), which apply different algorithms to the problem of grouping the geometries in the input partitions. • ST_ClusterDBSCAN • ST_ClusterKMeans • ST_ClusterIntersectingWin • ST_ClusterWithinWin ST_ClusterDBSCAN ST_ClusterKMeans ST_ClusterIntersectingWin ST_ClusterWithinWin The ST_Clus...
Read MoreCraig Kerstiens
Craig Kerstiens
The Postgres playground started with a fun idea of "I wonder if I can put Postgres in a web browser". It evolved to a full set of guided tutorials that you can follow along step by step with. We actually use Notion to power all of our tutorials and an in-house API. This means a new tutorial is as simple as some SQL and some markdown. But, did you know you can bring your own setup to the playground? All of our curated tutorials exist directly on the main Crunchy Data Developer area . However...
Read MoreBen Blattberg
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 MoreChristopher Winslett
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 MoreElizabeth Christensen
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 MoreAndrew L'Ecuyer
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 MoreGreg Sabino Mullane
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