[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cgiapp] Before I go off into a codestorm... [Mini-CRM Question]


On Thu, 19 May 2005, Jason Purdy wrote:

> So instead of widening the "people" table to support these fields
> (and having to alter the table every time), I'm thinking of
> developing a datapoint type of system, where you'd have one table of
> datapoints:

This is a bad idea, but it's also a very common one.  It basically
treats a relational database as a glorified hash, storing sets of
completely denormalized key-value pairs in giant tables.  Sometimes
that's really what you need, but I suspect that your situation isn't
that extreme.

-sam

---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/suppressed/
              http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.