The first release candidate of Postgres 9.6 is here, which means we’re not far away from the full release. Help the community out by giving it a test today.

Postgres’ JSONB support can be powerful and flexible, but it’s not a once size fits all. This deeper dive looks at various implications of using it including indexing, performance, and storage.

If you’re still using 9.1 in production, it’s time to consider an upgrade. After November, there will be no more updates.

Join the masses of users already optimizing their PostgreSQL queries on the quick, easy to use, and powerful Linode SSD servers. Get started with $20 of credit with the code 'POSTGRES20'.

Constraints aren’t always specified using the CONSTRAINT keyword as highlighted in this lightweight post showing how unique indexes can do the same thing.

Pivot tables are extremely common in Excel, but you can also do them directly in the database. Here’s a look at a Postgres extension that makes them simple to do right in Postgres.

The pg_pathman module provides optimized partitioning mechanism and functions to manage partitions.

If you need to regularly schedule jobs directly in your database this extension can make it easier.

An interesting excerpt from this week’s ‘The Bike Shed’ podcast drills into some of how the libpq driver works and its integration with the pg Ruby gem.

On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week