[Zope] OT: creating unique IDs for table rows

[Dieter Maurer]

Carlos A. Carnero Delgado writes:
 > 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.
If your RDBMS has a reliable transaction system, you may
use your database for id generation:

    m= select max(id) from id_table

    id= m+1

    insert into id_table values(id+1)


Dieter