Re: schema change tracking

On 5/16/19 9:41 AM, Benedict Holland wrote:
> I need a tool that can track schema changes in a postgesql database,
> write scripts to alter the tables, and store those changes in git. Are
> there tools that exist that can do this?
>
> BTW, I know if I use a framework with some form of model tracking
> (laravel and Django), those can do it. The application I am writing does
> not track model files and I really cannot compare sql schema dumps
> across versions. It would be far too time-consuming.

For Python database migrations when I'm not using Django or SQLAlchemy
I've enjoyed yoyo migrations:

https://ollycope.com/software/yoyo/latest/

If you are using SQLAlchemy then I'd go with Alembic:

https://pypi.org/project/alembic/

Btw I don't *think* this is what you're looking for, but on the Postgres
side you can also set `log_statement='ddl'` to audit the changes:

https://blog.hagander.net/why-are-you-not-logging-your-ddl-142/

Or for something more elaborate you could use Event Triggers. The docs
have an example you could start from:

https://www.postgresql.org/docs/current/event-trigger-example.html

--
Paul ~{:-)
pj(at)illuminatedcomputing(dot)com