Just got a plain SQL dump of a database and in this case pg_restore does not work. This post shows how to use psql to load such a dump into a database in the context of a local development environment.

A quick way how to run PostgreSQL in your development environment without any upfront setup work.

A partial unique index allows to constrain only a subset of the records in a table. This post shows an example how to implement a partial unique constraint with SQLAlchemy.

Two approaches to quickly compare two similar tables and get an idea of how many records differ based on an example with geo data.

Working with Heroku Connect means that at some point some records will end up in a failed state. This post shows a few options how to trigger the sync manually again.

Small SQL snippet to quickly get an overview of the row count in a PostgreSQL database.

Showing how to use pg_restore to load a dump into a developer's database server for local development.