Within Postgres there are two forms of backups and understanding them is a useful foundation for anyone working with Postgres.

A look at what happens if a transaction needs to update data spread across multiple machines, which can be a concern with Citus’s extensions to Postgres.

A fun guide to building a Node.js API to serve a geospatial ‘Game of Thrones’ map, leaning heavily on Postgres (with PostGIS) and Redis.

See how SelectStar can expertly monitor replication in your Postgres database. Start your free trial today.

PostgreSQL 10 Beta 4 is here, the likely last beta before we have an RC. If you’re interested to explore the parallelism improvements, logical replication advancements, or more go ahead and kick the tires on it.

This release includes fixes that prevent a crash in pg_restore when using parallel mode.

A contributor to the PostgREST project (which turns your Postgres DB into a RESTful API) explains how it works, removing any illusion of magic.

..to manage the persistence layer of a Spring Boot application.

A Rails-oriented look at the options for importing large CSV files, how slow it is via an ORM, and how the COPY command can help.

Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account.