Are people here talking about UUIDs or things that just look like UUIDs? It 
sounds like the latter. UUIDs are actually structured objects, with embedded 
type bits. There are multiple UUID generation schemes, one of which is based on 
random numbers, others are based on hashes, and there is the common ugly 
workaround of generating a 128 bit hash and calling it a UUID.

If you use version 1 UUIDs you're mathematically guaranteed to avoid 
collisions. At least for the next 3000 years:

Version 1 UUIDs are based on a node address (MAC), a 60 bit clock, and a 
node-specific sequence number. You can generate 163 billion version 1 UUIDs per 
second and they won't roll over until 5236 AD.

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to