Today I'm writing a Postgres native function to derive UUIDs from an integer primary key using AES intrinsics. This lets me expose public UUID keys while still using an efficient 64-bit sequential primary key.

Not sure if I'll use it compared to just using conventional uuidv7 but it's nice to have options.

Sounds fun!

Another option out there is "UUID47" which uses siphash[0]

0. https://github.com/stateless-me/uuidv47

[dead]

[dead]