Having written multiple Postgres extensions (some small and some bigger), I built a cookiecutter template to make the process easier and more automated.

This cookiecutter prompts for some basic extension metadata (e.g., name, Postgres version) and then automatically generates the necessary boilerplate files.

These include:

* Standard extension files (Makefile, .control, c, .h, .sql) pre-populated with stubs.

* Regression Tests

* GitHub Actions for building and testing on multiple Postgres versions

* Docker support

* pgxn integration

Demo video: https://youtu.be/zVxY3ZmE5bU

Hope newcomers to Postgres extensions find it useful.