pgxsq simplifies writing Postgres extensions (especially those relying on procedural languages) by managing changes with Sqitch.
Tracking changes in Postgres extensions is not easy. Updating procedures or
views requires copying the defintion and make the necessary changes. This has
a major drawback: the changes made are not obvious without resorting to diff.
Wouldn't it be great to track changes in version control and use, for example,
just git diff to see what changes were made?
pgxsq allows that by tracking changes with Sqitch and generating extension scripts from those changes. Changes are made by reworking the scripts that define the extension objects. Sqitch caries out the grunt work of tracking the original script version so that the script can be modified and tracked in version control. pgxsq builds the extension update paths from the Sqitch tags that are required for reworking.
This repository contains an example that shows the steps from creating the Sqitch project to making changes to installing the extension.
Install with pip:
pip install pgxsq
Install from source:
make install
You also need to install Sqitch to create projects and use pgxsq.
make