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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Wed, 17 Dec 2008 07:51:11 +0100
  • Message-id: <20081217065111.GA6361@apartia.fr> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group