Re: Avoiding surrogate keys - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Avoiding surrogate keys
Date
Msg-id r2pb42b73151005011150me8412577y2b76e48a73f7589a@mail.gmail.com
Whole thread Raw
In response to Re: Avoiding surrogate keys  (Lew <noone@lwsc.ehost-services.com>)
List pgsql-general
On Sat, May 1, 2010 at 12:09 PM, Lew <noone@lwsc.ehost-services.com> wrote:
> Philippe Lang wrote:
>>
>> I think nobody mentioned Object-Relational mappers.
>> If you intend to used one (or think you may be using one in the future),
>> using surrogate keys is more straightforward, if not necessary.
>
> Neither of those claims is even slightly true.  Using Hibernate, EclipseLink
> or OpenJPA (for Java applications), natural keys are sufficient and far more
> straightforward than surrogate keys.

right -- to be fair though is quite a bit of (generally bad) software
out there that assumes or at least heavily encourages surrogate keys.

merlin

pgsql-general by date:

Previous
From: Thomas Løcke
Date:
Subject: PostgreSQL vs. Microsoft SQL server
Next
From: Scott Marlowe
Date:
Subject: Re: PostgreSQL vs. Microsoft SQL server