Skip site navigation (1) Skip section navigation (2)

Re: pervasiveness of surrogate (also called synthetic) keys

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Date: 2011-04-28 18:26:50
Message-ID: 4DB9B16A.7000001@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-general
On 04/28/2011 10:29 AM, Jim Irrer wrote:
> A colleague of mine insists that using surrogate keys is the
> common practice by an overwhelming margin in relational databases and
> that they are used in 99 percent of large installations.  I agree that 
> many
> situations benefit from them, but are they really as pervasive
> as he claims?
Well there is no fact to back that up but, I will say that most toolkits 
require the use of a synthetic key, rails, django etc....

JD

>
> Thanks,
>
> - Jim


-- 
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Developement
Organizers of the PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579


In response to

Responses

pgsql-general by date

Next:From: Scott RibeDate: 2011-04-28 18:31:09
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Previous:From: Andrew SullivanDate: 2011-04-28 18:20:38
Subject: Re: pervasiveness of surrogate (also called synthetic) keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group