Uber Engineering explains the technical reasoning behind its switch in database technologies from Postgres to MySQL - an uncommon direction to migrate in.

Postgres can provide a lot of insight into how a particular query performs by looking at its ‘EXPLAIN’ plan. This article breaks down how to read them properly.

A 40 minute look at “lessons learned the hard way” using Postgres at payment firm GoCardless. Filmed at the recent PGDayUK conference.

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

Under the covers Postgres keeps track of a lot about your database, locks, running queries, and more. Getting access to it isn’t hard you just need to know where to look and what to query. This is a great primer as some of the numbers you can get out of your system to help monitor.

CTEs are often talked about for making SQL more readable, or when you need recursion in a single query. They also have other powerful cases such as when updating some already existing data.

Instant dev portal from any PostgreSQL database.

Last week we saw a post that talked about the benefits of hstore, JSON, and JSONB. This post goes a step further at how you might use JSONB as a key in data modeling along with how you could scale by sharding.

If you don’t need a GUI editor, there’s a great tool that comes with Postgres - psql.

A look at how to define your own range types in Postgres.

Building a PostGIS-supported system that queries free geolocation services and aggregates their results.

With Hired, companies apply to hire you - get salary and equity offers before you interview from companies like Facebook, Postmates, & Square