Re: Using PK value as a String

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Using PK value as a String
Дата
Msg-id 20080812110416.8e0d6e1c.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на Re: Using PK value as a String  (Moritz Onken <onken@houseofdesign.de>)
Ответы Re: Using PK value as a String
Список pgsql-performance
In response to Moritz Onken <onken@houseofdesign.de>:

> We chose UUID as PK because there is still some information in an
> integer key.
> You can see if a user has registered before someone else (user1.id <
> user2.id)
> or you can see how many new users registered in a specific period of
> time
> (compare the id of the newest user to the id a week ago). This is
> information
> which is in some cases critical.

So you're accidentally storing critical information in magic values
instead of storing it explicitly?

Good luck with that.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

В списке pgsql-performance по дате отправления:

Предыдущее
От: Moritz Onken
Дата:
Сообщение: Re: Using PK value as a String
Следующее
От: Moritz Onken
Дата:
Сообщение: Re: Using PK value as a String