On Mon, Feb 04, 2008 at 10:49:51AM +0100, Masse Jacques wrote:
> Hello
[much garbage including HTML trimmed.]
Please set your mail client to text-only. HTML does not make your
point better, and it annoys the heck out of people whose mail readers
use text.
> This model is known as Entity-Value-Attribute and not well
> appreciated by relational designers. I think it is not relational,
> but I use it as storage for data (in some case, I don't know the
> database structure -relational- where data will be stored). It's
> like a truck container used for office removal :).
It's more like sitting on a land mine and hoping it won't go off.
> Imho, don't use it with a complex database structure; as a minimum,
> use lookup tables for Value (to avoid uncontrolled new parameters)
> and add a column to store the attribute type.
Putting lipstick on the EAV pig does not help.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate