Re: Avoiding surrogate keys

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Avoiding surrogate keys
Дата
Msg-id r2pb42b73151005011150me8412577y2b76e48a73f7589a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Avoiding surrogate keys  (Lew <noone@lwsc.ehost-services.com>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Løcke
Дата:
Сообщение: PostgreSQL vs. Microsoft SQL server
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: PostgreSQL vs. Microsoft SQL server