Audit database to recreate former states using JSON functions

Started by Felix Kundeabout 12 years ago1 messagesgeneral
Jump to latest
#1Felix Kunde
felix-kunde@gmx.de

<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hello</div>

<div>&nbsp;</div>

<div>last december I&#39;ve delvoped a few PL/pgSQL functions to log</div>

<div>all changes in my database and recreate former database states.</div>

<div>I used row_to_json to log and json_populate_recordset to reproduce</div>

<div>my tables. I think it&#39;s cool feature and I like to share and discuss it</div>

<div>with you. I would be very happy to recieve some feedback. I&#39;m also</div>

<div>interested in other versioning approaches, if there are (?).</div>

<div>&nbsp;</div>

<div>You can find the repository here: https://github.com/FxKu/audit&lt;/div&gt;

<div>I&#39;ve written all the relevant stuff into the README.</div>

<div>&nbsp;</div>

<div>At last, I really like to thank Hans-J&uuml;rgen Sch&ouml;nig (http://www.cybertec.at/)&lt;/div&gt;

<div>for giving me the advice to use JSON functions. This made the whole</div>

<div>developement way more easy.</div>

<div>&nbsp;</div>

<div>Have a great day.</div>

<div>Felix</div>

<div>&nbsp;</div>

<div>&nbsp;</div></div></body></html>