Drizzle TeamDT
Drizzle Team•3y ago
Nicolas

Issue Pushing Schema to Turso

Hi All,

I made a schema.ts with sqliteTable statements, and I created a 
drizzle.config.ts
 as follows:
import { Config } from "drizzle-kit";

export default {
  driver: "turso",
  dbCredentials: {
    url: "libsql://[TABLE]-[GITHUB].turso.io",
    authToken:
      "[TOKEN]",
  },
  schema: "./schema.ts",
  out: "./out",
} as Config;


And when I try running pnpm drizzle-kit push:sqlite, I get the following error regarding that it cannot find module better-sqlite3:

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

node:internal/modules/cjs/loader:1048
  const err = new Error(message);
              ^

Error: Cannot find module 'better-sqlite3'
Require stack:
- /workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs
    at Module._resolveFilename (node:internal/modules/cjs/loader:1048:15)
    at Module._load (node:internal/modules/cjs/loader:901:27)
    at Module.require (node:internal/modules/cjs/loader:1115:19)
    at require (node:internal/modules/helpers:130:18)
    at node_modules/.pnpm/@libsql+client@0.1.6/node_modules/@libsql/client/lib-esm/sqlite3.js (/workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:43596:37)
    at __init (/workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:9:56)
    at node_modules/.pnpm/@libsql+client@0.1.6/node_modules/@libsql/client/lib-esm/index.js (/workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:51852:5)
    at __init (/workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:9:56)
    at src/cli/commands/sqliteIntrospect.ts (/workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:51875:5)
    at __init (/workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs:9:56) {
  code: 'MODULE_NOT_FOUND',
  requireStack: [
    '/workspaces/reserve-power/node_modules/.pnpm/drizzle-kit@0.19.13/node_modules/drizzle-kit/index.cjs'
  ]
}

Am I not pushing the schema properly with the command drizzle-kit push:sqlite?

Thank you!
Was this page helpful?