Sorry if this is a naive question. I saw on [How Hyperdrive works | Hyperdrive](https://developers.c

Sorry if this is a naive question. I saw on How Hyperdrive works | Hyperdrive that

SET

SET

SET

SET statements aren't supported. In that case, how would I perform an

UPDATE

UPDATE

statement without using a

SET

SET

SET

SET statement?

Cloudflare Docs

How Hyperdrive works | Hyperdrive

Connecting to traditional centralized databases from Cloudflare’s global network which consists of over 300 data center locations

presents a few challenges as queries can originate from any of these locations.

Bbennycondon Sorry if this is a naive question. I saw on [How Hyperdrive works | Hyperdrive](...

kian•10/11/24, 11:13 AM

You might be confusing the

SET

SET

keyword within an

UPDATE

UPDATE

statement with the unrelated

SET

SET

statement

kian•10/11/24, 11:13 AM

The

SET

SET

statement is for changing run-time configuration: https://www.postgresql.org/docs/current/sql-set.html

bennycondonOP•10/11/24, 11:15 AM

I was confusing the two. Thanks so much for the help kian!

yevgen•10/14/24, 10:38 AM

New how-to configuration for Hyperdrive https://developers.cloudflare.com/hyperdrive/configuration/rotate-credentials/

Cloudflare Docs

Rotating database credentials | Hyperdrive

You can change the connection information and credentials of your Hyperdrive configuration in one of two ways:

Aalgads I assume the limitation on SETs is only if they are issued as separate commands....

AJR•10/18/24, 3:54 PM

This is a scenario where the Postgres syntax is a bit unfortunate. SET in the context of UPDATE commands (keyword) and SET in the context of session state management (statement) are entirely unrelated, from the message protocol all the way down to the internals and back. They just happen to share the same name.

SET ROLE and such that are for session state management are going to be a problem, almost regardless of how you wrap them. We've done work to make the system more resilient, so you might get lucky, but generally I'd avoid those.

The SET keyword in the context of UPDATE statements is fine, go nuts with it.

AJR•10/18/24, 3:58 PM

I will say that the root cause of problems here is polluting state on shared/pooled connections, so if you scope that state pollution such that by the time your query resolves everything is back how it started, it seems to me that you're less likely to have problems. If you can make it work for your use case, we certainly aren't going to stop you. But it's not something we support so, y'know, we won't be able to help you much. And we do reserve the right to change things in ways that might break that workflow if we need to. Kind of "undefined behavior, in the programming languange sense" territory.

thomasgauvin•10/18/24, 4:39 PM

Hey folks! It's great seeing all the feedback for Hyperdrive with private databases using tunnels, if you've been trying out and using it for the past few weeks, we want to learn more about your experience.

Likewise, if you've been using Hyperdrive, would love to chat 20-30 mins to better understand how you're using Hyperdrive, what are some of your asks around feature updates, how your performance has been, etc.

We have a bunch of improvements under way to improve compatibility (custom certs

) and performance and we want to make sure we're taking in your feedback! Here's my calendar -> https://calendar.app.google/b3w5dNYQj9YANw449

Appointments

dvddvd300•10/19/24, 5:07 AM

Hi, its there an updated timeline for MySQL support? (like early/beta/unstable access)
(MariaDB 10, 12GB database, ~ 200 Read Query/day)
tks

Ddvddvd300 Hi, its there an updated timeline for MySQL support? (like early/beta/unstable a...

AJR•10/19/24, 11:14 AM

Not a timeline we can share publicly yet, no.

I'll say that nobody has beta access yet, but when we get that ready we'll be asking/DMing folks. If you're interested I'll keep a note to see about reaching out to you.

We have to land custom cert support and some pretty important perf work first before we add on new features of that scale.

Also, please do hit up @thomasgauvin so he can get some details about your use case. We want to make sure that when we do ship MySQL support we don't miss features of it that a bunch of people need.

marcbejar•10/19/24, 10:13 PM

Hi! I'm trying to set up a VPS with Postgres via docker compose and then bind it in a worker via Hyperdrive.

I have followed the instructions line by line except when setting up the public hostname: instead of localhost:5432 -> postgres:5432.

When the API calls the Hyperdrive returns 504 (Gateway Timeout) to the client. To make sure the DB is working, I have tried to access the database from the VPS console through postgres:5432 and it works fine.

Any suggestions?

ZZak @ insertchat.com Hey @Matt, is it possible to use HyperDrive without using workers? My project is...

mr nooli•10/20/24, 10:40 PM

Hey! Seems like this has already been asked, but I wanted to ask if there's been any updates - I want to test hyperdrive with my vercel (nextjs) project. I have plans to switch to cloudflare, but don't have the bandwidth (

) to fix all the bugs that'll come up in the migration - yet. Either way I want to test if hyperdrive can speed up my platform by any means.

Mmr nooli Hey! Seems like this has already been asked, but I wanted to ask if there's been...

AJR•10/21/24, 12:43 AM

Short answer is that this isn't something that's likely to happen any time soon. While I wouldn't close the door on it ever happening, it's not on our radar for the time being.

mr nooli•10/21/24, 12:44 AM

Okay cool! Not an issue - is it something that would work well once I’ve deployed my next app on cloudflare?

mr nooli•10/21/24, 12:44 AM

As in, can I use the binding with my next app?

AJR•10/21/24, 12:44 AM

Sorry, which binding is that? Not sure I'm following.

Mmr nooli As in, can I use the binding with my next app?

marcbejar•10/21/24, 7:30 AM

I think you are looking for this:
https://developers.cloudflare.com/workers/frameworks/framework-guides/nextjs/

Cloudflare Docs

Next.js | Cloudflare Workers docs

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

Mmarcbejar I think you are looking for this: https://developers.cloudflare.com/workers/fram...

mr nooli•10/21/24, 8:23 AM

Yep, exactly! The hyperdrive plugin with next on pages or open next

mr nooli•10/21/24, 9:26 AM

That’s really interesting actually, I tried to use the neon driver with open next @marcbejar but ran into this issue, https://github.com/cloudflare/next-on-pages/issues/605#issuecomment-2419842548

is this something that hyperdrive would fix?

GitHub

[🐛 Bug]: `pg` does not work · Issue #605 · cloudflare/next-on-pages

next-on-pages environment related information System: Platform: linux Arch: x64 Version: #202312122204 SMP PREEMPT_DYNAMIC Tue Dec 12 22:43:56 UTC 2023 CPU: (16) x64 AMD EPYC 7B13 Memory: 63 GB She...

marcbejar•10/21/24, 9:48 AM

@mr nooli If you are using Hyperdrive with a NEON connected to it, cloudflare recomends using postgres instead of neon driver or pg. See:

https://developers.cloudflare.com/hyperdrive/examples/neon/

Cloudflare Docs

Connect to Neon | Hyperdrive

Connect Hyperdrive to a Neon Postgres database.

mr nooli•10/21/24, 10:00 AM

Ah that's really interesting, I'm unfortunately using supabase and as far as I can see prisma doesn't support the postgres driver! They do however support neon and pg, and pg has been buggy from day 1! I've not been able to get it to work at all.

AJR•10/21/24, 12:50 PM

We support pg and postgres.js drivers. Both work very well as standalones, but depending on what Prisma is doing with them it may not cooperate.

I don't know if we've evaluated the neon driver. We all use and love neon as a product, might be worth giving it a look. I'll mention to our product folks and see what they think.

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

That would be really useful! I want to migrate the opennext but I'm just running into a bunch of bugs, that I'm clueless on how to fix!

AJR•10/21/24, 1:02 PM

Unfortunately I'm far from the JavaScript ecosystem expert in our department. If you are finding bugs, please do file issues. I know that our library folks are very invested in making this a good experience

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

Issue is, I've done it before and for a small time I was on next-on-pages but whenever I encountered an issue, I would tell prisma and then prisma would tell cf and then it'd end up going nowhere. Most of the issues that come up are bc of prisma not playing nice with cloudflare/adapters etc.

AJR•10/21/24, 1:07 PM

Ahhh. Yeah, I can appreciate that.

Mmr nooli Ah that's really interesting, I'm unfortunately using supabase and as far as I c...

thomasgauvin•10/21/24, 1:32 PM

Surprised to see Prisma doesn't natively support a driver for postgres.js https://www.prisma.io/docs/orm/overview/databases/database-drivers

Might be something worth talking with them about

Database drivers | Prisma Documentation

Learn how Prisma connects to your database using the built-in drivers and how you can use Prisma along with other JavaScript database drivers using driver adapters (Preview)

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

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...

thomasgauvin•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.

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

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

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...

thomasgauvin•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

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

I’ll give it a go tonight!

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.

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

It should be faster in theory right?

Mmr nooli It should be faster in theory right?

thomasgauvin•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

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

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

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

thomasgauvin•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

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.

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 and ?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.

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

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?

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.

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

thomasgauvin•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

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

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...

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...

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

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

Sorry if this is a naive question. I saw on [How Hyperdrive works | Hyperdrive](https://developers.c

Similar Threads