Search Postgresql Archives

Versioning

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I can think of several ways of "versioning" objects (modeled as rows of a 
table).  

1)  parent-child based model, where each edit of a row results in a child row
2)  date-based model, where each row is stored with a date and no updates are 
performed, only inserts
3)  Maintain a shadow table with "old" versions of a row
4)  Maintain a shadow table with only diffs from the original and metadata on 
when the changes took place
5)  Other?

Has anyone suggestions on what might work "best"?  The "rows" here are going 
to be simple text fields with a little metadata.

Thanks,
Sean


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux