Skip to main content
Digital Garden · Technical Notes

Notes

A living collection of ideas, engineering deep dives, patterns, and practical insights learned while building real-world systems.

Sprout Early concepts & raw ideas
Budding Work in progress & growing
Evergreen Mature, deep dives & polished
Sprout
Architecture

Auto-Increment ID vs UUID: The Hidden Cost of Distributed Primary Keys

The article analyzes and compares three popular primary key strategies—Auto-Increment ID, UUIDv4, and UUIDv7—from a system architecture perspective, aiming to help engineers choose the optimal option based on write topology and access patterns rather than choosing by default.

Digital gardens are meant to be conversational. Disagree with a point or want to discuss further? Let's talk →