Some time ago, guys from Instagram shared their approach to generating unique ids on multiple hosts in a way that guarantees (to reasonable extend) uniqueness, and doesn't require any centralized service. Earlier this month, the build benchmarked their solution vs. UUIDs, ...

thomas reiss just published his follow up to my post about indexed searches in "like '%something'" cases. i don't understand french so i can't tell what exactly he wrote, but i understand c code and graphs :) basically - he wrote c ...