From: | Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Need schema design advice |
Date: | 2008-10-13 02:16:04 |
Message-ID: | a55915760810121916u52dbb104t4982db0043243a2b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Oct 12, 2008 at 8:10 PM, Ben Chobot <bench(at)silentmedia(dot)com> wrote:
> On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
> > could you provide a brief explanation of EAV ?
>
> (...) in an EAV model you would do something like:
> create table eav
> (
> kind text primary key,
> attr text,
> value text
> );
> insert into eav (kind, attr, value) values ('car','wheels','4');
> insert into eav (kind, attr, value) values ('bike','wheels','2');
> insert into eav (kind, attr, value) values ('small
> boat','displacement','1000');
> insert into eav (kind, attr, value) values ('big
> boat','displacement','300000');
Truly Hideous (TM).
Martin, I recommend you read the following:
http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html
From | Date | Subject | |
---|---|---|---|
Next Message | Mikkel Høgh | 2008-10-13 03:57:26 | Drupal and PostgreSQL - performance issues? |
Previous Message | Ben Chobot | 2008-10-13 01:10:05 | Re: Need schema design advice |