How long does it take to change your mind?

You’re clever, which means you’re mostly right about things. But everybody is wrong sometime, so how long does it take for you to change your mind? People don’t often change...
November 03, 2017

OmniDB - Now with PL/pgSQL debugger!

OmniDB’s 2.3.0 release, which is coming out on November 2nd, comes with a much requested feature: a debugger for PL/pgSQL functions. This post will walk you through the steps to...
October 31, 2017

Oracle High Availability concepts in PostgreSQL

Sometimes people ask about certain Oracle High Availability features and whether they exist in PostgreSQL. In most cases, very similar features exist. The reason for the similarity is that PostgreSQL...
October 26, 2017

PG Phriday: Getting RAD with Docker [Part 1]

Fans of Rapid Application Development (RAD!) are probably already familiar with Docker, but what does that have to do with Postgres? Database-driven applications are a dime a dozen these days...
October 20, 2017

pglogical with OmniDB

1. Introduction pglogical is an extension that provides an advanced logical replication system that serves as a highly efficient method of replicating data as an alternative to physical replication. Here...
October 19, 2017

Postgres-XL with OmniDB

1. Introduction Postgres-XL (or just XL, for short) is an open source project from 2ndQuadrant. It is a massively parallel database built on top of PostgreSQL, and it is designed...
October 17, 2017

Why PostgreSQL is better than MySQL

Someone recently tweeted about the fantastic news that MySQL fixed a bug. Now in my world, bugs get fixed quickly and well. Bugs happen and they need to be fixed...
October 11, 2017

PG10 at the London PostgreSQL Meetup

We recently hosted the London PostgreSQL Meetup at a new location in Covent Garden. Room was great and its about 100m from Leicester Square tube, so very centrally located and...
October 06, 2017