Re: Creating complex track changes database - challenge! - Mailing list pgsql-general

From Łukasz Jarych
Subject Re: Creating complex track changes database - challenge!
Date
Msg-id CAGv31of-0x3N0=beHTpNsQGUtmc2hCtEY9xwxQeHrc2QsPXNBQ@mail.gmail.com
Whole thread Raw
In response to Re: Creating complex track changes database - challenge!  (geoff hoffman <geoff@rxmg.com>)
Responses Re: Creating complex track changes database - challenge!  (geoff hoffman <geoff@rxmg.com>)
List 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@rxmg.com>:




Also, if you know PHP, Laravel database migrations have worked great for us!



On Feb 26, 2018, at 3:44 AM, Łukasz Jarych <jaryszek@gmail.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. 



pgsql-general by date:

Previous
From: Alan Gano
Date:
Subject: Re: Creating complex track changes database - challenge!
Next
From: Steven Hirsch
Date:
Subject: psql '\copy to' and unicode escapes