Limited support for RFC 4122 compliant UUIDs:
- Generate a version 4 (random) UUID.
- Convert a 16-byte blob into a well-formed UUID string and vice versa.
Adapted from uuid.c by D. Richard Hipp.
Provides following functions:
Generates a version 4 (random) UUID as a string. Aliased as gen_random_uuid() for PostgreSQL compatibility.
sqlite> select uuid4();
c476b6e9-35f1-4afd-9552-704cd7edbe27
sqlite> select gen_random_uuid();
8d144638-3baf-4901-a554-b541142c152b
Converts a UUID X into a well-formed UUID string. X can be either a string or a blob.
sqlite> select uuid_str(randomblob(16));
fb6f9675-7509-d8b7-0891-00d4e6230894
Converts a UUID X into a 16-byte blob. X can be either a string or a blob.
sqlite> select hex(uuid_blob(uuid4()));
7192B1B452964E809500CF0364476CD3
sqlite> .load ./uuid
sqlite> select uuid4();