DT
Drizzle Teamboggin

Drizzle + Sveltekit + Cloudflare + Supabase cannot get to work.

If I use Drizzle's docs, like : 
import { Pool } from "pg";
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
import { drizzle } from "drizzle-orm/node-postgres";
I get node module resolution errors like: 
node_modules/pg/lib/connection-parameters.js:3:18: ERROR: Could not resolve "dns"
node_modules/pg/lib/connection.js:3:18: ERROR: Could not resolve "net"
node_modules/pg/lib/connection-parameters.js:3:18: ERROR: Could not resolve "dns"
node_modules/pg/lib/connection.js:3:18: ERROR: Could not resolve "net"
If I follow Supabase's docs on connecting with drizzle, like: 
import { drizzle } from 'drizzle-orm/postgres-js'
import postgres from 'postgres'
import { drizzle } from 'drizzle-orm/postgres-js'
import postgres from 'postgres'
I get node module errors like: 
node_modules/postgres/cf/src/connection.js:1:23: ERROR: Could not resolve "node:buffer"
node_modules/postgres/cf/src/connection.js:6:19: ERROR: Could not resolve "node:stream"
node_modules/postgres/cf/src/connection.js:1:23: ERROR: Could not resolve "node:buffer"
node_modules/postgres/cf/src/connection.js:6:19: ERROR: Could not resolve "node:stream"
Cloudflare definitely says to use the newer colon-delimited name like node:stream, and I have followed all of Cloudflare's instructions for node compatibility, but these errors persist. Anyone have advice?
S
sizzF•161d ago
Add the option node_compat = true to wrangler.toml.
B
Brucey•131d ago
Did you try postgres-js instead of node-postgres for the drizzle import? Worked for me
B
boggin•131d ago
I tried adding in node_compat=true flag in the dashboard (I dont have a wrnagler file with Sveltekit) I'm not sure if I tried postgres-js (OP was too long ago to remember) I gave up and just started using Supabase's sdk which is certianly enough of an ORM, I was looking to keep the ORM flavor with drizzle. I will try this just for funsies though
MO
Mike Oristian•46d ago
having the same problem - tried with both postgres-js and pg library
Want results from more Discord servers?
Add your server
More Posts
Type for select with relations?Is it possible to infer select with relations? Currently im using: ```ts export let user: typeof usdrizzle + postgres + express + ts, errors<https://gist.github.com/barrybtw/67c379371c3f52a61758c94474e8ebf8> In regards to the route `auth_rrelation select query with where conditionI want to select all user's tasks where parent id is null. Can someone help me fix this query pleasDrizzle Studio with AWS Aurora ServerlessHello All! I am having some troubles to run the Drizzle Studio Console. I am using an AWS RDS Auroreslint-plugin-drizzle add "db" as defaultIs there a reason why it is automatically applied for every delete function? I think most users woulDoes Promise.all work correct in transactions?As I just found out, pg only works with one query (or more if there is more than one connection), soFindFirst Config Optional `with`Hi, I am trying to do something like an optional findFirst config here. i am expecting the resultTypSupabase primary key typeWhen I run `introspect`, the primary key of my tables look something like this: ```id: bigint("id", Supabase/postgres get query is stuck on prod appHi, I'm coming across an issue with my discord bot, I currently have a query that checks if an usercreate exportable types for frontend servicesI feel like I'm missing something fundamental. I can create my Drizzle schema `user = mysqlTable('u