firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Published 20 hours ago • verified publisher icon FirebirdSQL

Option for GEN_UUID to generate v7 UUID

Open r1gm opened this issue 1 year ago • 3 comments

UUID v7 more index-able than UUID v4(Current used in FirebirdSQL, CMIIW), please bring support for UUID v7 in FirebirdSql.

r1gm avatar Jan 27 '24 02:01 r1gm

As far as I'm aware, the relevant RFC hasn't been published yet, so as of now, there is no official v7 UUID, and implementation at this time would be premature.

mrotteveel avatar Jan 27 '24 08:01 mrotteveel

However, no changes will be made to the text of the RFC. Therefore, no one waits for official approval: Rust PostgreSQL JavaScript Google etc.

sergeyprokhorenko avatar Jan 28 '24 10:01 sergeyprokhorenko

PostgreSQL

FWIW, I doubt that any PostgreSQL committer will be OK to push a patch to add support for UUIDv7 without an approved RFC. There is too much risk in finishing with a non-compliant behavior.

michaelpq avatar Mar 12 '24 06:03 michaelpq

Hi All In Postgresql after many revisitions uuid7 is approved for next version.

https://commitfest.postgresql.org/47/4388/

piervalli avatar Mar 29 '24 12:03 piervalli

RFC 9562 Universally Unique IDentifiers (UUIDs)

RFC: 9562 Obsoletes: 4122 Category: Standards Track Published: May 2024 ISSN: 2070-1721

basid-irk avatar May 09 '24 04:05 basid-irk