[ahoka]

But those sequential IDs are often just not suitable due to security reasons.

[sgarland]

Then don’t expose them. Adapt your API, don’t break the DB.

But in any case, both of the varieties mentioned still have random components; they aren’t purely sequential. Monotonic for the time component, yes.

[ahoka]

I cannot not expose them, they exist to be exposed.

[sgarland]

You could map them to a v4 UUID that isn’t a PK (or even indexed), and expose that instead.