Having an issue with sqlite running `drizzle-kit generate`.

Having an issue with sqlite running drizzle-kit generate. I get the following output

drizzle-kit: v0.21.2


Please install latest version of drizzle-orm

drizzle-kit: v0.21.2


Please install latest version of drizzle-orm

Here are my dependencies:

dependencies:
@hono/node-server 1.11.1   hono 4.3.7                 
@hono/zod-validator 0.2.1  lucia 3.2.0                
arctic 1.8.1               oslo 1.2.0                 
better-sqlite3 10.0.0      prettier 3.2.5             
dotenv 16.4.5              zod 3.23.8                 
drizzle-orm 0.30.10        

devDependencies:
@tsconfig/node20 20.1.4
@types/better-sqlite3 7.6.10
@types/node 20.12.12
drizzle-kit 0.21.2

dependencies:
@hono/node-server 1.11.1   hono 4.3.7                 
@hono/zod-validator 0.2.1  lucia 3.2.0                
arctic 1.8.1               oslo 1.2.0                 
better-sqlite3 10.0.0      prettier 3.2.5             
dotenv 16.4.5              zod 3.23.8                 
drizzle-orm 0.30.10        

devDependencies:
@tsconfig/node20 20.1.4
@types/better-sqlite3 7.6.10
@types/node 20.12.12
drizzle-kit 0.21.2

2 Replies

amgauOP•7mo ago

import dotenv from "dotenv";
import type { Config } from "drizzle-kit";
dotenv.config();

export default {
  dialect: "sqlite",
  schema: "./src/lib/schema.ts",
  out: "./drizzle",
  dbCredentials: {
    url: process.env.DB_PATH!,
  },
} satisfies Config;

import dotenv from "dotenv";
import type { Config } from "drizzle-kit";
dotenv.config();

export default {
  dialect: "sqlite",
  schema: "./src/lib/schema.ts",
  out: "./drizzle",
  dbCredentials: {
    url: process.env.DB_PATH!,
  },
} satisfies Config;

Here is the drizzle config

feldrok•6mo ago

Hi, i'm having the same problem on an expo project... can't find anything to solve it, have changed several versions to no avail

Gaming

Programming

Having an issue with sqlite running `drizzle-kit generate`.