A curated list of awesome PostgreSQL software, libraries, tools and resources, inspired by awesome-mysql.

“I’ve just committed the first version of parallel sequential scan to PostgreSQL’s master branch, with a view toward having it included in the upcoming PostgreSQL 9.6 release.”

In the world of monolithic applications serial integers work just fine, as long as you don’t exhaust your set of IDs. But as soon as you go across multiple distributed databases there’s other concerns to think about.

VividCortex’s network traffic analyzer tool is an easy-to-use way to gain insight into your PostgreSQL server’s activity. Built for PostgreSQL servers running on Linux operating systems, it is a non-intrusive, safe way to understand your query workload. It's fast, secure, and private.

When it comes to data integrity and validation you can’t be too safe, and you should definitely have it at the lowest level. Not all databases provide that, but Postgres does and here how you can see it play with a good approach to constraints at every level of your app.

An amazing guide to educate you on trigrams (so you can sound more intelligent when you drop the term in a meeting), search, and how to apply it all directly in a Rails app.

If you manage a database and want to have that tie into your collection of users take a look at this tool to help you map users in your own system directly to PG users.

Postgres captures a ton of statistics of what’s going on under the covers, sometimes getting at those to know exactly what’s happening is harder than you’d like. This wait interface makes it easy to introspect across all your sessions, great for monitoring and operations.

We’re looking to grow our engineering team beyond 20 as we redefine antiquated software in commercial real estate. If building out new products and setting the foundation for a more efficient system sounds appealing to you, we should talk.

Never had a company apply to you? Well now you can when you sign up at Hired.com to receive your personalized offer, base salary and total compensation up front.