| From: | geoff hoffman <geoff(at)rxmg(dot)com> |
|---|---|
| To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Creating complex track changes database - challenge! |
| Date: | 2018-02-26 15:43:07 |
| Message-ID: | C8B00401-0951-4E18-BA64-714CBB0ECF5D@rxmg.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
There’s https://flywaydb.org/ <https://flywaydb.org/>
and http://www.liquibase.org/ <http://www.liquibase.org/>
More: https://dbmstools.com/version-control-tools <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 <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 | Alan Gano | 2018-02-26 16:06:31 | Re: Creating complex track changes database - challenge! |
| Previous Message | Thomas Kellerer | 2018-02-26 15:22:09 | Re: merge statement gives error |