Hello
last december I've delvoped a few PL/pgSQL functions to log
all changes in my database and recreate former database states.
I used row_to_json to log and json_populate_recordset to reproduce
my tables. I think it's cool feature and I like to share and discuss it
with you. I would be very happy to recieve some feedback. I'm also
interested in other versioning approaches, if there are (?).
You can find the repository here: https://github.com/FxKu/audit
I've written all the relevant stuff into the README.
At last, I really like to thank Hans-Jürgen Schönig (http://www.cybertec.at/)
for giving me the advice to use JSON functions. This made the whole
developement way more easy.
Have a great day.
Felix