- What is UUID?
- UUID (Universally Unique Identifier) is a 128-bit unique identifier. Format: 8-4-4-4-12 hex characters (e.g., 550e8400-e29b-41d4-a716-446655440000). Versions: UUID v1 (timestamp + MAC address), UUID v4 (random), UUID v5 (namespace + name hash). Collision probability: Nearly 0 (2^122 possibilities). Use cases: Database primary keys, Distributed system IDs, Session tokens, File names. UUID is identical to Microsoft's GUID.
- Difference between UUID v1 and v4?
- UUID v1: Timestamp + MAC address based. Advantages: Time-ordered, Can extract creation time. Disadvantages: Exposes machine info, Security vulnerability. UUID v4: Completely random. Advantages: High security, No info exposure. Disadvantages: Not time-ordered. Recommendation: v4 for general use (security), v1 if time-ordering needed. This tool generates v4 by default.
- Does UUID guarantee uniqueness?
- UUID is practically unique (collision probability extremely low). UUID v4 collision probability: Generating 1 billion, collision chance < 0.0000001%. 50% collision at 2^122 generated. Reality: Generating 1 billion/second for 85 years with no collision. UUID v1: Timestamp + MAC provides higher uniqueness. Recommendation: Duplicate checking unnecessary but critical systems should use DB unique constraints.
- Should I use UUID as database key?
- Advantages: Globally unique (merge multiple DBs), Generate without collision, Suitable for distributed systems, Unpredictable (security). Disadvantages: Larger than auto-increment integer (16 bytes vs 4/8), Index performance degradation (random insertion), Difficult to read. Recommendation: UUID for distributed systems, Auto-increment for single server. Optimization: Store UUID as BINARY(16), Use ordered UUIDs (UUIDv1 or ULID).
- How to store and use UUID?
- Storage formats: String (36 chars with hyphens), BINARY(16) (native format, space-efficient), CHAR(32) (no hyphens). Databases: MySQL: BINARY(16) + UUID_TO_BIN(), PostgreSQL: UUID type, MongoDB: BinData(subType=4). Programming: JavaScript: crypto.randomUUID(), Python: uuid.uuid4(), Java: UUID.randomUUID(). Best practices: Store as BINARY, Convert to string for display, Index if needed, Consider removing hyphens for URLs.