Simon Willison: TILs on heroku

heroku Programatically accessing Heroku PostgreSQL from GitHub Actions - 2020-08-18

My db-to-sqlite tool can connect to a PostgreSQL database, export all of the content and write it to a SQLite database file on disk. …

heroku Upgrading a Heroku PostgreSQL database with pg:copy - 2020-07-20

Figured this out in https://github.com/simonw/simonwillisonblog/issues/132 - I was running PostgreSQL 9.x and I wanted 11.x in order to use the new search_type="websearch" option in Django 3.1. …

heroku Using heroku pg:pull to restore a backup to a macOS laptop - 2020-07-10

Today I worked out how to use the Heroku pg:pull command and Postgres.app to pull a Heroku backup to my laptop. …