[postgis-users] PostgreSQL table history tracking

[Sandro Santilli]

Ivan, maybe tracking history of a PostGIS topology would be an interesting
use case for you. It'd require tracking multiple tables at once, so that
"restore" operations are also performed on all tables at the same time.

I guess such use case would benefit for ad-hoc routines to support that,
should they be in your code ?
Or is there any postgis-specific code in yours ?

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html

On Sat, Nov 05, 2011 at 09:40:43PM +0100, Ivan Mincik wrote:
> Dear PostGIS users,
> 
> I have finished first beta version of my history tracking functions,
> which adds possibility to store full editing history of your database
> tables, recover its state to any time, visualize diffs and place tags
> to mark particular table state. It is possible to track both geometry
> and non-geometry tables. Adding and removing history tracking if fully
> transparent to client software and does no changes to original table
> schema except adding some trigger function.
> 
> I would be very happy, if somebody will make a try and/or review a
> code and post some feedback.
> 
> More information:
> https://github.com/imincik/pghistory-tracker/blob/master/README
> Source code: https://github.com/imincik/pghistory-tracker