Connecting to CockroachDB serverless using pg via ...
# workers-helpb
Bamboo
05/11/2023, 6:55 AM1. Created a npx wrangler init .
2. Then "npm install pg" and added the query code into index.js
3. then, npx wrangler dev, got compatibility errors, and got suggestions to add "node_compat = true", and I did, those errors disappeared
4. Then again ran "npx wrangler dev", got error ' **could not resolve "pg-native**" '. And this is where I'm struck. I ran same code in normal js and it worked, but I don't know why is it asking "pg-native", and also I tried to install it locally and globally, and it won't get installed.
5. What to do?
s
Skye
05/11/2023, 6:59 AMPG will need TCP connections which aren't yet available in workers
Skye
05/11/2023, 6:59 AMThere's been lots of work around TCP in the runtime's repo, so hopefully we'll see something coming out soon!
b
Bamboo
05/11/2023, 7:00 AMany other immediate solution?
s
Skye
05/11/2023, 7:00 AMIf you can connect to the database over http(s), that'll work
Skye
05/11/2023, 7:01 AMSome examples are planetscale, supabase, neon, etc.