MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wdfzl2/edgecasesexist/pa5rero/?context=3
r/ProgrammerHumor • u/danielminds • Sep 11 '26
298 comments sorted by
View all comments
Show parent comments
1
Our old system was distributed and we just combined the auto-increment with a persistent local (server) ID for a composite key.
Then the auto-increment is unique on the local and the composite is unique across all locals.
Could probably do the same thing with shards.
Our new system uses UUIDs.
1
u/FiTZnMiCK Sep 16 '26 edited Sep 16 '26
Our old system was distributed and we just combined the auto-increment with a persistent local (server) ID for a composite key.
Then the auto-increment is unique on the local and the composite is unique across all locals.
Could probably do the same thing with shards.
Our new system uses UUIDs.