In a developer’s ideal world there’s only one stable and one development version of the product. Everyone updates immediately to the next stable version and nobody cares about anything older...
When I wrote about Reason #3: No Vendor Lock-in , I leaned on the liberal PostgreSQL License and the fact that there are many vendors that can Support PostgreSQL in...
A regular expression is a special text string used to describe a search pattern. PostgreSQL’s regular expressions supports three separate approaches to pattern matching: POSIX-style regular expressions (BREs and EREs)...
PostgreSQL was presented with the 2019 O’Reilly Open Source Award for Lifetime Achievement in Portland, Oregon, Thursday July 18th during OSCON. I had the honor of accepting that award alongside...
Declarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a...
Postgresql String Functions and Operators. This blog today is going to talk about strings: how they are stored, how they are input, and lots of examples of how to use...
The problem: duplicate rows Once upon a time, there was a database person who knows about referential integrity and its importance for creating database tables. The interesting part is that...
PostgreSQL is packed with features. What may not be part of the core is available as extensions. What are extensions – you ask? PostgreSQL exposes APIs that are designed to...
Docker Hub carries Docker images for PostgreSQL, based on Debian Stretch or Alpine Linux. These are not official PostgreSQL Development Group (PGDG) images from postgresql.org, they’re maintained in the Docker...
