Deno runtime support

[softbeehive]

Hi, first of all, thanks for tackling the complex problem of human-friendly ORM!

As I tried to integrate drizzle + neon for deno 2.0.2, I hit the roadblock with drizzle-kit. More details denoland/deno#19826 (comment).

deno run npm:drizzle-kit generate --dialect postgresql --schema ./src/db/schema.ts --out ./src/db/migrations

Failed to find Response internal state key
Error: Cannot find module 'drizzle-orm/pg-core'

💡 Do you consider distributing drizzle-kit as a binary?

Betting on node could be totally reasonable choice. But I've seen people talking about issues with studio, and drizzle-kit didn't work for me because it's written for the specific runtime. Do you see similar friction with Bun?

[tazmaniax]

I get that error when I run drizzle-kit generate without temporarily removing the npm: references from the import statements in the schema.ts file that are required when running under Deno but don't work when running from Node. Annoying but manageable.

UPDATE
I've just seen you're trying to run drizzle-kit through Deno which I haven't tried yet. Interestingly the error I get when I haven't removed the npm: is Error: Cannot find module 'npm:drizzle-orm/pg-core'. Your error didn't have the npm: in the module reference so I wonder if would work if you added that.

[softbeehive]

Good hint!
Do you use "bring your node_modules" with package.json or global deno cache install?

For the test I installed drizzle-kit globally via pnpm and ran without npm: prefix. Same thing, bin.cjs is using require().

deno.json

{
  "drizzle-orm": "npm:drizzle-orm@^0.35.2",
}

schema.ts

import { integer, pgTable, text, timestamp } from "drizzle-orm/pg-core"

[softbeehive]

The goal of the test was to run drizzle-kit generate in node runtime against my schema to rule out deno runtime issue. It does seem to be related to my imports. I kind of gave up for now and will use simple query tool without an ORM.

[tazmaniax]

when running in Deno I find I need to include npm: in the schema.ts import statement as well

import { integer, pgTable, text, timestamp } from "npm:drizzle-orm/pg-core"

When I'm running drizzle-kit I'm doing it under Node and then need to remove the :npm from the import statements in schema.ts

[softbeehive]

After some struggle, I figured out that adding flag --node-modules-dir helps

deno run --node-modules-dir --allow-env --allow-read --allow-sys --allow-write --allow-run npm:drizzle-kit generate --dialect postgresql --schema ./src/db/schema.ts --out ./src/db/migrations

[tazmaniax]

This is really good to know. Nice one