IDs are bearings of any DB UUIDv7  was inspired by ULID. Like ULID, it is a 128-bit identifier, containing a timestamp on the left side and random data on the right side. In databases and...

Habr offers insights into technology trends, programming languages, and IT industry news, providing articles, tutorials, and discussions for developers and tech enthusiasts. By exploring Habr's curated content, developers can stay updated with the latest advancements in software development, machine learning, and cybersecurity, as well as contribute to community-driven knowledge sharing. Whether you're a software engineer, data scientist, or tech blogger, Habr offers resources to expand your knowledge and stay connected with the global tech community.

habr

UUIDv7 is a 128-bit identifier inspired by ULID that combines timestamps with random data, offering superior performance and functionality compared to traditional auto-increment IDs and other identifier types. Key advantages include cryptographically secure generation, monotonicity guarantees, equivalent performance to bigint while eliminating key collision issues, and the ability to hide creation timestamps through offset options. The format supports various implementation strategies across databases like PostgreSQL and ClickHouse, with optimal storage achieved through binary format rather than string representation.

What May Surprise You About UUIDv7