PostgreSQL

This section is all about PostgreSQL: The world's most advanced open source database.

The "standard" client or admin utility is pgAdmin - PostgreSQL Tools which actually runs in a browser and is written in Python. It also includes the psql command line utility.

Command Line

There is a PostgreSQL command line utility called psql, this is documented at PostgreSQL: Documentation: psql.

Setting up Command Line

One very useful thing is setting up a password file, see PostgreSQL: Documentation: 12: 33.15. The Password File for details on this, which does work rather nicely, however be sure to read the part that describes setting the file permissions correctly.

Embedded PostgreSQL

Whilst working on a Java project, built using Maven, I needed to execute Integration Tests, this meant testing with PostgreSQL but without deploying it, and so I chose to use an Embedded PostgreSQL solution. At first I found some quite old solutions that had not been updated in a while, eventually I found GitHub - opentable/otj-pg-embedded: Java embedded PostgreSQL component for testing which has worked very nicely. However this was found to not run on Alpine Linux in Docker, so I moved to a fork at zonkyio/embedded-postgres: Java embedded PostgreSQL component for testing.