Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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




Consider applying for YC's Fall 2026 batch! Applications are open till July 27.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: