Re: schema design question

From: Adam Tauno Williams <adamtaunowilliams(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: schema design question
Date: 2007-08-20 00:22:07
Message-ID: 1187569327.4568.5.camel@aleph.wmmi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> However, it still doesn't answer my question about the EV model (where
> each attribute is given its own table).

Do a TABLE(object_id INT, attribute STRING, value STRING) if you just
want to be able to search for objects by an attribute. But better yet
look at one of the thousand object persistence systems out there, not
much to be gained from re-inventing the wheel.

--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Hammond 2007-08-20 00:37:07 Re: [pgsql-jobs] Looking for database hosting
Previous Message Josh Berkus 2007-08-19 21:51:39 Re: Looking for database hosting: FIX CC LIST!!