Sometimes queries keep running longer than you’d like, this creates a bit of a backup on your DB. As a result you can kill them, except when you can’t, here’s a great look at the exceptional case and how to handle it.

We seem to link something about JSONB, the new binary JSON format in Postgres 9.4, each week, but this takes a unique deeper dive into some of the differences from the previous JSON datatype to JSONB.

Over 70% of bugs happen outside of office hours, data from 40k releases and 10m errors. This & other facts.

Here’s a great set of slides from a talk about Postgres. They highlight many of the awesome parts of PG including schemas, JSON, PLs, and replication.

An older but still very relevant talk around many of the awesome bits that most don’t discover in Postgres. A great shotgun talk highlighting CTEs, arrays, ranges, pub/sub, and so much more.

CitusDB provides horizontally scalable Postgres, you can download and trial it today, or read here to see how Citus powers CloudFlare’s dashboard.

A relational database as the system of record is incredibly common, and Postgres is increasingly at the core of it. Yet, in today’s world you have more than one system and connecting them can be a good bit of work. Foreign Data Wrappers or FDWs can go a long way here.

Meteor and Postgres - PostgresSQL with Node-Postgres on the back-end and miniSQL with AlaSQL (our version of minimongo) on the front-end.