If you’re looking for a way to practice your SQL skills, PG Exercises offers some good example data and exercises to hone your skills.

Postgres 10 is starting to take shape and one of the most exciting features for it has landed: logical replication directly in core.

Suzuki Hironobu covers the internals of PostgreSQL for database administrators and system developers in this helpful translation of his 2012 Japanese-language book.

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

This year, PostgresOpen has combined with PGConf SV. Not many details yet but you can sign up to stay informed.

A look at the concerns around designing a simple blogging API, considering both GraphQL and traditional REST-based approaches.

Postgres has the ability to ensure you’re connecting in a secure fashion. To do this you need to provide a certificate; here’s the few different ways you can create them if you need to.

OR can often be a problem if you want performant queries, this deep dive shows when it makes sense and when it doesn’t as well as how to work around it when you still need it.

In this episode of our Metrics Maven series, we show how to calculate a weighted average in PostgreSQL.

An exploration of how Postgres manages concurrency with guest Bruce Momjian. 1hr 21 minutes.

A whitepaper exploring whether running Postgres on ARM is a viable option for your next project.

Replication is implemented by logging table mutations to a consistent shared-log called ZLog that runs on the Ceph distributed storage system.

Want an out of the box REST API on top of your Postgres database? Version 0.4.0 of this long-standing project is now out with more new features.