Hi folks. If you're encountering issues when trying to develop locally with Wrangler, please downgra

Hi folks. If you're encountering issues when trying to develop locally with Wrangler, please downgrade to 3.85.0. This is a known issue and a fix will be released soon.

https://www.cloudflarestatus.com/incidents/r6ltkr1t0vkr

Hyperdrive local development results in connection errors

Tthomasgauvin Hi folks. If you're encountering issues when trying to develop locally with Wran...

thomasgauvinOP•12/4/24, 12:33 AM

This fix has been released in Wrangler version 3.92.0. Please make sure to upgrade if you run into errors with connectivity.

This new version brings back support for localConnectionString for local development with Hyperdrive, with support for databases that do not require SSL.

Support for remote databases (which typically require SSL connectivity) and databases that require SSL more broadly is something we'll continue to work to bring to the Hyperdrive CLI.

Huxwell | Reown•12/4/24, 9:47 AM

Hey team, what's the best way of getting more context about these errors ?
Is there an API endpoint I can use to retrieve the error status and messages ?
Do I have to manually log the error on my worker ?

Capture_decran_2024-12-04_a_16.45.52.png

johtso•12/9/24, 11:33 AM

Is there any way to use hyperdrive without SSL?

johtso•12/9/24, 11:34 AM

I tried to enable SSL on my postgres database and for some reason it caused our infrastructure of janky old windows POS machines to fall over

flyingshoes•12/9/24, 3:30 PM

Hey team, I'm seeing an elevated amount of Error: Connection terminated unexpectedlyError: Connection terminated unexpectedly in our setup (hyperdrive enabled). We did ship some changes recently that increased some calls within a

waitUntil

waitUntil

function. Could that code be the reason why we are seeing more of these errors?

Original message was deleted

AJR•12/10/24, 2:55 PM

It's going to depend mostly on where you host your database and where your users are. Plus whether you cache or not. In general, Hyperdrive itself will add very minimal overhead, single-digit milliseconds generally. Latency for us is about network travel more than anything else.

Except for cache hits, those are stupid fast (and going to get way way faster :soonsoontm: ).

All that said, I think many folks see less than 80ms latencies, so I'd encourage you try it out for yourself.

AJR•12/10/24, 3:12 PM

Many users point Hyperdrive at Supabase with good success, if you do end up going with them.

Original message was deleted

AJR•12/10/24, 3:42 PM

Yes. The supabase-js client works well in a serverless environment like Workers, but can't take advantage of CF internals the way Hyperdrive can. So often folks find that postgres.js over Hyperdrive to Supabase ends up being a good fit for them.

AJR•12/10/24, 3:45 PM

Not that it makes a bunch of difference for your use case, but Hyperdrive is actually all Unix Sockets and RPC under the hood, at least until the queries egress back off our network. Much less overhead than HTTP, yeah.

Original message was deleted

Isaac McFadyen•12/10/24, 11:09 PM

Also the issue with Atlas wasn't HTTP but the fact that MongoDB Atlas actually ran on AWS Lambda, and their cold-start handling was suboptimal so you'd constantly get Lambda cold-starts :NotLikeThis:

Isaac McFadyen•12/10/24, 11:09 PM

HTTP works fine for DB queries but yeah a connection-oriented protocol is going to be better unless you have a reason to use HTTP

Isaac McFadyen•12/10/24, 11:10 PM

I'd also add that normally HTTP/1.1 and HTTP/2 has TCP Keep Alive which doesn't really exist in Workers because a Worker might be triggered on a different machine at any time and they can't really keep a connection alive the way you could from e.g. a Docker container

Isaac McFadyen•12/10/24, 11:10 PM

So you pay for the TCP (+ maybe TLS) handshake every time for HTTP too

Original message was deleted

thomasgauvinOP•12/11/24, 2:57 PM

@PatrickJ worth also trying out Hyperdrive + Supabase's Postgres db as well, some customers have done so with good success. You would need to use Hyperdrive as your pooler instead of Supabase's pooler, but that would ensure you have an edge-aware pooler with caching included

Original message was deleted

thomasgauvinOP•12/11/24, 5:41 PM

Yep, let us know how it goes.

AJR•12/11/24, 6:33 PM

Do you have a paid workers plan?
Try to use psql or similar to connect to with the connection string you're providing to the dashboard. Does it work as expected?

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

Hey all. New release just rolled out with a pretty huge performance improvement for cache hit latencies. This one took a lot of work, so I wanted to show it off.

Today also marks my 1-year on the team, and I happened to snag a screencap of our demo page in my first week or two. So, in classical fashion: how it started vs how it's going.

Walshy•12/11/24, 8:17 PM

@Hyperdrive Massive performance improvements made to Hyperdrive! See above

chapel1337•12/11/24, 8:17 PM

Areej•12/11/24, 10:22 PM

:fingerprint:

Rastislav₡ore•12/12/24, 8:44 AM

I tried Hyperdrive also, but it has some bugs with connectors. Overall not facing any performance issues. But if someone has question about code-related issues. I am here to answer.

