[bufferoverflow]

If there's an increasing ID, just sort by ID.

[zoky]

Won’t work if your ID is a UUID. Also, this is more generally applicable to any date, not just created.

[keep_reading]

UUIDv7 is sortable by time

[zoky]

And I’m sure that will be incredibly useful in 20 years when UUIDv7 has entirely supplanted UUIDv4 in all legacy systems (and you only need to sort by date created), but for now let’s just go with the best practice for the foreseeable future and sort in a way that not only ensures consistency but future-proofs us indefinitely.

[keep_reading]

Then don't use UUIDs, use snowflakes / flakes