Postgres Weekly 158

A look at how to create modern activity feeds with Facebook-like grouping using only Postgres.

“Typically a company may start with a relational database like Postgres and add Redis for more high velocity use-cases. What if you could tie the two together to enable so much more?”

The PostgreSQL Project is contemplating a change to how they do version numbers.

First and only production-ready multi-master replication product to feature new technology developed for PostgreSQL - increasing performance of transactional workloads requiring replication by extracting changes via Write-Ahead Log (WAL) files and reduces latency during replication.

The ‘tablefunc’ extension provides a really interesting set of functions. One of them is the crosstab function, used for pivot table creation. That’s what this article covers.

Now accepting proposals for talks in English. The PostgreSQL Conference Europe is held on November 1-4 in Tallin, Estonia.

Guaranteed response in 15 minutes and a bug fix in 24 hours from 2ndQuadrant - The PostgreSQL Support Company

A 128 page slidedeck ‘guided tour’ through PostgreSQL data types.

Version 2.2.3 of pgRouting was released last week. The main change is support for PostgreSQL 9.6.

Indeed Prime connects top tech talent with top companies in the US. Companies compete to hire devs on Indeed Prime. 100% free for job seekers. Land a job and get $5k from Indeed Prime.