Fixing UUIDv7 (for database use-cases)brooker.co.za 4 pointsmebcitto10 months ago1 commentSaveHideCopy link On HNComments−sergeyprokhoren10moThe PostgreSQL uuidv7() developers are leaning toward a different approach to solving timestamp leaks, similar to FHSS (https://en.wikipedia.org/wiki/Frequency-hopping_spread_spect...). This is currently possible manually using the parameter "shift" (https://postgrespro.ru/docs/postgresql/18/functions-uuid), but could be automated in the near future
Comments
The PostgreSQL uuidv7() developers are leaning toward a different approach to solving timestamp leaks, similar to FHSS (https://en.wikipedia.org/wiki/Frequency-hopping_spread_spect...). This is currently possible manually using the parameter "shift" (https://postgrespro.ru/docs/postgresql/18/functions-uuid), but could be automated in the near future