10 ms·

Thanks for this, hadn’t thought of this in terms of Hi/Lo. The similarity is limited though because there isn’t any sequence of Hi values…? AWS also a great ex

Thanks for this, hadn’t thought of this in terms of Hi/Lo. The similarity is limited though because there isn’t any sequence of Hi values…? AWS also a great example! But I wonder if they’re storing them as fixed 128bit and getting the juicy performance benefits.

nivertech 2y ago
Just because the "Hi" part is categorical rather than numeric and has a low cardinality doesn't make it any less of a Hi/Lo scheme. This is my own classification, but I think I've read at least one blog where the author called similar prefixes a Hi/Lo scheme The prefixes are primarily used to create human-readable IDs, which will help avoid human errors and make debugging easier for developers The original purpose of the Hi/Lo algorithm[1] was mainly to allow the client side to generate PKs in batches (as a performance optimization, offline operation, or building entire data structures on the client side), all of which can be replaced today by UUIDs/ULIDs and the like --- [1] https://stackoverflow.com/questions/282099/whats-the-hi-lo-algorithm https://stackoverflow.com/questions/282099/whats-the-hi-lo-a...