▲ | ibejoeb a day ago | |||||||
If you need an opaque ID like a uuid because, for example, you need the capability to generate non-colliding IDs generated by disparate systems, the best way I've found is to separate these two concerns. Use a UUIDv4 for public purposes and a bigint internally. You don't need to worry about exposing creation time, and you can still manage your data in the home system with all the properties that a total ordering affords. | ||||||||
▲ | tracker1 a day ago | parent [-] | |||||||
Now coordinate those sequential ids on a sharded or otherwise clustered database system. | ||||||||
|