Re: Robust unique identifiers?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 22 Jan 2005 14:27:31 -0500
Message-ID: <pan.2005.01.22.19.27.31.136399@sbcglobal.net>

On Fri, 21 Jan 2005 14:11:21 -0800, Pete wrote:

> The system needs to be non-DBMS-specific, needs to be able to run in
> multiple instances simultaneously (although this is only a
> hypothetical, later requirement) and needs to be as robust as possible
> throughout DB restores, general maintenance and against rogue DBAs
> resetting IDENTITYs and the like.

Just assign to users the next 512 digits prime number. The sieve of Erathosten will probably consume some resources, but don't worry, be happy. Hakuna matata. The main thing is that the application is database independent.

-- 
Bug, noun: Son of a glitch

Received on Sat Jan 22 2005 - 13:27:31 CST