UUIDv7: timestamps aren't time-ordered (and other oddities)

Sleepy Coder · 3 likes

still better than v4 for index locality. just dont treat it as a clock

Maya Williams · 2 likes

we got bitten by clock drift across nodes, ordering was off by a few ms and a pagination query skipped rows

Ethan Brooks · 1 likes

cursor pagination on a uuid is asking for trouble anyway, use a sequence or created_at+id