Interesting question/observation from this user: https://community.cloudflare.com/t/hyperdrive-postg

Interesting question/observation from this user: https://community.cloudflare.com/t/hyperdrive-postgres-js-not-caching-queries-with-parameters/786452?u=cherryjimbo. Not sure if there's an issue with their testing, or just a limitation? I would have expected both to be cached fine

JJames Interesting question/observation from this user: https://community.cloudflare.co...

AJR•4/5/25, 5:43 PM

That should be cacheable, yes. Wonder what's up there.

My first bet would be that they're using

prepare: false

prepare: false

, which causes postgres.js to behave in a way that would render most extended-protocol queries uncacheable, but that's just a guess.

JamesOP•4/5/25, 5:44 PM

Oh that's a great bet, good call

Isaac McFadyen•4/5/25, 5:44 PM

IIRC it used to be the recommendation to use

prepare: false

prepare: false

on certain DBs but no longer

IIsaac McFadyen IIRC it *used* to be the recommendation to use `prepare: false` on certain DBs b...

AJR•4/5/25, 5:46 PM

Yeah, before we added support for prepared statements you couldn't use postgres.js at all without it. Happy to have that sorted out now.

Walshy•4/5/25, 5:47 PM

Info like this is good for the knowledge bank and runbook

Isaac McFadyen•4/5/25, 5:49 PM

If it's not in the docs it might be a good addition to some sort of "troubleshooting" section too

AJR•4/5/25, 5:49 PM

Agreed. I think @thomasgauvin has added a section like that, or an FAQ, recently.

AJR•4/5/25, 5:49 PM

I'll check in with him and add a mention of it.

The Infinite•4/7/25, 9:32 PM

I can use hyperdrive with anything? Hmm, gotta try it out with Diesel

TThe Infinite I can use hyperdrive with anything? Hmm, gotta try it out with Diesel

AJR•4/7/25, 9:39 PM

Recommended drivers are postgres.js and node-postgres. For Rust use, I'd recommend tokio-postgres with the

query_typed

query_typed

and

query_simple

query_simple

patterns.

TThe Infinite I can use hyperdrive with anything? Hmm, gotta try it out with Diesel

AJR•4/7/25, 9:40 PM

We haven't tested with Diesel, so YMMV.

Cchimame We are currently investigating when this problem started, but when connecting to...

AJR•4/8/25, 2:54 AM

Nope, we're observing high latencies as well, as of about 21:00 UTC. Just adjusted some things and are seeing it come back down towards normal levels now.

AJR•4/8/25, 2:55 AM

It should be back to standard within an hour, at the rates we're seeing.

AJR•4/8/25, 3:01 AM

I'll update here when the changes are all the way out and we should be back to baseline (it's about halfway, right now).

AJR•4/8/25, 4:00 AM

Alright, looks like we're back to baseline latencies. CC @chimame

AAJR We haven't tested with Diesel, so YMMV.

The Infinite•4/8/25, 7:02 AM

Diesel uses sqlx under the hood I believe

The Infinite•4/8/25, 7:02 AM

I'd have to see

TThe Infinite Diesel uses sqlx under the hood I believe

AJR•4/8/25, 10:33 AM

Ah, I didn't know that. sqlx is not well supported today, I'm afraid.

It sends explicit Close messages that chew up an extra round trip instead of just dropping the connection and letting the origin DB garbage collect the prepared statements it generated, and that's not something we support currently. The bookkeeping for that is surprisingly complicated for a tx-mode pooler, and there would be a big performance penalty for doing it naively. I've poked at it a couple times.

AAJR Ah, I didn't know that. sqlx is not well supported today, I'm afraid. It sends...

The Infinite•4/8/25, 10:36 AM

It might be using tokio-postgres too though, I am really not sure

The Infinite•4/8/25, 10:36 AM

Since I am using Deadpool for pools with diesel-async

The Infinite•4/8/25, 10:38 AM

Well, aparently it uses libpg directly

The Infinite•4/8/25, 10:38 AM

This is the maintainer

The Infinite•4/8/25, 10:38 AM

I know him

The Infinite•4/8/25, 10:40 AM

I was wondering...

The Infinite•4/8/25, 10:41 AM

Wait I shall ask on #off-topic

