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.

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.