Re: Need schema design advice - Mailing list pgsql-general

From Martin Gainty
Subject Re: Need schema design advice
Date
Msg-id BLU142-W287840529E1A84927C86D8AE360@phx.gbl
Whole thread Raw
In response to Re: Need schema design advice  (Sam Mason <sam@samason.me.uk>)
Responses Re: Need schema design advice  (Ben Chobot <bench@silentmedia.com>)
Re: Need schema design advice  (Lew <noone@lwsc.ehost-services.com>)
List pgsql-general
could you provide a brief explanation of EAV ?

thx
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.


> Date: Sun, 12 Oct 2008 20:22:14 +0100
> From: sam@samason.me.uk
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Need schema design advice
>
> On Sun, Oct 12, 2008 at 08:12:40PM +0100, I wrote:
> > As always, it's a trade off between what you're optimizing for. If
> > you're adding more preference types then go for a EAV style design, if
> > you're going to want to add more details about the preferences (this
> > does seem to be the common case, which is why most people here stay
> > away from EAV designs)[...]
>
> oops, got distracted and forgot to finish this sentence!
>
> ...then you're better off with a non-EAV style design.
>
>
> Sam
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Stay up to date on your PC, the Web, and your mobile phone with Windows Live. See Now

pgsql-general by date:

Previous
From: Marco Colombo
Date:
Subject: Re: Starting PostgreSQL
Next
From: justin
Date:
Subject: Re: Chart of Accounts