Surprised to see Prisma doesn't natively support a driver for postgres.js https://www.prisma.io/docs

Tthomasgauvin Surprised to see Prisma doesn't natively support a driver for postgres.js https:...

M

mr nooli•10/21/24, 1:33 PM

I agree - but I'm also not an expert in the field and most of this goes straight over my head

I just want my app faster! It's very fast right now with Vercel's top level of function compute power, but I feel like it could be faster and ik that the pricing won't scale.

Mmr nooli I agree - but I'm also not an expert in the field and most of this goes straight...

T

thomasgauvinOP•10/21/24, 1:37 PM

@mr nooli actually, you should look into the new support for assets on workers https://developers.cloudflare.com/workers/frameworks/framework-guides/nextjs/

you could then use the 'pg' driver as recommended ('pg' is not supported on pages, only 'postgres')

Cloudflare Docs

Next.js | Cloudflare Workers docs

Create an Next.js application and deploy it to Cloudflare Workers with Workers Assets.

M

mr nooli•10/21/24, 1:39 PM

Ah, so this would mean deploying on workers? Does that include the CI pipeline from pages?

M

mr nooli•10/21/24, 1:39 PM

(Open next right?)

Mmr nooli Ah, so this would mean deploying on workers? Does that include the CI pipeline f...

T

thomasgauvinOP•10/21/24, 1:43 PM

Yes, I would recommend following the guide I linked to get a sample app up and connecting to your database to see if it's possible for you to migrate

M

mr nooli•10/21/24, 1:44 PM

I’ll give it a go tonight!

M

mr nooli•10/21/24, 1:44 PM

But also worth me questioning if it’s worth it as I had managed to get a very small part of my app running on next on pages and it matched the page speed (the web dev page speed insights) as my Vercel app.

M

mr nooli•10/21/24, 1:44 PM

It should be faster in theory right?

Mmr nooli It should be faster in theory right?

T

thomasgauvinOP•10/21/24, 8:20 PM

I don't know the specifics of your stack so I can't confirm if it would be faster or not. Hyperdrive makes it faster for you to connect to a regional database from global workers

M

mr nooli•10/21/24, 9:22 PM

Let's give it a go and find out ig!

M

mr nooli•10/21/24, 10:09 PM

no dice! Just so many errors popping up!

I'm gonna give next-on-pages a go, and if there's no luck there I'm gonna just have to drop the idea of using CF for the mo

T

thomasgauvinOP•10/23/24, 3:37 PM

@mr nooli I think Pages should also have enhanced compatibility, you should use https://developers.cloudflare.com/workers/runtime-apis/nodejs/#get-started

Cloudflare Docs

Node.js compatibility | Cloudflare Workers docs

Node.js APIs available in Cloudflare Workers

A

AJR•10/25/24, 1:30 PM

New blog about the Hyperdrive Tunnel integration is out. It goes into some depth, if anyone has been curious about how it works.

https://blog.cloudflare.com/elephants-in-tunnels-how-hyperdrive-connects-to-databases-inside-your-vpc-networks/

The Cloudflare Blog

Elephants in tunnels: how Hyperdrive connects to databases inside y...

Hyperdrive (Cloudflare’s globally distributed SQL connection pooler and cache) recently added support for directing database traffic from Workers across Cloudflare Tunnels. We dive deep on what it took to add this feature.

M

Marat•10/25/24, 11:57 PM

Hello, has anyone faced "Internal Server Error" when creating Hyperdrive configuration?
I tested DB connection from server and local machine. All cloudflare ipv4 ranges where allow listed for accessing DB (https://www.cloudflare.com/ips/)
Also tryed

?ssl=true

?ssl=true

?ssl=true

?ssl=true and

?sslmode=require

?sslmode=require

?sslmode=require

?sslmode=require .
Any other hints how to fix the problem?

IP Ranges | Cloudflare

This page is intended to be the definitive source of Cloudflare’s current IP ranges.

T

TW•10/26/24, 2:54 AM

Does Hyperdrive support connecting from non-Cloudflare services (e.g. from Fly.io)? Because it seems that changes from CF Workers through Hyperdrive is not propagated immediately to the "bare" DB, so my service in Fly.io that connects directly doesn't see it yet

V

VIO•10/27/24, 3:27 PM

Hello there, I have a postgres db setup on a machine, a CF tunnel pointing to that db, and Acces service auth setup above all, is there a way to get the connection string by API and simply use that in a nodejs project?

O

okku•10/30/24, 3:22 AM

Hi, has anyone been experiencing caching problem on hyperdrive?
My website cannot connect to a database when connecting through hyperdrive. It looks like it is resolved for 5-10 mins after either switching on and off the caching.
Metrics reads fine, and it can connect to the database with cache and without cache, but it only works for 5-10 mins on both cases.

N

Nick•10/30/24, 11:36 AM

I try to setup Hyperdrive with a tunnel. Followed all the steps 3 times but get this error:
"Failed to connect to database using the provided information: Internal error."

On the server "cloudflared tail --level debug" and in the dashboards 'Access authentication logs' i dont see anything happen.
Tunnel status on dashboard says "Healthy".
Everytime i try to setup it up in Application > Policies a policy is automaticly created.
First time I run "cloudflared tail --level debug" i got the error "Cannot determine default origin certificate path." which i fixed with this

T

thomasgauvinOP•10/30/24, 7:27 PM

Hyperdrive update:

2024-10-30: New Hyperdrive configurations to private databases using Tunnels are validated before creation to make it easier to troubleshoot connectivity issues

https://developers.cloudflare.com/hyperdrive/platform/changelog/#2024-10-30

S

SteffTek•11/4/24, 12:11 PM

Hey guys! I have a small problem with hyperdrive. I want to test it with a local postgres instance in docker, to which I can connect without problems, but my worker script says it's failing to authenticate due to bad password. Same connection string works with drizzle for migrations

A

AJR•11/4/24, 1:07 PM

Interesting. Same connection string works in hyperdrive?

What username and password did you provide when making your Hyperdrive? I wonder if there was some shell escaping or something that caused it to not have your DB password stored correctly?

AAJR Interesting. Same connection string works in hyperdrive? What username and pa...

S

SteffTek•11/4/24, 1:19 PM

yeah sorry im just incredibly stupid. the db controller that fires first somehow still had the old d1 object as param and typescript screamed at me and i just ignored it...

A

AJR•11/4/24, 1:30 PM

Heh. Happens to the best of us. Good luck!

D

DoggeSlapper•11/6/24, 6:59 PM

I'm trying to use hyperdrive with neon drizzle & postgresjs but I'm getting

✘ [ERROR] Uncaught (async) Error: write CONNECT_TIMEOUT 2a4a9d73ee44058fe7577f3b613e1ae9.hyperdrive.local:5432

✘ [ERROR] Uncaught (async) Error: write CONNECT_TIMEOUT 2a4a9d73ee44058fe7577f3b613e1ae9.hyperdrive.local:5432

✘ [ERROR] Uncaught (async) Error: write CONNECT_TIMEOUT 2a4a9d73ee44058fe7577f3b613e1ae9.hyperdrive.local:5432

✘ [ERROR] Uncaught (async) Error: write CONNECT_TIMEOUT 2a4a9d73ee44058fe7577f3b613e1ae9.hyperdrive.local:5432

D

DoggeSlapper•11/6/24, 7:18 PM

I been trying pg & postgresjs but cant manage to cconnect

D

DoggeSlapper•11/6/24, 7:31 PM

I have reduced to:

const sql = postgres(env.HYPERDRIVE.connectionString, { ssl: true });
const result = await sql`SELECT * FROM pg_tables;`;
console.log(result);

const sql = postgres(env.HYPERDRIVE.connectionString, { ssl: true });
const result = await sql`SELECT * FROM pg_tables;`;
console.log(result);

const sql = postgres(env.HYPERDRIVE.connectionString, { ssl: true });
const result = await sql`SELECT * FROM pg_tables;`;
console.log(result);

const sql = postgres(env.HYPERDRIVE.connectionString, { ssl: true });
const result = await sql`SELECT * FROM pg_tables;`;
console.log(result);

Without SSL true I get

✘ [ERROR] Uncaught (in promise) PostgresError: connection is insecure (try using `sslmode=require`)

✘ [ERROR] Uncaught (in promise) PostgresError: connection is insecure (try using `sslmode=require`)

✘ [ERROR] Uncaught (in promise) PostgresError: connection is insecure (try using `sslmode=require`)

✘ [ERROR] Uncaught (in promise) PostgresError: connection is insecure (try using `sslmode=require`)

A

AJR•11/6/24, 7:31 PM

Is your database configured with

ssl=on

ssl=on

ssl=on

ssl=on?

D

DoggeSlapper•11/6/24, 7:31 PM

When I have it enabled I get timeout error

Uncaught (in promise) Error: write CONNECT_TIMEOUT f86bad4f8437b66de3bf8efae5264dd3.hyperdrive.local:5432

Uncaught (in promise) Error: write CONNECT_TIMEOUT f86bad4f8437b66de3bf8efae5264dd3.hyperdrive.local:5432

Uncaught (in promise) Error: write CONNECT_TIMEOUT f86bad4f8437b66de3bf8efae5264dd3.hyperdrive.local:5432

Uncaught (in promise) Error: write CONNECT_TIMEOUT f86bad4f8437b66de3bf8efae5264dd3.hyperdrive.local:5432

A

AJR•11/6/24, 7:32 PM

SSL is required to be configured for databases Hyperdrive connects to.

AAJR SSL is required to be configured for databases Hyperdrive connects to.

D

DoggeSlapper•11/6/24, 7:32 PM

it's ?sslmode=require

D

DoggeSlapper•11/6/24, 7:34 PM

I'm trying to use neon with hyperdrive from local

DDoggeSlapper it's ?sslmode=require

A

AJR•11/6/24, 7:34 PM

That's the client-side request mode. Is the database itself set up with SSL?

AAJR That's the client-side request mode. Is the database itself set up with SSL?

D

DoggeSlapper•11/6/24, 7:39 PM

afaik neon uses ssl right?

D

DoggeSlapper•11/6/24, 7:41 PM

export WRANGLER_HYPERDRIVE_LOCAL_CONNECTION_STRING_HYPERDRIVE= my connection string
pnpm run dev

export WRANGLER_HYPERDRIVE_LOCAL_CONNECTION_STRING_HYPERDRIVE= my connection string
pnpm run dev

export WRANGLER_HYPERDRIVE_LOCAL_CONNECTION_STRING_HYPERDRIVE= my connection string
pnpm run dev

export WRANGLER_HYPERDRIVE_LOCAL_CONNECTION_STRING_HYPERDRIVE= my connection string
pnpm run dev

With ssl I get TIMEOUT

D

DoggeSlapper•11/6/24, 7:47 PM

Error: write CONNECT_TIMEOUT 00cb16054d82c846e02014158175759c.hyperdrive.local:5432
    at connectTimedOut (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:259:20)
    at done (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:1035:8)
    at new Query (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/query.js:35:9)
    at sql (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/index.js:113:11)
    at null.<anonymous> (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:104:27)
    at async Promise.all (index 0)
    at async Object.queue (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:97:3) {
  code: 'CONNECT_TIMEOUT',
  errno: 'CONNECT_TIMEOUT',
  address: '00cb16054d82c846e02014158175759c.hyperdrive.local',
  port: 5432,
  query: undefined,
  parameters: undefined,
  args: [],
  types: null
}

Error: write CONNECT_TIMEOUT 00cb16054d82c846e02014158175759c.hyperdrive.local:5432
    at connectTimedOut (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:259:20)
    at done (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:1035:8)
    at new Query (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/query.js:35:9)
    at sql (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/index.js:113:11)
    at null.<anonymous> (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:104:27)
    at async Promise.all (index 0)
    at async Object.queue (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:97:3) {
  code: 'CONNECT_TIMEOUT',
  errno: 'CONNECT_TIMEOUT',
  address: '00cb16054d82c846e02014158175759c.hyperdrive.local',
  port: 5432,
  query: undefined,
  parameters: undefined,
  args: [],
  types: null
}

Error: write CONNECT_TIMEOUT 00cb16054d82c846e02014158175759c.hyperdrive.local:5432
    at connectTimedOut (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:259:20)
    at done (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:1035:8)
    at new Query (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/query.js:35:9)
    at sql (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/index.js:113:11)
    at null.<anonymous> (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:104:27)
    at async Promise.all (index 0)
    at async Object.queue (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:97:3) {
  code: 'CONNECT_TIMEOUT',
  errno: 'CONNECT_TIMEOUT',
  address: '00cb16054d82c846e02014158175759c.hyperdrive.local',
  port: 5432,
  query: undefined,
  parameters: undefined,
  args: [],
  types: null
}

Error: write CONNECT_TIMEOUT 00cb16054d82c846e02014158175759c.hyperdrive.local:5432
    at connectTimedOut (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:259:20)
    at done (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/connection.js:1035:8)
    at new Query (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/query.js:35:9)
    at sql (file:///Users/leon/code/domainsHunter/node_modules/.pnpm/postgres@3.4.5/node_modules/postgres/cf/src/index.js:113:11)
    at null.<anonymous> (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:104:27)
    at async Promise.all (index 0)
    at async Object.queue (file:///Users/leon/code/domainsHunter/apps/workflows/src/index.ts:97:3) {
  code: 'CONNECT_TIMEOUT',
  errno: 'CONNECT_TIMEOUT',
  address: '00cb16054d82c846e02014158175759c.hyperdrive.local',
  port: 5432,
  query: undefined,
  parameters: undefined,
  args: [],
  types: null
}

A

AJR•11/6/24, 7:53 PM

Ohhh, this is local dev. You're using

wrangler dev

wrangler dev

?

AAJR Ohhh, this is local dev. You're using `wrangler dev`?

D

DoggeSlapper•11/6/24, 7:54 PM

yes I'm trying to connect to neon during my local development with hyperdrive

A

AJR•11/6/24, 7:55 PM

Got it. This is a known issue, fix is going out with the next

workerd

workerd

release.

A

AJR•11/6/24, 7:55 PM

https://github.com/cloudflare/workerd/pull/3037

GitHub

SQC-333: Support Hyperdrive with SSL in dev mode by ReppCodes · Pul...

We have historically used sslmode=disable in when running wrangler dev, with the intention of not forcing folks to set up SSL on a local test DB. Unfortunately this causes friction because many ho...

A

AJR•11/6/24, 7:56 PM

Sorry I don't have a better answer than that.

A

AJR•11/6/24, 7:56 PM

Workaround is to connect to PG locally on Docker or something, so you can develop in the meantime.

D

DoggeSlapper•11/6/24, 7:56 PM

ok ok, was getting crazy on this hehehehe

D

DoggeSlapper•11/6/24, 7:57 PM

I think a got an idea to make it work locally for now

A

AJR•11/6/24, 7:58 PM

I keep this one as an alias, I use it so much. Would need to load up your schemas too, if you have those as

.sql

.sql

files.

docker run -e POSTGRES_PASSWORD=password -p 5432:5432 postgres:16 -c ssl=on -c ssl_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem -c ssl_key_file=/etc/ssl/private/ssl-cert-snakeoil.key

docker run -e POSTGRES_PASSWORD=password -p 5432:5432 postgres:16 -c ssl=on -c ssl_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem -c ssl_key_file=/etc/ssl/private/ssl-cert-snakeoil.key

docker run -e POSTGRES_PASSWORD=password -p 5432:5432 postgres:16 -c ssl=on -c ssl_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem -c ssl_key_file=/etc/ssl/private/ssl-cert-snakeoil.key

docker run -e POSTGRES_PASSWORD=password -p 5432:5432 postgres:16 -c ssl=on -c ssl_cert_file=/etc/ssl/certs/ssl-cert-snakeoil.pem -c ssl_key_file=/etc/ssl/private/ssl-cert-snakeoil.key

D

DoggeSlapper•11/6/24, 7:59 PM

https://github.com/supabase-community/pg-gateway I think think I can make it work using this as a proxy

GitHub

GitHub - supabase-community/pg-gateway: Postgres wire protocol for ...

Postgres wire protocol for the server-side. Contribute to supabase-community/pg-gateway development by creating an account on GitHub.

D

DoggeSlapper•11/6/24, 8:00 PM

but will first test with local docker postgresql

AAJR I keep this one as an alias, I use it so much. Would need to load up your schem...

I

Isaac McFadyen•11/6/24, 8:06 PM

Is a key called

snakeoil

snakeoil

snakeoil

snakeoil actually built into the Docker container?

I

Isaac McFadyen•11/6/24, 8:06 PM

That's funny

A

AJR•11/6/24, 8:06 PM

It's a linux-ism.
https://eleni.blog/2019/04/10/the-snakeoil-ssl-certificate/

Eleni Fragkiadakiefrag

The snakeoil ssl certificate

I recently came across this one as part of a PostgreSQL upgrade I run on my Linux (Debian) box. Going from version PostgreSQL 9.4 to 9.5 worked like a charm. Upgrading to version 9.6 did not go as …

D

DoggeSlapper•11/6/24, 8:07 PM

Thanks @AJR now with local wrangler dev without ssl works fine, excited for new release.
Loving workers so far

Surprised to see Prisma doesn't natively support a driver for postgres.js https://www.prisma.io/docs

Similar Threads

Similar Threads

Similar Threads