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

I updated drizzle from:

    "drizzle-orm": "^0.29.1",
    "drizzle-kit": "^0.20.6",

    "drizzle-orm": "^0.29.1",
    "drizzle-kit": "^0.20.6",

    "drizzle-orm": "^0.28.5",
    "drizzle-kit": "^0.19.3",

    "drizzle-orm": "^0.28.5",
    "drizzle-kit": "^0.19.3",

I updated my config to use the new

defineConfig

defineConfig

method and changed the

connectionString

connectionString

uri

uri

export default defineConfig({
  schema: "./src/server/db/schema.ts",
  driver: "mysql2",
  dbCredentials: {
    uri: env.DATABASE_URL,
  },
  tablesFilter: ["bun-loconta_*"],
});

export default defineConfig({
  schema: "./src/server/db/schema.ts",
  driver: "mysql2",
  dbCredentials: {
    uri: env.DATABASE_URL,
  },
  tablesFilter: ["bun-loconta_*"],
});

but now I am getting this error when I try to run drizzle-kit:

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

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

I dont use postgres, my driver is

mysql2

mysql2

using PlanetScale as DB provider.

my package.json - I am using

bun run

bun run

incase it matters:

"scripts": {
    "db:push": "dotenv drizzle-kit push:mysql",
    "db:studio": "dotenv drizzle-kit studio",
  },

"scripts": {
    "db:push": "dotenv drizzle-kit push:mysql",
    "db:studio": "dotenv drizzle-kit studio",
  },

Angelelz•12/5/23, 3:02 PM

Maybe you imported the drizzle function from "pg-core" by mistake?

Angelelz•12/5/23, 3:03 PM

I reproduction repo would be great to investigate

AAngelelz Maybe you imported the drizzle function from "pg-core" by mistake?

HocusOP•12/6/23, 11:17 AM

hmm nope, if that were the case, shoudn't it also fail in the previous version?

AAngelelz I reproduction repo would be great to investigate

HocusOP•12/6/23, 11:19 AM

will only be able to do this end of the week. But if you are down, bootstrap a project with https://create.t3.gg/ and update to latest drizzle version.

Create T3 App

The best way to start a full-stack, typesafe Next.js app.

Angelelz•12/6/23, 1:35 PM

You can try deleting your node_modules, lock file and installing everything again

HocusOP•12/6/23, 2:52 PM

I ended up switching to postgres, which then has thrown a missing "pg" dependency error. I installed it as a dev dependency now even though the rest of the app works without it. I assume studio needs it anyways but doesnt have it bundled itself?