Re: Temporal Databases (Database design questions)

2008-06-18 Thread David
On Wed, Jun 18, 2008 at 11:16 AM, M.-A. Lemburg <[EMAIL PROTECTED]> wrote: > On 2008-06-18 09:41, David wrote: >> >> Question 3: Temporal databases >> >> 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

Re: Temporal Databases (Database design questions)

2008-06-18 Thread M.-A. Lemburg
On 2008-06-18 09:41, David wrote: Question 3: Temporal databases 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 datab

Re: Database design questions

2008-06-18 Thread David
> I have a few database-related questions. These aren't Python-specific > questions, but some of my apps which use (or will use) these tables > are in Python :-) Let me know if I should ask this on a different > list. Hi list. I've thought about this some more, and it is off-topic for the python

Database design questions

2008-06-18 Thread David
Hi list. I have a few database-related questions. These aren't Python-specific questions, but some of my apps which use (or will use) these tables are in Python :-) Let me know if I should ask this on a different list. Question 1: Storing app defaults. If you have a table like this: table1 - i