From: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
---|---|
To: | geoff hoffman <geoff(at)rxmg(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Creating complex track changes database - challenge! |
Date: | 2018-02-26 16:36:48 |
Message-ID: | CAGv31of-0x3N0=beHTpNsQGUtmc2hCtEY9xwxQeHrc2QsPXNBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you geoff!
I think that i will test http://www.liquibase.org/ this one.
what about setting up trigger to metadata (structural table) to find if
column was added for example?
Best,
Jacek
2018-02-26 16:43 GMT+01:00 geoff hoffman <geoff(at)rxmg(dot)com>:
>
>
> There’s https://flywaydb.org/
> and http://www.liquibase.org/
>
> More: https://dbmstools.com/version-control-tools
>
> Also, if you know PHP, Laravel database migrations have worked great for
> us!
> https://laravel.com/docs/5.6/migrations
>
>
>
> On Feb 26, 2018, at 3:44 AM, Łukasz Jarych <jaryszek(at)gmail(dot)com> wrote:
>
> i would like to ask you for help with track changes to my database.
> I am new to PosgtreeSQL but i have to learn it quickly because of my boss.
>
> I have to:
>
> 1. Keep all changes within table including:
> -adding rows
> -deleting
> -editing
>
> 2. Save table with specific state and recover specific state (so go back
> to previous table versions) including comparing tables.
>
> 3. Track all DLL and DML changes with possibility to ho back to previous
> version.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Hirsch | 2018-02-26 16:53:15 | psql '\copy to' and unicode escapes |
Previous Message | Alan Gano | 2018-02-26 16:06:31 | Re: Creating complex track changes database - challenge! |