Better JSON in Postgres with PostgreSQL 14 - Postgres 14 makes JSON even more user friendly than before. Team member Craig Kerstiens highlights the new JSON subscript support in Postgres 14 in this blog post.
PGO 4.7, the Postgres Operator: PVC Resizing, GCS Backups, and More - We're excited to announce the new version of PGO, the open source Postgres Operator from Crunchy Data version 4.7! There's a lot of really cool features that make it easy to deploy production Postgres clusters on Kubernetes. Let's dive in.
Simulating UPDATE or DELETE with LIMIT in Postgres: CTEs to The Rescue! - Unless and until PostgreSQL supports UPDATE and DELETE with LIMIT, the most appropriate workaround for this in pure SQL is to use this CTE approach.
Waiting for PostGIS 3.2: ST_InterpolateRaster - A common situation in the spatial data world is having discrete measurements of a continuous variable. Every place in the world has a temperature, but there are only a finite number of thermometers: how should we reason about places without thermometers and how should we model temperature?
Using Kubernetes? Chances Are You Need a Database - Whether you are starting a new development project, launching an application modernization effort, or engaging in digital transformation, chances are you are evaluating Kubernetes. And if you selected Kubernetes, chances are you will ultimately need a database. Here's how to get started.
Creating a Read-Only Postgres User - How can you simply create a read-only Postgres user (and note that we will use "user" and "role" interchangeably)? Let's explore!
(The Many) Spatial Indexes of PostGIS - The simple story of spatial indexes is: if you are planning to do spatial queries (which, if you are storing spatial objects, you probably are) you should create a spatial index for your table. Learn how in this blog.
|
|
