Re: schema change tracking

On 5/16/19 10:55 AM, Benedict Holland wrote:
> Hi All!
>
> Thanks for the replies. I am looking for a solution, possibly 3rd party,
> where I write changes to the schema and it keeps track of the changes I
> made. I am used to doing stuff in pgadmin4 but I don't mind something else.
>
> This isn't really ad-hoc. This is more like, I have a v1.0 release
> coming out soon and I have made dozens or hundreds of changes to the
> schema from the alpha. Right now, I can destroy the databases and
> recreate them without data loss because it is in active development.
> When this gets released, we need some way to make sure that we can
> easily migrate between release versions and that means schema change
> tracking. Basically, to Steve's concern, I don't have to go back and
> figure out changes (thankfully, I have done that and it sucks) but we
> need something from an initial release moving forward.
>
> I don't have time to write my own and this problem is complex enough to
> either buy a solution or go with a 3rd party application.
>
> So far, SQITCH is looking like a winner. Yoyo can work as I have access
> to python. We are not using SQLAlchemy but I don't see a reason why we
> can't.

I will second the motion on Sqitch. It has met all my needs and is
framework agnostic.

>
> Thanks all for the suggestions. This is great.
> ~Ben
>

>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com