but you can still do pagination with uuids, your rows can be sorted on any arbit... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		endisneigh on Nov 22, 2022 \| parent \| context \| favorite \| on: Moving Away from UUIDs (2018) but you can still do pagination with uuids, your rows can be sorted on any arbitrary criteria like created date or updated date.

vanviegen on Nov 22, 2022 | [–]

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.

endisneigh on Nov 22, 2022 | | [–]

Sure, already mentioned UUID’s being slow. There are trade offs

postalrat on Nov 22, 2022 | [–]

Dates might not be unique but I can see other possibilities that would be fine.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact