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.

Automating Database Cleanup for PostgreSQL Using Python

This article shows a technique for cleaning out older data from PostgreSQL tables using Python to follow a set of rules you create.

Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy

We have a script that can be used to help tune ind...

Working with JSON/JSONB Data in PostgreSQL using Python

This article discusses how to work with JSON data in PostgreSQL using Python.

UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability

Learn about unlogged tables and how they work in PostgreSQL.

Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices

Running Postgres in Docker is great for a quick test but what if you want it to behave like a proper, production-style setup with SSL encryption, certificate-based authentication, persistent volumes, and custom configurations? In this article, we’ll find out how