Re: My honours project - databases using dynamically attached entity-properties

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>, <josh(at)agliodbs(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: My honours project - databases using dynamically attached entity-properties
Date: 2007-03-13 01:10:22
Message-ID: 87ejnuosn5.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Richard Huxton" <dev(at)archonet(dot)com> writes:

> Well the cost depends on where/how complex the extra fields are. If you're just
> talking about adding columns usercol01..NN with different types and possibly a
> lookup to a single client_attributes table, it's not difficult.

And then what? dynamically construct all your SQL queries?
Sure, sounds like a simple solution to me...

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-03-13 01:13:15 Re: [COMMITTERS] pgsql: Make configuration parameters fall back to their default values
Previous Message Tom Lane 2007-03-13 01:00:46 Re: CLUSTER and MVCC