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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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