OSCON 2006: TimeTravel Tables in PostgreSQL
|
|
Elein showed how to use timestamps to keep an audit trail of all changes in your DB. With this technique, you never actually delete records, you just give them an end date. Multiple copies of a record (again, with timestamps for each one) also allow you to track edits. (This is a pretty standard approach, especially in ‘validated’ environments, or in government-regulated industries.)
|
|
Full Story |
This topic does not have any threads posted yet!
You cannot post until you login.
