主キーはもう「UUIDv7」一択なのか？ 〜 ID技術の歴史的変遷と現時点の最適解 〜

This page explores database primary key selection, tracing ID technology evolution from AUTO_INCREMENT to UUIDv7 as the modern best practice. Sequential IDs were simple and efficient but became bottlenecks in sharded and microservices architectures while posing security risks through ID predictability. The article recommends adopting UUIDv7 for internal database primary keys, while encoding externally exposed IDs with Base62 or NanoID for security. Various ID schemes are compared across time-sortability, distributed generation, predictability resistance, and database compatibility. For highly sensitive systems requiring timestamp obfuscation, CUID2 remains an alternative option.