Re: [GENERAL] Design decision advice

2008-08-14 Thread William Temperley
On Thu, Aug 14, 2008 at 2:55 AM, Craig Ringer <[EMAIL PROTECTED]> wrote: > William Temperley wrote: >> A. Two databases, one for transaction processing and one for >> modelling. At arbitrary intervals (days/weeks/months) all "good" data >> will be moved to the modelling database. >> B. One databas

Re: [GENERAL] Design decision advice

2008-08-13 Thread Craig Ringer
William Temperley wrote: > Dear all > > I'd really appreciate a little advice here - I'm designing a PG > database to manage a scientific dataset. > I've these fairly clear requirements: > > 1. Multiple users of varying skill will input data. > 2. Newly inserted data will be audited and marked go

[GENERAL] Design decision advice

2008-08-13 Thread William Temperley
Dear all I'd really appreciate a little advice here - I'm designing a PG database to manage a scientific dataset. I've these fairly clear requirements: 1. Multiple users of varying skill will input data. 2. Newly inserted data will be audited and marked good / bad 3. We must have a dataset that i