Re:Showdown: MySQL 8 vs. PostgreSQL 10
by skrause on Wednesday May 23, 2018 @02:30PM
(#17136694)
I've written my own UUID generation function which uses the current timestamp with microsecond precision for the first 64 bits and a random value for the last 64 bits. So far it's been a great success.
Collisions are extremely unlikely unless you have Google scale and generated UUIDs are mostly ordered.
Re:Showdown: MySQL 8 vs. PostgreSQL 10
by dvlsg on Wednesday May 23, 2018 @04:36PM
(#17138017)
I've also done this at a medium ish scale. We had to be careful with how the uuids were generated, though. Specifically which portion of the bytes contained the timestamp (and in what order) since different databases store uuids differently.
Collisions are extremely unlikely unless you have Google scale and generated UUIDs are mostly ordered.