@kian @elithrar @AJR Thanks for your responses. Is there a document that describes the pooling mech

@kian @elithrar @AJR Thanks for your responses.

Is there a document that describes the pooling mechanism? I am particularly interested in how prepared statements behave if I make two identical queries.

let res1 = client.query("SELECT * FROM FOO", &[]).await?;
let res2 = client.query("SELECT * FROM FOO", &[]).await?;

let res1 = client.query("SELECT * FROM FOO", &[]).await?;
let res2 = client.query("SELECT * FROM FOO", &[]).await?;

let res1 = client.query("SELECT * FROM FOO", &[]).await?;
let res2 = client.query("SELECT * FROM FOO", &[]).await?;

let res1 = client.query("SELECT * FROM FOO", &[]).await?;
let res2 = client.query("SELECT * FROM FOO", &[]).await?;

Would the statement prepared in the first query be cached? In other words, would Hyperdrive call

prepare

prepare

prepare

prepare twice (as in https://github.com/sfackler/rust-postgres/blob/98f5a11bc0a8e451552d8941ffa078c7eb6cd60c/tokio-postgres/src/to_statement.rs#L18, which is invoked from https://github.com/sfackler/rust-postgres/blob/98f5a11bc0a8e451552d8941ffa078c7eb6cd60c/tokio-postgres/src/client.rs#L363.

A bit of context:

I am in the process of supporting Cloudflare Worker for Exograph (https://github.com/exograph/exograph/pull/1081). It is working okay without Hyperdrive (high latency) and great with Hyperdrive (with a fork of tokio-postgres to avoid prepared statements: https://github.com/sfackler/rust-postgres/pull/1147).

I would like to determine the extent of Hyperdrive support to decide if there is value in continuing to use my fork. For example, if Hyperdrive reuses the prepared statement, then going with

query

query

query

query will be better (to be measured, of course). If not, my fork avoids an extra roundtrip.

Rramnivas @kian @elithrar @AJR Thanks for your responses. Is there a document that descri...

AJR•6/4/24, 7:27 PM

I don't think this is well documented. I'm happy to write up some explanation when I have some spare cycles. Hopefully today or tomorrow.

Short answer, it's complicated. We reuse the prepared statement if possible, or we re-send the parse on the new connection if not.

MMatt Silverlock @moody 💭 (I can't DM you) - https://www.cloudflarestatus.com/incidents/q23jjvwg...

moody 💭•6/4/24, 7:27 PM

ty. i think the no dms setting is on your end

AAJR I don't think this is well documented. I'm happy to write up some explanation wh...

ramnivasOP•6/4/24, 7:29 PM

That will be awesome. Thank you!

Kkian Yeah, like Matt linked to, that example uses `simple_query` intentionally. <htt...

ramnivasOP•6/4/24, 10:15 PM

Just a clarification: The use of simple_querysimple_query was required earlier (I believe until May 22 https://developers.cloudflare.com/hyperdrive/platform/changelog/#2024-05-22). With the prepared statement support in Hyperdrive, plain

query

query

also works with a caveat I mentioned (must turn on caching in Hyperdrive setting). The caveat is an issue in Hyperdrive (per @AJR), so once that is fixed, it will be all okay!

Cloudflare Docs

Changelog · Hyperdrive

You can now create up to 25 Hyperdrive configurations per account, up from the previous maximum of 10.

Paul•6/5/24, 3:44 AM

Is Hyperdrive smart enough to clear the cache of a SELECT query if a mutate has happened for that row? For instance, the user profile is cached but then they change their bio. If they refresh would they still see the old profile until “max-age”?

PPaul Is Hyperdrive smart enough to clear the cache of a SELECT query if a mutate has ...

Isaac McFadyen•6/5/24, 4:47 AM

max-agemax-age is related to browser-side caching using HTTP headers. Hyperdrive has no ability to purge the browser-side cache so no.

PPaul Is Hyperdrive smart enough to clear the cache of a SELECT query if a mutate has ...

AJR•6/5/24, 11:58 AM

Without getting into browser caching, no Hyperdrive does not do proactive cache purging after volatile queries. It's something we've discussed but would be a non-trivial feature to add and generally is not something users have asked for overmuch.

If you need to bypass cache on specific queries, we don't check cache on any volatile queries, so you could add any such function. For example including random()random() and ignoring that field in your result would do it.

If not purging cache on mutation is a dealbreaker feature for you, it would be helpful for us to understand a bit about your use case, if you'd be willing to chat about it.

AAJR Without getting into browser caching, no Hyperdrive does not do proactive cache ...

Isaac McFadyen•6/5/24, 1:24 PM

I'd also add that max-age is also browser-side along with server-side.

Isaac McFadyen•6/5/24, 1:24 PM

So even if Hyperdrive could purge the cache somehow (which seems like a bad idea IMO, a DB connection shouldn't be able to modify my CDN config) then it won't affect browser-side caching anyway.

Paul•6/5/24, 2:32 PM

Hmm seems to be a few caching layers here. Let’s say the user who owns the profile has edited it and expects to see the changes immediately. Is there a way to cache bust just for that user? (I’m not understanding how the browser cache plays along with the hyperdrive layer)

PPaul Hmm seems to be a few caching layers here. Let’s say the user who owns the profi...

Isaac McFadyen•6/5/24, 2:43 PM

So these are the cache layers I assume you have (correct me here if I'm wrong):

Browser cache, this is local on the user's web browser and based on max-agemax-age. This is quite tricky to bust and you usually disable this for APIs in favor of 2.
Server-side cache, this is the Cloudflare CDN and/or your server and/or the Worker that is serving the API requests. To purge this you need control of the Worker, or if it's the CDN cache you need to make an API call to the Cloudflare API. This is also based on maxagemaxage, but if you want to only cache on the server-side you can use s-maxages-maxage instead.
Hyperdrive query cache. I don't know many details on this, @AJR would know more about how cache busting works here.

Isaac McFadyen•6/5/24, 2:44 PM

Your original question was about whether a query in Hyperdrive would auto-cache-purge 1 or 2. It doesn't do that because it's a separate system and it's unintuitive/broken behavior if a database connection cache purges the other layers. The developer should have full control over whether that happens and if so, when and how.

AJR•6/5/24, 2:59 PM

That is all correct to the best of my understanding. My answer above about including a benign volatile function is the current best solution for cache busting point 3. We expect to add more polish on that front, though it isn't our highest priority at this time.

AAJR That is all correct to the best of my understanding. My answer above about inclu...

Isaac McFadyen•6/5/24, 3:39 PM

Ah completely missed the volatile function part - good to know.

IIsaac McFadyen So these are the cache layers I assume you have (correct me here if I'm wrong): ...

Paul•6/5/24, 4:06 PM

Thanks for the great write up!

IIsaac McFadyen Your original question was about whether a query in Hyperdrive would auto-cache-...

Matt Silverlock•6/5/24, 10:04 PM

I do think some things are being mixed up here:

Hyperdrive’s cache is only specific to Hyperdrive (per config ID). The maxagemaxage in Hyperdrive dictates that caches maximum TTL per unique query. It’s not a CDN cache and doesn’t cache any results in the browser. maxagemaxage is just a common name for a TTL-based cache configuration setting.
You can also use Cloudflare’s CDN cache from a Worker or Pages app, but there is no intersection with Hyperdrive (unless you actively choose to insert things into it).

MMatt Silverlock I do think some things are being mixed up here: 1. Hyperdrive’s cache is only s...

Isaac McFadyen•6/5/24, 10:05 PM

Ah, think you're right - apologies, thought this was referring to the maxagemaxage in the Cache-ControlCache-Control header.

Muudka•6/5/24, 11:48 PM

Hi, am a bit confused about hyperdrive, at the moment i have a node application that is deployed to aws lamda behind api gateway ,
I am using postgres db with prisma orm,
I have set up hyperdrive and run some test, how can I integrate it into my lambda deployment

MMuudka Hi, am a bit confused about hyperdrive, at the moment i have a node applicati...

Matt Silverlock•6/6/24, 1:57 AM

Where is your database? Hyperdrive is currently focused on making it faster to connect (and query) your database from Workers.

If you’re using Lambda and Aurora in the same region, it won’t make much sense here.

ramnivasOP•6/6/24, 2:01 AM

I have seen mentions in this/workers forum that Hyperdrive's

id

id

is not a secret, but I didn't find that mentioned in the documentation. It will be beneficial to have that mentioned officially.

MMatt Silverlock Where is your database? Hyperdrive is currently focused on making it faster to c...

Muudka•6/6/24, 6:34 AM

I am using postgtres on Neo.tech, does worker only work within the worker and how can it be incorporated into my code.
I am using prisma as ORM

MMuudka I am using postgtres on Neo.tech, does worker only work within the worker and ho...

thomasgauvin•6/6/24, 3:23 PM

@Muudka are you using AWS Lambda or Cloudflare Workers (I see mentions of both in this thread)? Which database vendor are you using/is it AWS RDS/Aurora?

Muudka•6/6/24, 3:26 PM

@thomasgauvin I am using AWS lambda behind api gateway with Postgres on neo.tech serverless db.

katopz•6/8/24, 3:28 AM

Do hyperdrive also work with PostgresML?

Rramnivas That will be awesome. Thank you!

AJR•6/10/24, 4:58 PM

Posting my response a little more publicly, for visibility's sake.

After looking into it, the way tokio-postgres implements prepared statements and the extended query protocol is rather different than how our supported drivers do it. We will work on adding support for extended queries in that driver, but it will not be very soon (lots of other big features we've committed to first). For the meantime, we recommend using simple queries with that driver. I'll check our docs and make sure that they offer similar guidance.

Note that while @ramnivas did see better behavior with caching, that's somewhat incidental and you're likely to still hit bugs using extended queries in tokio-postgres even with caching enabled.

Thank you @ramnivas for the excellent write-up!

ramnivasOP•6/10/24, 5:54 PM

@AJR Thanks for the update.

Meanwhile, for those who want to not use simple_querysimple_query , take a look at our fork (the exographexograph branch), which supports query_with_type_paramsquery_with_type_params that works well with Hyperdrive.

https://github.com/exograph/rust-postgres/tree/exograph

GitHub

GitHub - exograph/rust-postgres at exograph

Native PostgreSQL driver for the Rust programming language - GitHub - exograph/rust-postgres at exograph

thomasgauvin•6/11/24, 8:59 PM

@Olivier F @Florent funny you should ask! this is one of our main things in progress currently, we should setup a meeting to talk it through, get some of the details from your side and get your early feedback. These are my availabilities https://calendar.app.google/ynRoYiJudGqyGPRN9

Appointments

ramnivasOP•6/12/24, 5:31 PM

Check out our latest blog that makes use of Hyperdrive to improve latency:

https://exograph.dev/blog/cloudflare-workers

Exograph at the Edge with Cloudflare Workers | Exograph

We are excited to announce that Exograph can now run as a Cloudflare Worker! This new capability allows deploying Exograph servers at the edge, closer to your users, and with lower latency.

DanielZero•6/13/24, 5:05 PM

I use postgres.js (latest version 3.4.4), hyperdrive and supabase. Every now and then a query fails due to CONNECTION_CLOSEDCONNECTION_CLOSED Disabling the hyperdrive cache didn't help and I can't find any open issue on that topic in the postgres.js repo. Am I the only one?

Isak•6/13/24, 10:19 PM

Why does query latency fluctuate so much? It's normally around 60 ms but sometimes down to 10 ms for short periods.

IvanLisz•6/16/24, 4:44 PM

(pages + hyperdrive) question: Can i separate prod and development or do i need two accounts?

IvanLisz•6/16/24, 9:27 PM

"This repository is being used for a Cloudflare Pages project on a different Cloudflare account." Nop, not even that.

IvanLisz•6/16/24, 9:45 PM

forked and works

IIvanLisz (pages + hyperdrive) question: Can i separate prod and development or do i need ...

Walshy•6/16/24, 11:26 PM

You can use the production and preview environments, e.g.

[env.production]
[[env.production.hyperdrive]]
binding = "HYPERDRIVE"
id = "id-1"

[env.preview]
[[env.preview.hyperdrive]]
binding = "HYPERDRIVE"
id = "id-2"

[env.production]
[[env.production.hyperdrive]]
binding = "HYPERDRIVE"
id = "id-1"

[env.preview]
[[env.preview.hyperdrive]]
binding = "HYPERDRIVE"
id = "id-2"

Docs: https://developers.cloudflare.com/pages/functions/wrangler-configuration/#configure-environments

IvanLisz•6/18/24, 7:27 PM

but this means that I being a developer can switch my preview branch hyperdrive binding and access the production database, right?

kindaraffy•6/20/24, 10:04 PM

Hi, I believe you could run drizzle with both postgres-js and node-postgres drivers, or does this piece of the documentation relate to something else entirely? https://developers.cloudflare.com/hyperdrive/configuration/connect-to-postgres/#supported-drivers

Cloudflare Docs

Connect to PostgreSQL · Hyperdrive

Hyperdrive supports PostgreSQL and PostgreSQL-compatible databases, popular drivers and Object Relational Mapper (ORM) libraries that use those …

kindaraffy•6/20/24, 10:04 PM

https://orm.drizzle.team/docs/get-started-postgresql#supabase Step 3 shows how you could use the Postgres js driver with drizzle.

Drizzle ORM - PostgreSQL

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Kkindaraffy Hi, I believe you could run drizzle with both postgres-js and node-postgres driv...

Sam•6/21/24, 12:48 PM

I'm using drizzle myself with node pg (https://www.npmjs.com/package/pg). Everything is working correctly, or is that not your question?

kindaraffy•6/21/24, 3:12 PM

No I was just pointing out that the docs may potentially be misleading when it mentions drizzle only works with node postgres when you can run it using the recommended postgres-js client.

Kkindaraffy No I was just pointing out that the docs may potentially be misleading when it m...

AJR•6/21/24, 4:04 PM

Ah good catch, thank you!

Elektra•6/24/24, 4:10 PM

Is hyperdrive down?

Elektra•6/24/24, 4:11 PM

For the past 40 to 50 minutes. Out of nowhere I get cannot get it...failed to aquire a connection from the pool.

Elektra•6/24/24, 4:11 PM

Nothing changed. I haven't touched code for the last 6h ...

Elektra•6/24/24, 4:12 PM

All was working...and I can connect directly to the db.

@kian @elithrar @AJR Thanks for your responses. Is there a document that describes the pooling mech

Similar Threads