Re: [GENERAL] Database design: Temporal databases

2008-06-18 Thread Jeff Davis
On Wed, 2008-06-18 at 14:05 +0200, David wrote: > How well do temporal databases work? Do RDBMS (ie Postgresql) need > add-ons to make it effective, or can you just add extra temporal > columns to all your tables and add them to your app queries? Does this > increase app complexity and increase ser

Re: [GENERAL] Database design: Temporal databases

2008-06-18 Thread Richard Broersma
On Wed, Jun 18, 2008 at 5:05 AM, David <[EMAIL PROTECTED]> wrote: > I haven't used them before, but I like the idea of never > deleting/updating records so you have a complete history (a bit like > source code version control). Well depending on what kind of temporal behavior you are modeling, th

[GENERAL] Database design: Temporal databases

2008-06-18 Thread David
Hi list. Some background information on the subject: http://en.wikipedia.org/wiki/Temporal_database I haven't used them before, but I like the idea of never deleting/updating records so you have a complete history (a bit like source code version control). How well do temporal databases work? Do