2 ms·
> What are the advantages of sortable UUIDs I guess for use-cases like Instagram's: "Generated IDs should be sortable by time (so a list of photo IDs, for exam
by ignoramous 5y ago
> What are the advantages of sortable UUIDs
I guess for use-cases like Instagram's: "Generated IDs should be sortable by time (so a list of photo IDs, for example, could be sorted without fetching more information about the photos)... If you use a timestamp as the first component of the ID, the IDs remain time-sortable... [but require] more storage space (96 bits or higher) to make reasonable uniqueness guarantees" [0]
[0] https://archive.is/xiMGZ https://archive.is/xiMGZ
- zimpenfish 5y agocf also Twitter's Snowflake[1] which is [timestamp, worker number, sequence number] to give the same "roughly sortable by time" property. [1] https://blog.twitter.com/engineering/en_us/a/2010/announcing-snowflake https://blog.twitter.com/engineering/en_us/a/2010/announcing...