From: Josh Berkus <josh@agliodbs.com>
To: Rudi Starcevic <rudi@oasis.net.au>
To: pgsql-sql@postgresql.org
Subject: Re: Database design - AGAIN
Date: Tue, 24 Jun 2003 08:25:57 -0700
Message-ID: <200306240825.57350.josh@agliodbs.com> (raw)
In-Reply-To: <3EF7DF74.40700@oasis.net.au>
References: <3EF7DF74.40700@oasis.net.au>
Rudi,
> For this task, a searchable directory, which design would be better.
> In know the second is more flexible as new features can be added but I
> have very limited time and
> I think the one larger table design would be quicker to build.
Sounds like you already have a clear grasp of the situation.
Here's one more question to ask yourself: how long will this app be around?
If the answer is "no more than 3 months, probably less", do it the most
expedient way. If the answer is "6 months to indefinitely", do it the
normalized way -- eventually, either you or your successor will need the
flexibility as the users demand new features. If you are an employee, this
is a no-brainer ... it is 90% likely that even if this is a temporary measure
you will still be maintaining it 2 years from now, and will thank yourself if
you built it "right" in the first place.
Unless, of course, you are a consultant and your client is paying you $500
flat fee, in which case do it whatever way is fastest, but make sure your
client knows that they are not getting an expandable product.
> The front end will be either ColdFusion or PHP - I haven't decided yet.
See what I said about expediency above. My web guru, who is an expert in
both PHP and Cold Fusion, would be delighted to never use Cold Fusion again.
So that's one expert opinion. And don't forget the license fees.
--
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, rudi@oasis.net.au
Subject: Re: Database design - AGAIN
In-Reply-To: <200306240825.57350.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