UUIDv47: Database-Friendly UUIDs with Sortable Ordering and API Compatibility

2025-09-17
UUIDv47: Database-Friendly UUIDs with Sortable Ordering and API Compatibility

UUIDv47 ingeniously stores sortable UUIDv7 in databases while presenting a UUIDv4 façade to APIs. It achieves this by XOR-masking the UUIDv7 timestamp with a keyed SipHash-2-4 stream linked to the UUID's random bits. This offers database efficiency and API compatibility. The C library is easy to integrate, featuring key-recovery resistance for enhanced security.

Development