Drizzle Team•13mo ago

Unable to generate migration for sqlite

Hello! After upgrading to drizzle-kit 0.20.2 from 0.19.13 I can't generate migrations anymore. I'm using libsql and the error when running

drizzle-kit generate:sqlite --schema=./src/schema/main.ts --out ./drizzle/migrations

drizzle-kit generate:sqlite --schema=./src/schema/main.ts --out ./drizzle/migrations

is about postgres:

Error: Cannot find module 'drizzle-orm/pg-core'

Error: Cannot find module 'drizzle-orm/pg-core'

Any ideas? Did the command changed? I'm not using drizzle.config file Thanks in advance!

"drizzle-kit": "^0.20.2",
"drizzle-orm": "^0.29.0",

"drizzle-kit": "^0.20.2",
"drizzle-orm": "^0.29.0",

My schema uses

import { InferSelectModel, sql } from 'drizzle-orm'
import { sqliteTable, text, blob, index } from 'drizzle-orm/sqlite-core'

import { InferSelectModel, sql } from 'drizzle-orm'
import { sqliteTable, text, blob, index } from 'drizzle-orm/sqlite-core'

If I try to downgrade to the working version, it won't allow me:

drizzle-kit: v0.19.13
drizzle-orm: v0.29.0

This version of drizzle-kit is outdated
Please update drizzle-kit package to the latest version 👍

drizzle-kit: v0.19.13
drizzle-orm: v0.29.0

This version of drizzle-kit is outdated
Please update drizzle-kit package to the latest version 👍

4 Replies

hugoOP•13mo ago

Update: seems like a build error. I can see drizzle-orm/pg-core in my node_modules Update 2: I'm on a turborepo and for some reason drizzle-orm was installed in a package's node_module instead of the repo's node_module. It works if I add drizzle-orm as a root dependency but seems weird to do that

Ben-xD•12mo ago

I see the same thing, I think pg is now accidentally required for drizzle, even for sqlite projects? Edit: updating dependencies fixed it, though migration files are empty

novadlaya•12mo ago

Same thing for me How can we resolve it?

val•11mo ago

getting the same issue

Gaming

Programming

Unable to generate migration for sqlite