Skip site navigation (1) Skip section navigation (2)

archiving or versioning data?

From: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: archiving or versioning data?
Date: 2008-12-17 06:51:11
Message-ID: 20081217065111.GA6361@apartia.fr (view raw or flat)
Thread:
Lists: pgsql-sql
Hi,

I'd like to find a way to archive versions of my data in an elegant and
extensible way.

When a user modifies certain entries I'd like the database to keep the
previous versions (or a limited, definable number of versions).
Wiki-style.

Would that be a good use of postgres' arrays? 

So I'm looking for "best practices" (tm) on that subject.

Thanks in advance for your suggestions,

-- 
http://www.critikart.net

Responses

pgsql-sql by date

Next:From: A. KretschmerDate: 2008-12-17 07:12:56
Subject: Re: archiving or versioning data?
Previous:From: Tom LaneDate: 2008-12-17 00:38:10
Subject: Re: pg_clog/0202 Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group