RRastislav₡ore I tried Hyperdrive also, but it has some bugs with connectors. Overall not facin...

AJR•12/12/24, 1:51 PM

Would you care to elaborate on what bugs you're seeing?

AAJR Would you care to elaborate on what bugs you're seeing?

Rastislav₡ore•12/12/24, 2:48 PM

Thank you I elaborated about issues here: Deployment Issues on Cloudflare Pages with SvelteKit 5

But I am helping here also another people from Discord community, if they have any difficulties. Feel free to give me any questions.

Focux•12/12/24, 2:50 PM

i would love to being able to connect to a remote db from local

Focux•12/12/24, 2:50 PM

is there any eta about when that's gonna be supported?

FFocux is there any eta about when that's gonna be supported?

AJR•12/12/24, 2:51 PM

No hard ETA, I'm afraid. We took a shot at adding it recently and ran into some pretty serious unexpected behavior, so we are gonna have to come back to that when we have some real time to dedicate to it. It is still something we are hoping to add, but it is (apparently) more complicated than it sounds.

AAJR No hard ETA, I'm afraid. We took a shot at adding it recently and ran into some...

Rastislav₡ore•12/12/24, 2:53 PM

I am here for assistance, because other community members reach me out to help with it. Unfortunately I am block now, but helping them as much as I can.

FFocux is there any eta about when that's gonna be supported?

Rastislav₡ore•12/12/24, 2:54 PM

Do you have any connectors in your App? I am doing it using Drizzle

Focux•12/12/24, 2:58 PM

yeah, i'm using drizzle as well so i think i will need to fallback to an env var when developing locally

Rastislav₡ore•12/12/24, 3:06 PM

I did some trick with it. If you are using database as service quite easy to configure when running on process.env.NODE_ENV === 'development'process.env.NODE_ENV === 'development' then fallback to local. But implementation can differ on your app.

Picolé•12/12/24, 10:19 PM

is Hyperdrive included in the $5 plan for account wide or each website must have the $20 pro?

PPicolé is Hyperdrive included in the $5 plan for account wide or each website must have...

Isaac McFadyen•12/12/24, 10:29 PM

It's on the Workers Paid plan so the $5 account-wide.

kchro3•12/13/24, 2:03 AM

Hi folks, is anyone seeing unusually high latency right now? I am seeing issues in prod when making DB queries. I'm on the latest wrangler versions, and I haven't had issues w Hyperdrive recently

Hello, I’m Allie!•12/13/24, 7:04 AM

Does Hyperdrive cache in multiple locations, or only near your DB?

HHello, I’m Allie!Does Hyperdrive cache in multiple locations, or only near your DB?

AJR•12/13/24, 12:43 PM

Multiple locations. How many is increasing, but we have to briefly pause the rollout of that

moody 💭•12/13/24, 2:20 PM

i'm seeing random hyperdrive error spikes corresponding with 500s for specific routes on my api that i can't reproduce locally

moody 💭•12/13/24, 2:21 PM

it would be really nice to see what these errors are somehow

Mmoody 💭it would be really nice to see what these errors are somehow

AJR•12/13/24, 4:59 PM

What's getting fed back to your postgres client? Is there at least useful information there?

We have a track of work for improving error reporting in our dashboard. It's definitely something that needs more polish. Just a matter of balancing priorities.

dave•12/13/24, 5:09 PM

For Google Cloud SQL, has anyone here gotten IAM based auth working instead with a Worker?

dave•12/13/24, 5:11 PM

ah, seems like I can.. https://cloud.google.com/sql/docs/postgres/iam-logins?authuser=1#logging-in-as-a-user

dave•12/13/24, 5:11 PM

question though, how do I tell Hyperdrive that the password is gonna expire after x amount of hours?

dave•12/13/24, 5:26 PM

https://developers.cloudflare.com/workers/databases/connecting-to-databases/#_top:~:text=For%20services%20that%20require%20mTLS%20authentication%2C%20use%20mTLS%20certificates%20to%20present%20a%20client%20certificate.

Does this mean I can connect via mTLS?

Cloudflare Docs

Connect to databases · Cloudflare Workers docs

Learn about the different kinds of database integrations Cloudflare supports.

AAJR What's getting fed back to your postgres client? Is there at least useful inform...

moody 💭•12/13/24, 5:35 PM

hard to tell, i enabled the new cloudflare logging that will hopefully help

moody 💭•12/13/24, 5:37 PM

ah yeah there are many 'connection terminated unexpectedly' errors in the worker log

moody 💭•12/13/24, 5:37 PM

dave•12/13/24, 5:46 PM

✘ [ERROR] PostgresError: pg_hba.conf rejects connection for host "1.2.3.4", user "demo", database "eh", no encryption

✘ [ERROR] PostgresError: pg_hba.conf rejects connection for host "1.2.3.4", user "demo", database "eh", no encryption

dave•12/13/24, 5:46 PM

hmm

Hi folks. If you're encountering issues when trying to develop locally with Wrangler, please downgra

Similar Threads

Similar Threads

Similar Threads