From: Josh Berkus <josh@agliodbs.com>
To: Tm <x@Vex.Net>
To: Michael A Nachbaur <mike@nachbaur.com>
To: pgsql-sql@postgresql.org
Subject: Re: Object-Relational table design question
Date: Wed, 18 Jun 2003 08:07:12 -0700
Message-ID: <200306180807.12360.josh@agliodbs.com> (raw)
In-Reply-To: <200306180920.44304.x@Vex.Net>
References: <200306170857.26558.mike@nachbaur.com>
<200306170923.34974.josh@agliodbs.com>
<200306180920.44304.x@Vex.Net>
Tm,
> This would work though it's not very scaleable. Our current system makes
> all elements of a service into what we call an 'attribute'. The
> attributes are defined in a table, and attached to each account type,
> and turned on or off, and twiddled with various definitions such as
> term/period billing, etc. This makes it relatively easy to add new
> services... just add another entry in the account attributes table,
> whereas with hard coded joins above, if you add more services you're
> going to have to edit all of your code where joins take place.
Yeah, that's a very good approach. I use it for any client where they need
to be able to add new "attributes" and services after the system is built.
It also works for other things ... for example, a "skills" list for an HR
database.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, x@Vex.Net, mike@nachbaur.com
Subject: Re: Object-Relational table design question
In-Reply-To: <200306180807.12360.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox