Re: generic modelling of data models; enforcing constraints dynamically... - Mailing list pgsql-general

From Scott Marlowe
Subject Re: generic modelling of data models; enforcing constraints dynamically...
Date
Msg-id dcc563d10909271813x69e59f78g8be17b3b337d4aea@mail.gmail.com
Whole thread Raw
In response to Re: generic modelling of data models; enforcing constraints dynamically...  (InterRob <rob.marjot@gmail.com>)
List pgsql-general
On Sun, Sep 27, 2009 at 5:44 PM, InterRob <rob.marjot@gmail.com> wrote:
> Oliver,
> Would you say it is not valid for proposition 2 (people wanting to be able
> to quickly add (and remove?) attributes) because within the relational model
> this can be done reasonably well?

Actually that's what I think it's best at, as long as you aren't
trying to get fancy.  We have a part of an intranet type app that lets
users upload table formatted data that's like a freeform spreadsheet
and we use EAV to store the data for that.  There's no FK or other
relational stuff.

The problems start to pile up when you try to do something exciting,
interesting, fascinating or other 'ings...

pgsql-general by date:

Previous
From: Justin Pryzby
Date:
Subject: dump time increase by 1h with new kernel
Next
From: Scott Marlowe
Date:
Subject: Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans