Re: UUID v7 - Mailing list pgsql-hackers

From Sergey Prokhorenko
Subject Re: UUID v7
Date
Msg-id 950532109.2703192.1732654077778@mail.yahoo.com
Whole thread Raw
In response to Re: UUID v7  (Przemysław Sztoch <przemyslaw@sztoch.pl>)
Responses Re: UUID v7
List pgsql-hackers
gen_uuidv7() is OK

uuid-ossp is outdated, slow and not supported by the author. UUIDv7 is the renaissance of UUIDs. So we should not depend on legacy technology names


Sergey Prokhorenko sergeyprokhorenko@yahoo.com.au


On Tuesday 26 November 2024 at 10:35:20 pm GMT+3, Przemysław Sztoch <przemyslaw@sztoch.pl> wrote:


A lot of people use https://www.postgresql.org/docs/current/uuid-ossp.html.

And `uuid_generate_v7()` will be the continuation...

From my point of view, absorbing uuid_generate_v5 into mainline would be a great move too.

On 26.11.2024 20:30, Masahiko Sawada wrote:
On Tue, Nov 26, 2024 at 11:11 AM Sergey Prokhorenko
<sergeyprokhorenko@yahoo.com.au> wrote:
Changing the name uuidv7() to uuid_v7() is a bad idea because the RFC 9562 uses the term UUIDv7, and therefore code containing uuid_v7() will not be found by searching the web in most cases.

It makes much more sense to rename it to get_uuidv7(), so that a query for "uuidv7" does not return a bunch of other unnecessary functions related to UUIDv7.
Thank you for pointing it out. How about gen_uuidv7() and gen_uuidv4()
as we already have gen_random_uuid()?

Regards,

--
Przemysław Sztoch | Mobile +48 509 99 00 66



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Fix meson uuid header check so it works with MSVC in REL_16_STABLE
Next
From: Andres Freund
Date:
Subject: Re: Allow non-superuser to cancel superuser tasks.