Hacker News with Generative AI: UUID

Postgres UUIDv7 and per-back end monotonicity (brandur.org)
An implementation for UUIDv7 was committed to Postgres earlier this month. These have all the benefits of a v4 (random) UUID, but are generated with a more deterministic order using the current time, and perform considerably on inserts using ordered structures like B-trees.

Databases, UUID, Performance Optimization

230 points by craigkerstiens 16 days ago | 104 comments

Exploring Alternatives to UUIDv4; Enter ULIDs (jirevwe.github.io)
UUIDv4 is a commonly used unique identifier format. UUIDv4 is a standardized format for generating unique identifiers that are widely used in distributed systems. Recently there have attempts to introduce new identifier formats that are shorter, url-friendly, lexographically sortable, collision-safe during generation.

UUID, Unique Identifiers, Distributed Systems, Data Structures, Programming

43 points by noleary 20 days ago | 29 comments

TIL: Versions of UUID and when to use them (ntietz.com)

UUID, Programming, Software Development

310 points by fagnerbrack 145 days ago | 111 comments

UUIDv7: The Time-Sortable Identifier for Modern Databases (uuid7.com)

Databases, UUID, Time, Identifiers, Software

23 points by deisteve 147 days ago | 10 comments

ULID: Like UUID but Sortable (2019) (github.com/ulid)

UUID, IDs, Sorting, Open Source, Software

107 points by fagnerbrack 188 days ago | 57 comments

PostgreSQL and UUID as Primary Key (maciejwalkowiak.com)