[Zope] OT: creating unique IDs for table rows

Carlos A. Carnero Delgado texel@rtvc.com.cu
Sat, 18 Aug 2001 02:38:02 -0400


Hiya all,

what's a good method for creating unique IDs for rows in a table of a
database? I need to create that for an unique index which will serve
as foreign key to another table.

I'm currently creating a string which adds a current time (GMT) and a
random number then I get a SHA digest out of it. It works well for
testing purposes, but I'd like to get something more orthogonal and
with more "uniqueness". BTW, the underlying RDBMS doesn't support
autogenerated sequences or anything like that.

Thanks,
Carlos.