[endisneigh]

but you can still do pagination with uuids, your rows can be sorted on any arbitrary criteria like created date or updated date.

[vanviegen]

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]

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

[postalrat]

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