Skip to content
/ pgxsq Public

Tool for writing Postgres extensions as Sqitch projects.

License

Notifications You must be signed in to change notification settings

ewie/pgxsq

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

55 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

pgxsq

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.

Example

This repository contains an example that shows the steps from creating the Sqitch project to making changes to installing the extension.

Installation

Install with pip:

pip install pgxsq

Install from source:

make install

You also need to install Sqitch to create projects and use pgxsq.

Development

make

About

Tool for writing Postgres extensions as Sqitch projects.

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published