v10, The Best PostgreSQL Yet?

The short answer … Hell Yeah! The long answer lies in extensive improvements and the impressive new feature list that makes up this major release – which, by the way...
October 05, 2017

PostgreSQL 10 easy installation with 2UDA

PostgreSQL 10 offers an exciting new set of features in addition to making further improvements to many of the already existing features including Big Data, Replication and Scaling, Administration, SQL...
October 03, 2017

Postgres-BDR with OmniDB

1. Introduction Postgres-BDR (or just BDR, for short) is an open source project from 2ndQuadrant that provides multi-master features for PostgreSQL. Here we will show how to build a test...
September 28, 2017

PG Phriday: pglogical and Postgres 10 Partitions

During the Postgres Open 2017 conference in San Francisco, someone came to the 2ndQuadrant booth and struck up a conversation with me. During our shameless geeking out over database mechanics...
September 22, 2017

PostgreSQL 10 Logical Replication with OmniDB

1. Introduction Logical replication uses a publish/subscribe model and so we create publications on the upstream (or publisher) and subscriptions on downstream (or subscriber). For more details about it, please...
September 19, 2017

The Barman is ready for PostgreSQL 10

Today our Devops team at 2ndQuadrant, led by my dear friend and trusted colleague Marco Nenciarini, released version 2.3 of Barman. The main news is that this release has been...
September 06, 2017

JOOQ Object Oriented Querying (jOOQ)

jOOQ is an ORM-alternative that is relational model centric rather than domain model centric like most ORMs. For example, while Hibernate lets you write Java code and then automatically translates...
August 18, 2017