Hi Jacek, On Mon, 26 Feb 2018 11:44:13 +0100 Łukasz Jarych <jaryszek@xxxxxxxxx> wrote: > Hi Guys, > > 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. depending on your requirements and implementation of these, you might want to have a look at "Developing Time-Oriented Database Applications in SQL" (https://www2.cs.arizona.edu/people/rts/tdbbook.pdf). It is quite thick with 530 pages, but it helped me wrap around my head on a similar requirement. It describes the challenges with tracking and managing these kinds of changes as well as solutions together with SQL examples. Cheers, Christian -- Dr.-Ing. Christian Keil (Principal Researcher) Phone:+49 40 808077-648 Fax:+49 40 808077-556 Mail: keil@xxxxxxxxxxx DFN-CERT Services GmbH, https://www.dfn-cert.de/, Fax: +49 40 808077-556 Sitz / Register: Hamburg, AG Hamburg, HRB 88805, Ust-IdNr.: DE 232129737 Sachsenstrasse 5, 20097 Hamburg, Germany. CEO: Dr. Klaus-Peter Kossakowski 25. DFN-Konferenz "Sicherheit in vernetzten Systemen" am 27./28. Februar 2018 im Grand Hotel Elysee Hamburg 7. DFN-Konferenz "Datenschutz" am 20./21. November 2018 im Grand Hotel Elysee Hamburg
<<attachment: smime.p7s>>
