Is there Hyperdrive Support?

I'd like to use hyperdrive to manage the connections to my postgresql instance.
I'm using sveltekit with adapter-cloudflare.

Can I use Hyperdrive with cloudflare pages?

PPaul I'd like to use hyperdrive to manage the connections to my postgresql instance. ...

Chaika•2/3/24, 1:30 AM

Pages doesn't support the hyperdrive binding

PaulOP•2/3/24, 1:31 AM

Why not? Any ETA?

PaulOP•2/3/24, 1:31 AM

That basically means we are locked to neon database for pages deployments?

Chaika•2/3/24, 1:31 AM

Pages generally lags behind in bindings and worker features (like logpush)

Chaika•2/3/24, 1:32 AM

Could use a worker and a service binding from Pages to that worker

PaulOP•2/3/24, 1:33 AM

Is there a github issue I can track for support?

Chaika•2/3/24, 1:33 AM

afaik the pages team hasn't said they're working on it yet, hyperdrive is also still in beta. There is more stuff blocking it -- pg for example also requires node_compat which isn't possible in Pages, only Workers (Pages only has the nodejs compat flag, which is different)

PaulOP•2/3/24, 1:34 AM

I'm noticing that, i've been at it for a few hours trying to connect to a postgres instance from my CF Pages. Has anyone ever gotten this to work?

PaulOP•2/3/24, 1:35 AM

pg has dependencies on fs,tls and such, and it's complaining during build.

Chaika•2/3/24, 1:35 AM

yea you need node_compat which just isn't an option with Pages

PaulOP•2/3/24, 1:35 AM

Is there any way at the current moment I could use my postgres database in my CF Pages?

Chaika•2/3/24, 1:37 AM

I haven't tried it, but I know recently there was talk about this postgres driver which works with just the nodejs_compat flag: https://github.com/porsager/postgres/pull/796

Chaika•2/3/24, 1:37 AM

wouldn't have hyperdrive though

PaulOP•2/3/24, 1:38 AM

Do you know if Neon databases work in Cloudflare Pages?

Chaika•2/3/24, 1:41 AM

I use their serverless driver in Workers and it works ok, I don't think it requires node compat? It doesn't seem to say so

Chaika•2/3/24, 1:42 AM

Its using just https/websockets

PaulOP•2/3/24, 1:43 AM

This has been extremely helpful. Thanks for sorting this all out.

Chaika•2/3/24, 1:45 AM

yeaa sadly right now it's not a great experience, with the different node_compat and bindings support. Longer term there is plans on merging Pages & Workers into one unified project ("convergence"), but that's a while out. There was some talk of trying to get node_compat to Pages added but that PR is still stuck iirc

Chaika•2/3/24, 1:47 AM

if you're going to use neon there's a normal endpoint and a connection pooling endpoint, you'd want to use the connection pooling endpoint for Workers/Pages (short lived) -> https://neon.tech/docs/connect/connection-pooling

PaulOP•2/3/24, 2:17 AM

I've got it working with postgres that you linked from earlier, but now I'm wondering if I should only connect during the handler and disconnect after? -- or do you think it's okay to have a long lived database connection outside the handler scope?

PaulOP•2/3/24, 2:18 AM

I'm assuming if i initialize and connect from global scope, it can be re-used for any calls?

Chaika•2/3/24, 2:21 AM

usually rare for two different users to hit the same isolate/worker unless its the same person/browser keepalive

Chaika•2/3/24, 2:21 AM

and keeping promises and connections in the global scope causes issues

Chaika•2/3/24, 2:22 AM

that's part of the reason hyperdrive exists

PaulOP•2/3/24, 2:26 AM

Seems i'm venturing into unknown territory, perhaps i better switch to Neon

PaulOP•6/3/24, 10:51 PM

Any update on this @Chaika ?

Walshy•6/4/24, 12:06 AM

yes hyperdrive is supported

Walshy•6/4/24, 12:06 AM

I'm not fully sure if it's in the UI yet

Walshy•6/4/24, 12:06 AM

let me check wrangler..

Walshy•6/4/24, 12:08 AM

looks like wrangler does yes

Walshy•6/4/24, 12:08 AM

but not in the UI yet

Chaika•6/4/24, 12:11 AM

and postgres.js is fully supported now and just needs the nodejs_compat flag: hyperdrive, with a nice supported drivers list too: https://developers.cloudflare.com/hyperdrive/configuration/connect-to-postgres/#supported-drivers

PaulOP•6/4/24, 2:08 AM

BIG NEWS. Can’t wait to try this out. Now hopefully there are no unforeseen issues with SvelteKit and adapter-cloudflare

WWalshy yes hyperdrive is supported

PaulOP•6/4/24, 4:43 PM

I am unable to return the HYPERDRIVE binding from within the getPlatformProxy, any suggestions?

Walshy•6/4/24, 4:43 PM

@Dario do we support Hyperdrive in platform proxy?

Dario•6/4/24, 4:54 PM

mh... probably....

Dario•6/4/24, 4:55 PM

getPlatformProxygetPlatformProxy gets the configs to the toml file, passes them to miniflare and receives back proxies to the bindings, so it hyperdrive is supported in local (non-remote) mode then I think it should probably be supported by getPlatformProxygetPlatformProxy too...

Dario•6/4/24, 4:56 PM

sorry for the unsure answer... I guess we'd have to try to find out

(and document/test)

PaulOP•6/4/24, 5:20 PM

I have no idea haha, but i am seeing that hyperdrive is not included here: https://github.com/cloudflare/workers-sdk/blob/main/packages/wrangler/src/api/dev.ts

PaulOP•6/4/24, 5:22 PM

wrangler pages dev

wrangler pages dev

is working great for me, but since I am using SvelteKit i need to use npm run devnpm run dev, and there I am required to use getPlatformProxygetPlatformProxy in my hooks handler to get my platform env.

PaulOP•6/4/24, 5:29 PM

i can just have a slower iteration loop for now, at least i have it working for prod!!! this is big.

PaulOP•6/4/24, 5:30 PM

Please let me know if there are any issues i can subscribe to.

Walshy•6/4/24, 5:41 PM

looks like svelte has a pretty old wrangler - may be why it isn't there

WWalshy looks like svelte has a pretty old wrangler - may be why it isn't there

PaulOP•6/4/24, 5:42 PM

3.28.4?

Walshy•6/4/24, 5:42 PM

yep

PaulOP•6/4/24, 5:42 PM

...interesting...

Walshy•6/4/24, 5:42 PM

@Dario do we have comms with them? Can we get them to update?

WWalshy @Dario do we have comms with them? Can we get them to update?

Dario•6/4/24, 5:50 PM

yes we have, I can ping them

Dario•6/4/24, 6:04 PM

I can see that there wranglerwrangler is a peer dependency set as ^3.28.4^3.28.4 (https://github.com/sveltejs/kit/blob/25acb1d9fce998dccd8050b93cf4142c2b082611/packages/adapter-cloudflare/package.json#L47), so @Paul you should just be able to install the latest and svelte kit should pick that one up, no?

GitHub

kit/packages/adapter-cloudflare/package.json at 25acb1d9fce998dccd8...

web development, streamlined. Contribute to sveltejs/kit development by creating an account on GitHub.

PaulOP•6/4/24, 6:06 PM

Yep, i am seeing in my "node_modules" that wrangler is set to 3.59.0. I am still unfortunately not seeing the binding from getPlatformProxy though.

Is there Hyperdrive Support?

Similar Threads

Similar Threads

Similar Threads