PostgreSQL 19 Is Late

Steve notes that PostgreSQL 19 is late, but the reasons and implications extend to other platforms, and really, all other software.

How to run PostgreSQL in Docker

Get PostgreSQL running in Docker in minutes with this step-by-step setup guide. Learn to pull the image and run a container

PostgreSQL in action with Opensearch

Learn about using Opensearch with PostgreSQL to improve performance and quickly return results to your users.

Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles

Learn how you can enable map your security roles in Aurora PostgreSQL to AD groups using Kerberos.

How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)

In this article, learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.

The string_agg function

How User-Defined Types work in PostgreSQL: a complete guide

I’m sure I’m not alone when I say, sometimes I get sidetracked. In this particular instance, I hadn’t intended to start learning about User-Defined Types (UDT) in PostgreSQL – I just wanted to test a behavior that involved creating a UDT. But, once I started reading, I was hooked. I mean, four distinct UDTs with different behaviors? That’s pretty cool. Let’s get into it.

PostgreSQL String Functions Part 1

This article covers a number of basic string functions in PGSQL.

Using PostgreSQL as a NoSQL Store and a Search Engine

Introduction We mostly get inclined to use/introduce MongoDB for JSON storing/processing in our database system and Elasticsearch for searching operations in JSON data. However, what we often tend to overlook is that in reality, PostgreSQL can actually act as both NoSQL store and a powerful search engine too. It also comes with ACID guarantees, transactions, […]

Downtime Caused by the Postgres Transaction ID Wraparound Problem

Learn about transaction ID wraparound in PostgreSQL, which caused a problem for the author.