logoalt Hacker News

zarzavattoday at 9:59 AM3 repliesview on HN

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.


Replies

Thev00d00today at 10:02 AM

Sounds fun!

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

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

hastanagtoday at 10:24 AM

[dead]

faresfatoday at 10:22 AM

[dead]