Matt Silverlock•4/8/25, 1:00 PM

@Hyperdrive Two big ones today for Hyperdrive:

Hyperdrive now supports MySQL: https://developers.cloudflare.com/changelog/2025-04-08-hyperdrive-mysql-support/
... and it's now on the Workers Free plan: https://developers.cloudflare.com/changelog/2025-04-08-hyperdrive-free-plan/

AJR•4/8/25, 1:03 PM

Heyyyyy there we go. :soontm: has arrived! I can finally talk about MySQL stuff.

AJR•4/8/25, 1:20 PM

Ah, also. Here's a blog on now Hyperdrive actually works. We're finally able to really get into the weeds of it, and I had a blast writing this.

https://blog.cloudflare.com/how-hyperdrive-speeds-up-database-access/

The Cloudflare Blog

Pools across the sea: how Hyperdrive speeds up access to databases ...

Hyperdrive, Cloudflare's global connection pooler, relies on some key innovations to make your database connections work. We go deep into the details of what that looks like, in celebration of announcing its availability for Free Plan customers.

nubb•4/8/25, 1:24 PM

Cloudflare is the best

AAJR Ah, also. Here's a blog on now Hyperdrive actually works. We're finally able to...

Isaac McFadyen•4/8/25, 1:26 PM

This is a very neat blog post/deep dive, thank you!

Isaac McFadyen•4/8/25, 1:31 PM

I remember the SQC days :lul:

Isaac McFadyen•4/8/25, 1:31 PM

We never knew what it was and had to guess what the acronym was when it showed up :lul:

IIsaac McFadyen I remember the SQC days :lul:

AJR•4/8/25, 1:33 PM

Funnily enough I didn't join Cloudflare until after it had a product name, so I kept wondering what this competing product was I kept seeing references to in code/docs. Eventually someone noticed and clued me in....

MMatt Silverlock @Hyperdrive Two big ones today for Hyperdrive: * Hyperdrive now supports MySQL: ...

thomasgauvin•4/8/25, 1:54 PM

Super excited for these two to land! We've been putting a ton of work to make Hyperdrive your go-to choice, looking forward to getting all the feedback!

<@235148962103951360>•4/8/25, 1:56 PM

cloudflare is the goat

<@235148962103951360>•4/8/25, 1:56 PM

Mmariano Great news!, I was trying to test it connecting to my MYSQL 8 server in a GCP in...

AJR•4/8/25, 2:50 PM

We tested in GCP and do support it. We also explicitly do support

mysql_native_password

mysql_native_password

. I'm surprised, that's basically the happy path for us.

@thomasgauvin first bit of beta feedback here. I'll defer to you on the best way to capture details here.

Nick•4/8/25, 3:02 PM

I'm super excited for mysql hyperdrive. I am wondering, there was a question a year ago about read replicas. It sounds like that's not necessarily supported right now?

AJR•4/8/25, 3:03 PM

Not at the moment, no. It's still something we're looking at doing, but no firm commitments on whether/when just yet.

Nick•4/8/25, 3:03 PM

okay, i guess one option is to have two clients, one for writing and one for reading, and use hyperdrive for writing?

AJR•4/8/25, 3:04 PM

That's one option. It's probaly more performant to have hyperdrive for both, imo. Just point the reading configs at your replicas. Our internal teams do it that way for the moment.

Nick•4/8/25, 3:05 PM

okay, if i have geographically distributed read replicas is it smart enough to have endpoints in multiple regions?

Nick•4/8/25, 3:05 PM

or would i need to know which read replica to point to?

AJR•4/8/25, 3:06 PM

Ah. Unfortunately the second one, for now. That gap is why we're considering building in proper support.

Nick•4/8/25, 3:06 PM

right, gotcha

Nick•4/8/25, 3:07 PM

im not sure if planetscale has a way to point to a specific replica, will need to dig into it. thanks!

AAJR Ah. Unfortunately the second one, for now. That gap is why we're considering b...

kunal•4/8/25, 4:01 PM

For now, we have multiple hyperdrives (one for each replica), and use the cf geolocation headers to pick the right DB. But would be very excited to get rid of that custom logic and let Cloudflare route to the actual closest DB

Interesting question/observation from this user: https://community.cloudflare.com/t/hyperdrive-postg

Similar Threads