Upsert is here! Well… It will be available in Postgres 9.5, it’s now fully committed so there’s no question about if, it’s just when. Take a read through the commit here.

One of the last Postgres conferences of the year is coming up, and it’s looking to be a great one in Silicon Valley. With a number of speakers from within the Postgres community and several from others, make sure to check it out if you’re looking for another conference to get to.

Postgres’ session_replication role is really meant to be a utility when using replication, allowing you to avoid certain workflows–it’s also extremely efficient at bulk loading. But there’s also some more detailed use cases where it’s incredibly useful.

A well-prepared DBA considers their strategy for a Postgres rollout early. Thinking about key database questions in advance can make you the IT hero as you reveal a solid deployment plan that supports the goals of the business.

When you want to order with some sub-grouping, or compute some operation across different rows, window functions can be powerful. Here, Parker Selbert highlights how they’re not just for SQL reports only but can be used directly from Rails.

You might not realize it from most guides out there, but SQL has changed over the years, or at least expanded. From the creator of Use the Index Luke, here’s a guide that aims to start covering what modern SQL is and how you can take advantage of it.

Postgres has had JSON support for a couple years now, and it’s gotten even better with JSONB. Now frameworks have caught up as well adding solid support, take a look at the Django experience for working with JSON and Postgres compared with Mongo.

2ndQuadrant has released version 1.5.0 of Barman - the Backup and Recovery Manager for PostgreSQL.