| From: | "Felix Kunde" <felix-kunde(at)gmx(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Audit database to recreate former states using JSON functions |
| Date: | 2014-01-14 12:34:25 |
| Message-ID: | trinity-cc245ba5-9c64-4dba-b5ac-d32a930b8a06-1389702865404@3capp-gmx-bs29 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hello</div>
<div> </div>
<div>last december I'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'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'm also</div>
<div>interested in other versioning approaches, if there are (?).</div>
<div> </div>
<div>You can find the repository here: https://github.com/FxKu/audit</div>
<div>I've written all the relevant stuff into the README.</div>
<div> </div>
<div>At last, I really like to thank Hans-Jürgen Schönig (http://www.cybertec.at/)</div>
<div>for giving me the advice to use JSON functions. This made the whole</div>
<div>developement way more easy.</div>
<div> </div>
<div>Have a great day.</div>
<div>Felix</div>
<div> </div>
<div> </div></div></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Minsel | 2014-01-14 12:36:31 | Postgres usage of session identifiers for security |
| Previous Message | Granthana Biswas | 2014-01-14 06:31:10 | Correct query to check streaming replication lag |