Re: FN-FORUM: What's the best development platform for creating Web 2.0 business applications?

date posted 21st November 2007 23:41

Hello Graham,

Graham Stark wrote:
> But relying on
> these as the main tools to describe the relationships in a database
> causes lots of people lots of problems - especially unique incrementing
> IDs as primary keys.

I'm sorry, but this is just not correct. Remember too that once you
select a field as being part of a primary key then you cannot update it,
so if you pick customer name and postcode as the key then those fields
are fixed forever. I'd say that'd cause a lot more problems than
choosing a dumb key.

Best Regards!

--
Gary
http://www.garyshort.org