Is is possible to auto-generate UUID primary key field?

[Angelelz]

Similar to how serial('id') work, I was wondering if there is a way to create an id field with default value set by JS, something like the following:

export const user = mysqlTable(
  "User",
  {
    id: varchar("id", { length: 191 })
      .primaryKey()
      .default(crypto.randomUUID())
      .notNull(),
    name: varchar("name", { length: 191 }).notNull(),
    ...
  },
  (table) => {
    return {
      ...
    };
  }
);

Thanks for the help.

[AndriiSherman]

It's not possible right now, but will be possible soon

[205g0]

But does this feature makes really sense? UUID generation is usually on app-level anyway, DBs need different UUIDs, e.g. MySQL needs an lexicographically ordered one (such as ULID or ObjectID) because of its clustered index while Postgres doesn't, then there are different UUID types with all "official" UUID versions being not the best (cumbersome, long, with dashes and so on).

I would focus on other stuff.

[Angelelz]

But does this feature makes really sense?

This probably shouldn't be at the top of the list but would definitely be a nice feature as the user can decide how to do it in the schema.
The user can just provide a function to call for the ID on any insert for the table.

[205g0]

Yeah but again, choosing the right UUID is like choosing the right religion. There's no right or wrong and it should be done on app-level anyway. The only reason is if you want so save it as binary and still have a string representation (compare Mongo's ObjectId) then it's good to have some helper on db side which auto converts your string to binary and also saves it as a binary. You can do this now the same with wrapped functions but it's def. not nice. So, I'd see here the need but again, this needs to be thought-through very well and even then, won't work for every db right because of different requirements.

[Angelelz]

This would be an APP LEVEL feature. Dev would provide what function to call for ID generation. I just noticed it's in the pipeline.

[satya1395]

+1 on this feature.

[mamlzy]

+1

[tanjunior]

+1.

something like how prisma does it with @default(cuid())

[DenisBessa]

Won't something like this work?

export const table = pgTable(
  "table",
  {
    id: uuid("id").defaultRandom().notNull(),
    // ...
  }
);

[MariuzM]

This worked for me i'm using Supabase and i see that in its UI its also set to generate random uuid

[Angelelz]

This has been implemented in v0.28.3 but you'll need to update to v.28.5. The new .$default and .$defaultFn methods lets you register a function that will be called on insert/update if not value is passed.

[kjjd84]

as of latest version this works:

id: uuid().primaryKey().defaultRandom(),

[Cyrus-0101]

Unfortunately I get an error:

I have imported v4 from UUID v4 but it doesn't work.

What works is crypto.randomUUID()

[amateur-hacker]

You have to import uuid from drizzle-orm

import { uuid } from "drizzle-orm/pg-core";

and recommending to use new syntax, below is an example from my use case.

import { pgTable } from "drizzle-orm/pg-core";

const analytics = pgTable("analytic", (t) => ({
  id: t.uuid().notNull().primaryKey().defaultRandom(),
  userUUID: t.uuid().notNull(),
  eventName: t.varchar({ length: 256 }).notNull(),
  data: t.jsonb().notNull(),
  timestamp: t.timestamp({ mode: "date" }).notNull().defaultNow(),
}));

type Analytic = Omit<typeof analytics.$inferInsert, "timestamp" | "id">;
export { analytics, type Analytic };

[benbonnet]

if migration already happened with the id as another type than uuid;
drop / recreate the table as drizzle wont handle a change in the id column type

[ahmedandriod9-ai]

Hi, I built something similar on my website — you can check it out here:(https://uuidguidgenerator.com/)

[HenriqueStocco]

Similar to how serial('id') work, I was wondering if there is a way to create an id field with default value set by JS, something like the following:

export const user = mysqlTable(
  "User",
  {
    id: varchar("id", { length: 191 })
      .primaryKey()
      .default(crypto.randomUUID())
      .notNull(),
    name: varchar("name", { length: 191 }).notNull(),
    ...
  },
  (table) => {
    return {
      ...
    };
  }
);

Thanks for the help.

This way it worked for me:

import { v4 as uuidv4 } from 'uuid'
import { binary, mysqlTable, text, varchar } from 'drizzle-orm/mysql-core'

export const testTable = mysqlTable('test', {
  id: varchar('id', { length: 16 })
    .primaryKey()
    .$default(() => uuidv4()),
  id2: binary('id', { length: 16 })
    .primaryKey()
    .$default(() => uuidv4()),
  id3: text('id')
    .primaryKey()
    .$default(() => uuidv4()),
})