Re:Moving Away from UUIDs
by endisneigh on Monday November 21, 2022 @08:04PM
(#33700486)
but you can still do pagination with uuids, your rows can be sorted on any arbitrary criteria like created date or updated date.
[ Parent
| on HN ]
Dates might not be unique but I can see other possibilities that would be fine.
But that would be slow, even with an index, as compared to using a clustered primary key. Especially when your data doesn't fit in ram.
Re:Moving Away from UUIDs
by endisneigh on Tuesday November 22, 2022 @06:01AM
(#33704419)
Sure, already mentioned UUID’s being slow. There are trade offs