Drizzle Migrations

[hffmnn]

Hi,

do drizzle migrations work? Looks like they don't work out of the box? drizzle-team/drizzle-orm#1267 (comment)

[tpschmidt]

Migrations do work for me. Did you try the example in the repository?

[hffmnn]

Doesn't work for me, here's what I did:

• pnpm install
• updated .env file with CLUSTER_IDENTIFIER (for already existing cluster)
• npm run db:schema:generate // generate the migrations
• npm run db:schema:migrate // apply the migrations

And the error (as described in the linked drizzle ticket appears):

applying migrations...error: type "serial" does not exist

[tpschmidt]

Yes, you're absolutely right.

I've just used push, which works fine for creating your initial set of tables.