I raised that awhile ago, I was told that Hyperdrive doesn't need it and it's omitted to not confuse
I raised that awhile ago, I was told that Hyperdrive doesn't need it and it's omitted to not confuse users
NThanks!
A@Hyperdrive As promised, here's the channel ping for when improved postgres.js support has been released.
We'll be updating docs shortly, but TLDR:
We'll be updating docs shortly, but TLDR:
- default settings postgres.js should now be supported on par with node-postgres, with equivalently good performance
- if you pass
prepare: falsewhen making your connection in postgres.js, it'll be slower (less caching, can't take advantage of the prepared statement) but still correctly supported
JThis is awesome, thanks for the update!
K
AGood morning 
TTime to update the docs!
ITiny bug, the minimum postgres.js version mentioned that it should be 3.4.5, should this package still be published or should this version number actually be 3.4.4, since 3.4.5 doesn't exist (yet?), see here: https://developers.cloudflare.com/hyperdrive/configuration/connect-to-postgres/#supported-drivers
Cloudflare Docs
Hyperdrive supports PostgreSQL and PostgreSQL-compatible databases, popular drivers and Object Relational Mapper (ORM) libraries that use those …
Zrecommendation for supabase?
ZI also wonder what (If any) caching supabase is doing on their postgrest API
ACan't speak to the caching, but Hyperdrive operates in transaction mode itself. At the supabase level you'd be fine with session mode.
AHaving both in transaction mode means there's two sets of abstraction to keep in mind and you might run into differences in which things are handled.
ZThanks. What about rawdawg direct mode (No connection pooler)? Bad idea?
ZI feel like it would be a good idea (just intuitively, no evidence)
AIf you're putting Hyperdrive on top of that, direct mode is fine too. If you need to do some particularly heavy connection multiplexing, having the supabase knobs to turn might prove useful but in most cases shouldn't be necessary.
Z
Zwhatev I'll just get an ipv4 address
ZGitHub
REST API for any Postgres database. Contribute to PostgREST/postgrest development by creating an account on GitHub.
Zimagine I could run postgrest in a worker
Zit's haskell. maybe it could happen
Ehello anyone experiencing:
Database error: error: Failed to acquire a connection from the pool.
Database error: error: Failed to acquire a connection from the pool.
TAny details on this? Using Hyperdrive, what's the database provider, etc.?
EHi Thomas, I'm hosting my own instance of pg I'm using the recommended library for connecting. I never had any such issues before that's why I was asking. Been fine for the last 4 months since I've used it. I waited a bit then went to pgadmin to investigate (could have been my side, although I tested while waiting with other apis that I have apart from this worker and worked fine) and about 5 min after all was okay again. Went to the status page also of cloudflare but didn't see anything at the time. Maybe some transient error...
EBy the the the connections was not exhausted at all. I have the stock 100 and only 7 were active. Although I now don't recall seeing cloudflare mentioned on the connections... So not sure... Unfortunately I do see the errors in the dashboard but... I can't see anything else except from that log message that I was getting. So I don't really have much more information at the moment.
BWhile waiting for Cloudflare Tunnel support for Hyperdrive, are there any resources available about connecting to AWS RDS (via RDS Proxy) directly through a Cloudflare Tunnel from a worker?
IHelloo everyone 
I facing a puzzling situation. I have a postgres database that I am connecting to via hyperdrive that is run on a server with a firewall which has all of cloudflare's IP's whitelisted. When I trigger the cloudflare worker that uses hyperdrive to do database operations from my home (in Spain) this works. However this worker is a callback handler and whenever the service connects (from Slovakia) the database operations silently fail. I remember working with our sysAdmin to whitelist a different IP so my questions would be, is failure something to do with the firewall? What are the IP's that hyperdrive uses to connect to databases? Would these IP's be different between Spain and Slovakia. And if not does anyone have any idea what could be happening?
I facing a puzzling situation. I have a postgres database that I am connecting to via hyperdrive that is run on a server with a firewall which has all of cloudflare's IP's whitelisted. When I trigger the cloudflare worker that uses hyperdrive to do database operations from my home (in Spain) this works. However this worker is a callback handler and whenever the service connects (from Slovakia) the database operations silently fail. I remember working with our sysAdmin to whitelist a different IP so my questions would be, is failure something to do with the firewall? What are the IP's that hyperdrive uses to connect to databases? Would these IP's be different between Spain and Slovakia. And if not does anyone have any idea what could be happening?
RIs there a relationship between Hyperdrive cache settings and the use of prepared statements?
I am exploring Postgres through Rust (using the
p.s. This seems to have changed recently. Earlier,
I am exploring Postgres through Rust (using the
tokio-postgres crate) using the query method. This uses the extended query protocol. I am observing the following behavior. When the Hyperdrive cache is:- Disabled: All (or most) queries fail (the driver reports an
UnexpectedMessageerror). I suspect disabled caching makes Hyperdrive use one connection for preparation and another execution on another. Occasionally, it might use the same connection, leading to a successful query. - Enabled: All queries succeed. I suspect caching makes Hyperdrive choose the same connection it used to prepare the statement.
p.s. This seems to have changed recently. Earlier,
query would always fail regardless of the cache setting. So, I started working on a PR for the Postgres driver to make it work with Hyperdrive. But today, during testing that PR, I saw this behavior, thus this question.An asynchronous PostgreSQL client.
Mis something going on with cloudflare?
Mas of 2 hours ago my workers are performing terribly, same number of requests
MTwo questions for the CF Hyperdrive team:
- Given HD's caching capabilities, is it redundant to also utilise read replicas on my DB, or would they still be a good idea?
- Six months or so ago I and others noticed that HD had a bug whereby, if caching was enabled, sometimes queries returned erroneous results e.g. no rows where there should definitely be rows. I recall vaguely that a CF dev said this was acknowledged and a fix was scheduled. Did this happen, i.e. is it safe for me to re-enable caching? (I disabled it at the time due to this).
Thanks in advance.
Mi seem to be having serious performance issues with hyperdrive connected to a postgres db in hetzner.
why is latency like this? other graphs are relatively flat, but errors and latency are spiking and users are reporting slowness.
why is latency like this? other graphs are relatively flat, but errors and latency are spiking and users are reporting slowness.
PCan we get some verbiage on the Supabase + Hyperdrive setup page in regards to the Supabase pooler? Do we use the pooler connection string or the direct connection string from the Supabase Database settings page?
https://developers.cloudflare.com/hyperdrive/examples/supabase/
https://developers.cloudflare.com/hyperdrive/examples/supabase/
Cloudflare Docs
This example shows you how to connect Hyperdrive to a Supabase Postgres database.
Mall users reporting issues seem to be in asia
Pand so it begins... for some reason i am not able to see the HYPERDRIVE binding from getPlatformProxy within my SvelteKit hooks handler
ATaking a look now.
A- Depends on your use case. There's overlap in the problems they solve, certainly, but there's also reasons you might want both.
- Yes, the issue with caching returning empty results was resolved quite a while back
AWe recently added support for prepared statements. Caching should not interact with it in this way, no. I'll add a ticket for us to take a look at this.
RThanks. That's good to know. I guess https://developers.cloudflare.com/hyperdrive/configuration/connect-to-postgres/#transaction-and-statement-support needs to change to drop the limitation on PREPARE?
Cloudflare Docs
Hyperdrive supports PostgreSQL and PostgreSQL-compatible databases, popular drivers and Object Relational Mapper (ORM) libraries that use those …
ANot exactly. We support protocol-level prepared statements, like your driver uses. We do not parse out and manage it as a keyword right now. At some point if there's enough need we could but we don't see that a lot honestly
RAh, I see. Thank you for the clarification.
RBTW, a way to reproduce would be to take this example: https://github.com/cloudflare/workers-rs/blob/main/examples/tokio-postgres/src/lib.rs#L29 and change the line to use
query instead of simple_query.GitHub
Write Cloudflare Workers in 100% Rust via WebAssembly - cloudflare/workers-rs
MGitHub
Refs: #1017
Refs: #1044
This PR implements unnamed statements when querying the database. This is not a performance optimization. The library still uses a "prepared" statement in order to...
Refs: #1044
This PR implements unnamed statements when querying the database. This is not a performance optimization. The library still uses a "prepared" statement in order to...
M@moody 
(I can't DM you) - https://www.cloudflarestatus.com/incidents/q23jjvwggp78
(I can't DM you) - https://www.cloudflarestatus.com/incidents/q23jjvwggp78 - for clarity, we only have one report so far, but are investigating.
KYeah, like Matt linked to, that example uses
https://github.com/cloudflare/workers-rs/pull/569#issuecomment-2098304851
simple_query intentionally.https://github.com/cloudflare/workers-rs/pull/569#issuecomment-2098304851
R@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.
Would the statement prepared in the first query be cached? In other words, would Hyperdrive call
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
Is there a document that describes the pooling mechanism? I am particularly interested in how prepared statements behave if I make two identical queries.
Would the statement prepared in the first query be cached? In other words, would Hyperdrive call
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 will be better (to be measured, of course). If not, my fork avoids an extra roundtrip.