Search Postgresql Archives

Re: Need schema design advice

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx
> To: pgsql-general@xxxxxxxxxxxxxx
> Subject: Re: 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@xxxxxxxxxxxxxx)
> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux