- Cloudflare Developers

MMatt Silverlock Does the Xata database have Postgres enabled? “Inactive” means we haven’t seen a...

dsp•8/4/24, 2:59 PM

The hyperdrive stabilished but a simple query run forever with no return. Using pgcli or psql I can connect and run the same query.

MMatt Silverlock Click to see attachment

dsp•8/4/24, 3:00 PM

Using postgres.js direct I can connect but with Hyperdrive, no way.

Ddsp Using postgres.js direct I can connect but with Hyperdrive, no way.

Matt SilverlockOP•8/4/24, 4:33 PM

Mind sharing your account ID and the ID of your Hyperdrive configuration? (both are safe to make public)

We’ll take a look. Wonder if something strange with Xata’s new Postgres connection support.

Igor•8/5/24, 9:46 AM

CockroachDB requires installing a client CA certificate, yet Cloudflare Hyperdrive doesn't support uploading your own certificates. How is anyone able to connect to CockroachDB with Hyperdrive? (getting the error PostgresError: server requires encryptionPostgresError: server requires encryption)

AJR•8/5/24, 12:39 PM

I'll let someone who knows more about Cockroach chime in if they know a way to accomplish this.

However we are planning to add support for custom CA verification. It's a complex feature so it won't be very soon, but it's on our roadmap (and near the top of it).

あ

ああ•8/5/24, 6:46 PM

How to use google alloydb with hyperdrive? I can't specify 0.0.0.0/0 as the public IP.
https://blog.cloudflare.com/it-it/hyperdrive-making-regional-databases-feel-distributed

The Cloudflare Blog

Hyperdrive: making databases feel like they’re global

Hyperdrive makes accessing your existing databases from Cloudflare Workers, wherever they are running, hyper fast.

MMatt Silverlock Mind sharing your account ID and the ID of your Hyperdrive configuration? (both ...

dsp•8/6/24, 5:59 PM

For sure. I'll share right now

Isak•8/6/24, 7:50 PM

Hey can someone help me with this? Why does query latency fluctuate so much

あああ How to use google alloydb with hyperdrive? I can't specify 0.0.0.0/0 as the publ...

あ

ああ•8/7/24, 1:49 AM

Is there a solution?

IIsak Hey can someone help me with this? https://discord.com/channels/5953179901913989...

thomasgauvin•8/7/24, 2:29 AM

Responded in thread

あああ Is there a solution?

thomasgauvin•8/7/24, 2:29 AM

Same here

Ccopper found on https://discord.com/channels/595317990191398933/1158330473655840859/115...

AJR•8/10/24, 9:50 PM

Folks use Hyperdrive with pages , see Aha, got it working, for anyone who runs for a recent example

AJR•8/10/24, 9:51 PM

The recent postgres.js work did a lot to unblock this, as the nodejs_compat flag works with postgres.js, and also with pages, which was I think one of the last blockers there

Mitya•8/13/24, 2:01 PM

Does Hyperdrive play nicely with Postgres transactions, or would they conflict in any way? I know Hyperdrive handles pooling, hence the question, whereas PG transactions depend on using a pool client, not on-the-fly, one-off queries.

MMitya Does Hyperdrive play nicely with Postgres transactions, or would they conflict i...

AJR•8/13/24, 2:03 PM

It works well with them but they do impose some costs.

We don't cache parts of transactions, so you'll always be serving from origin
The client holds the connection until the transaction completes or rolls back, which limits the amount of scaling available

AAJR It works well with them but they do impose some costs. 1. We don't cache parts o...

Mitya•8/13/24, 7:21 PM

Great, thanks for the info.

✅

✅BattlefieldDuck•8/15/24, 10:09 PM

Suggestion: Support mongodb in hyperdrive

Mitya•8/16/24, 10:10 AM

This may be more a general PG question, but asking here in case there's any HD implications/angle on it: is it advisable to cache the

Client

Client

instance on

req

req

, rather than create it for each query? i.e. instead of:

const runQ = async q => {
    const client = new Client(/* options */);
    await client.connect();
    return client.query(q);
}

const runQ = async q => {
    const client = new Client(/* options */);
    await client.connect();
    return client.query(q);
}

do:

const runQ = async (req, q) => {
    if (!req.client) {
        req.client = new Client(/* options */);
        await req.client.connect();
    }
    return req.client.query(q);
}

const runQ = async (req, q) => {
    if (!req.client) {
        req.client = new Client(/* options */);
        await req.client.connect();
    }
    return req.client.query(q);
}

MMitya This may be more a general PG question, but asking here in case there's any HD i...

Isaac McFadyen•8/16/24, 12:49 PM

No.

req

req

is new every time and the client will be recycled.

Isaac McFadyen•8/16/24, 12:49 PM

Also it's fine to recreate clients with Hyperdrive, it holds open connections for you.

IIsaac McFadyen Also it's fine to recreate clients with Hyperdrive, it holds open connections fo...

Hard@Work•8/16/24, 1:18 PM

I think they meant if a single Request runs multiple queries across different handlers

Isaac McFadyen•8/16/24, 1:18 PM

Oh I see

Isaac McFadyen•8/16/24, 1:18 PM

Then yeah, could work. I'd still be wary of mutating request state though... I've always been told not to do that by various frameworks

Isaac McFadyen•8/16/24, 1:19 PM

If Workers changes something internally on the request you have no guarantee that req.clientreq.client will still be unused (unlikely it will be but possible?)

IIsaac McFadyen Then yeah, could work. I'd still be wary of mutating request state though... I'v...

Hard@Work•8/16/24, 1:20 PM

Some frameworks do provide a "state" store somewhere that will be passed around, so I would use that if possible

HHard@Work Some frameworks do provide a "state" store somewhere that will be passed around,...

Isaac McFadyen•8/16/24, 1:20 PM

Yeah this

Isaac McFadyen•8/16/24, 1:20 PM

Hono calls it context, Fastify calls it state.

Isaac McFadyen•8/16/24, 1:20 PM

There's nothing workers-native though I don't think.

IIsaac McFadyen There's nothing workers-native though I don't think.

Hard@Work•8/16/24, 1:35 PM

Isn't the "official" one req.cfreq.cf?

Hard@Work•8/16/24, 1:36 PM

Like, as in, they don't guarantee that they won't put new stuff on it, but it will be passed around

HHard@Work Isn't the "official" one `req.cf`?

Isaac McFadyen•8/16/24, 1:36 PM

Yeah but that's even more likely to be overwritten.

Isaac McFadyen•8/16/24, 1:36 PM

I guess if you name your thing something obscure it'll work, but I can imagine a req.cf.clientreq.cf.client some day for some service or another.

moody 💭•8/16/24, 4:46 PM

seem to be experiencing an outage again, with hyperdrive connection latency spikes. is there anyone available who can look into it?

AJR•8/16/24, 4:49 PM

Let me take a look. Same config ID you'd previously sent?

AJR•8/16/24, 5:09 PM

Looks like the ID you'd sent previously is not seeing traffic. Please post or DM the one you're seeing issues with. I'm not seeing latency spikes globally, but individual configs certainly could be. Happy to take a look.

AAJR Looks like the ID you'd sent previously is not seeing traffic. Please post or D...

moody 💭•8/16/24, 7:11 PM

dmd

IIsaac McFadyen Oh I see

Mitya•8/19/24, 11:57 AM

Interesting - I've seen frameworks absolutely encourage storing things on

req

req

between middleware. Otherwise you'd have no option but to laboriously pass around manually a ton of data as function arguments.

HHard@Work I think they meant if a single Request runs multiple queries across different ha...

Mitya•8/19/24, 12:01 PM

Exactly.

MMitya Interesting - I've seen frameworks absolutely encourage storing things on `req` ...

Isaac McFadyen•8/19/24, 12:15 PM

Absolutely, but there's usually a property dedicated towards it.

Isaac McFadyen•8/19/24, 12:15 PM

ctx

ctx

or similar.

Ping for toast•8/19/24, 9:47 PM

https://www.cloudflarestatus.com/incidents/035gqnkz86zh
was there possibly downtime related to this

Elevated 1xxx Error Rates

PPing for toast https://www.cloudflarestatus.com/incidents/035gqnkz86zh was there possibly downt...

AJR•8/19/24, 9:49 PM

No, not for Hyperdrive. Not that I've seen or know of.

AAJR No, not for Hyperdrive. Not that I've seen or know of.

Ping for toast•8/19/24, 9:50 PM

odd. I know that they have the same ip pool so i was wondering because for about a minute i had connection timeouts

bs_sfalls•8/19/24, 11:21 PM

Seeing an interesting problem with workers, may or may not be a result of hyperdrive. I have an API implemented in workers with typescript and I'm running React in Pages. Some of my components load 2 different requests simultaneously. Sometimes, works fine, a lot of times, one of the requests receives a connection timeout from the DB. If I disable hyperdrive, the problem goes away. If I stagger the request by a second or two then there is no problem. Is it possible hyperdrive or workers cannot locate a connection in such quick succession? Should I serialize the requests?

Interestingly, I also see the problem locally with wrangler dev. Again, stagger the requests, no issue.

Bbs_sfalls Seeing an interesting problem with workers, may or may not be a result of hyperd...

Matt SilverlockOP•8/20/24, 12:29 AM

If you’re seeing it in dev - where Hyperdrive’s connection logic isn’t in place - it might be something else. Are you doing something odd with your driver/client code?

MMatt Silverlock If you’re seeing it in dev - where Hyperdrive’s connection logic isn’t in place ...

bs_sfalls•8/20/24, 5:22 PM

Nothing unique and no problems normally. The only issue is if I send off 2 simultaneous connections from react at roughly the same time. I see it in wrangler and I see it in workers production. Using Hono and Kysley. I'll dig a bit more, as of right now, just staggering the requests.

Bbs_sfalls Nothing unique and no problems normally. The only issue is if I send off 2 simu...

Ping for toast•8/20/24, 9:07 PM

I think its possible I'm experiencing this as well

Similar Threads