Goodbye integers. Hello UUIDv7!

Buildkite has adopted the UUIDv7 standard as their primary key of choice, offering efficient indexing and external use. The company previously used sequential primary keys for indexing and UUID secondary keys for external use. However, the upcoming UUIDv7 standard provides time-ordered primary keys that can be utilized for both purposes. UUIDs are unique identifiers generated independently without coordination with other parties, making them preferable in sharded database environments. The adoption of UUIDv7 as the primary key eliminates the need for coordinated identifier generation and simplifies application logic.