By Freddy ·
A UUID (Universally Unique Identifier) is a 128-bit value used to identify information without requiring a central authority to hand out the ids. “GUID” (Globally Unique Identifier) is the same thing under a different name, coined by Microsoft; the two terms are used interchangeably.
A UUID is conventionally written as 32 hexadecimal digits split into five groups by hyphens, in the pattern 8-4-4-4-12, for example f47ac10b-58cc-4372-a567-0e02b2c3d479. That structure isn't arbitrary: certain digits encode the UUID's version and variant, which is how software can tell a v4 UUID apart from a v5 one just by looking at it.
The short version: an auto-incrementing integer needs a single authority handing out the next number, which falls apart the moment more than one system is creating records independently. A UUID sidesteps that entirely by being generated with no coordination and a practically zero chance of collision. The full tradeoffs, storage cost, index fragmentation, when an integer is still the better call, are their own topic, covered in UUID vs Auto-Increment ID: Which Should Your Database Use?
Need to generate some? The GUID / UUID Generator on this site creates v1, v4, and v5 identifiers in bulk, entirely in your browser. Nothing is sent to a server.