On: Goodbye integers, hello UUIDv7

[lysium]

Neat idea.

I’m afraid you won’t be able to ever rotate that key, would you? Since it’s result is externally used as an identifier, you would have to rotate the external identifiers, too.

[aurbano → lysium]

Assuming you have a table where the identifiers are stored you'd have the internal one (UUIDv7) and the encrypted version from it (external id).

You could rotate encryption keys whenever you want for new external id calculation, so that older external ids won't change (as they are external, they need to stay immutable).

[lilyball → aurbano]

If you're storing the identifiers then you don't need encryption, you just generate a UUIDv4 and use that as the external identifier. And then we're back at where the blog post started.

[oconnore → lysium]

I think you could but it would further complicate the id scheme (would need some sort of a version mask to facilitate a rotation window).

[the_arun → lysium]

What is the use case for rotating uuids? Aren’t they immutable?

[Raed667 → the_arun]

i think they meant rotating the encryption key not the internal uuids