Other posts

  • Mon 12 October 2015

    Testing Python & Postgres

    I recently pulled together a project to demonstrate testing Python functions that interact with a Postgres database. I find that this sort of thing crops up occasionally and the project is an attempt to distil the approach. The main points include:

    • Creating a fresh temporary database via testing.postgresql prior …

    comments. read more

  • Tue 08 September 2015

    Read-only Postgres database

    There are times when I've needed to effectively make a Postgres database read-only, for example after loading or updating reference data. In the past I've revoked permissions from database roles to achieve this but as this post on the PostgreSQL list states, it's possible to do so by making all …

    comments. read more