3 ms·
Also the conclusion for those who skip to the comments: * integers and serial have obvious benefits for simplicity, storage, and sortability. You might not wan
by kiwicopple 4y ago
Also the conclusion for those who skip to the comments:
* integers and serial have obvious benefits for simplicity, storage, and sortability. You might not want to expose them to the world though.
* If you want the ultimate in collision avoidance UUIDv4 is OK
* UUIDv1 could have been great, but it doesn't lexicographically sort.
* The best time-based ID seems to be xid, with good performance and sort friendliness
* If you want to be a little more standards-oriented, UUID v6/v7