sqliteHow do I use UUIDs in SQLite?

UUIDs (Universally Unique Identifiers) can be used in SQLite to create a unique identifier for each row in a table. To use UUIDs in SQLite, you first need to create a table with a column to store the UUIDs. The following example creates a table named users with a column named uid to store the UUIDs:

CREATE TABLE users (
  uid UUID PRIMARY KEY,
  name TEXT
);

Then you can insert UUIDs into the table using the uuid() function. The following example inserts a row with a new UUID into the users table:

INSERT INTO users (uid, name) VALUES (uuid(), 'John Doe');

The uuid() function generates a version 4 UUID, which is composed of random numbers and letters.

Code explanation

• CREATE TABLE - creates a table with the specified columns and data types
• UUID - the data type used to store the UUIDs
• PRIMARY KEY - ensures that each row has a unique identifier
• INSERT INTO - inserts a row into the specified table
• uuid() - generates a new version 4 UUID

Helpful links

• UUIDs in SQLite
• SQLite Data Types

Edit this code on GitHub