Post your Hyperdrive ID and I'll enroll you early, we're still teeing up the migration for everyone
Post your Hyperdrive ID and I'll enroll you early, we're still teeing up the migration for everyone
J707875b010bc457e9a80dfddb19ef919
JThanks!
JThis was created recently btw, so not sure if it already has the new version
AJust cut over for new configs last week, so it'd depend
Alet me check
AAh yeah, you're already on global pools
AMoving to thread
DIt is on CF’s ASN though iirc?
HIIRC it is on a CF ASN, but not the CF ASN
DAhhh… I definitely missed that. 
S
Hello~ I was reading about hyperdrive, and wanted to confirm something: is hyperdrive ONLY for accessing a database from workers, or can it be used for connecting from other type of distributed applications (that aren't hosted on Cloudflare?).I assume the answer is "nope, sorry!", since it looks like Hyperdrive operates as a worker binding, but just want to confirm.
AYes, that is correct. We've kicked around opening it up more, but have not committed to that yet. Hyperdrive operates as a standalone service, so it is technically possible, though would take some work.
If you're willing to discuss your use case a bit, it'd help us as we evaluate.
If you're willing to discuss your use case a bit, it'd help us as we evaluate.
D@AJR Hmm, I think I may have found a pretty bad bug. When you reconnect, are you doing a fresh DNS lookup, or are you maybe accidentally using a cached entry?
LHi, combining Hyperdrive with Neon, which connection strings is the recommended? With pool o without it?
DNeon suggestions without the pooler.
https://neon.tech/docs/guides/cloudflare-hyperdrive#retrieve-your-neon-database-connection-string
Cloudflare suggests with the pooler.
https://developers.cloudflare.com/hyperdrive/examples/neon/#neon-dashboard
https://neon.tech/docs/guides/cloudflare-hyperdrive#retrieve-your-neon-database-connection-string
Cloudflare suggests with the pooler.
https://developers.cloudflare.com/hyperdrive/examples/neon/#neon-dashboard
LI'm testing with pooler, but I'm get an error: "Connection terminated unexpectedly" on stress test. My next test will be without.... thanks!
Dtbh I've found Neon very unreliable in the past with connections.
LYes, I'm discover stranger things on stress scenarios.
AI, personally, think without the pooler will be a better experience
D@AJR As a sanity check, when I use the patch API, what happens to existing connections?
AIn most scenarios, a new pool will be created when you send traffic after the PATCH change to your configuration, and the existing connections will idle and then time out.
Dah dang, so that would deal with if the database password was expiring (since it would trigger a disconnect on the old pools), but wouldn't be useful for @AJR Hmm, I _think_ I _may_ have found a sadly
LHi, I'm working with Drizzle (node-postgres) + Hyperdrive + Neon, I'm trying with/without pooler's connection string and with/without SSL required in connection string... but, sometimes I receive an error: Connection terminated unexpectedly ... any ideas?
LI try with node-postgress pool configuration like: min = 0, idleTimeout=0, etc...
The error appears on stress scenarios (500 request in 10 seconds)
The error appears on stress scenarios (500 request in 10 seconds)
Dbeen thinking about this more; is there really no way to force close existing connections from the Hyperdrive side of things?
AWell, we'd need to build it. It'd be pretty doable, it's just not something we've had to do before.
ABut no, we don't currently have a "nuke this pool" button available to us.
AUnrelated: we've started teeing up migration of existing Hyperdrives to the new pool placement system. I love my demo page screencaps, so here y'all go.
DCould we have have the same/similar page that shows the stats like that for our Hyperdrives?
T@dave | ai.moda what do you think of hyperdrive's current analytics on latency? ie what are you looking to get out of this
Tpr incoming
DI'd be curious what my direct to database origin latency would be for this for example.
AIf you're in an experimenting mood, you can do vanilla TCP connections to your DB from Workers. It usually goes about as well as the demo page suggests so we don't suggest it, but it'd give you the easy comparison.
https://developers.cloudflare.com/workers/tutorials/postgres/
https://developers.cloudflare.com/workers/tutorials/postgres/
Cloudflare Docs
In this tutorial, you will learn how to create a Cloudflare Workers application and connect it to a PostgreSQL database using TCP Sockets and Hyperdrive. The Workers application you create in this tutorial will interact with a product database inside of PostgreSQL.
DThis is a prod Worker, I don't wanna attempt fate. 
Doh I would also like to see number of connections from Hyperdrive to the origin database.
It'd be fun to see "connections" from Workers to Hyperdrive too, but maybe not that useful.
It'd be fun to see "connections" from Workers to Hyperdrive too, but maybe not that useful.
T@Emilio this is what we were discussing
DI can see both parts being interesting especially when combined with transactions, so it's easy to spot if there are bottlenecks there
FHey folks. anyone has had success connecting to a fly.io hosted postgress via a tunnel? 
I setup an app with
But I'm not able to connect hyperdrive to it via the tunnel.
(Following this https://developers.cloudflare.com/hyperdrive/configuration/connect-to-private-database/#3-create-an-access-application-to-secure-the-tunnel)
However...if I setup a public IP and hit that directly... I can?
I setup an app with
cloudflaredBut I'm not able to connect hyperdrive to it via the tunnel.
(Following this https://developers.cloudflare.com/hyperdrive/configuration/connect-to-private-database/#3-create-an-access-application-to-secure-the-tunnel)
However...if I setup a public IP and hit that directly... I can?
Cloudflare Docs
Hyperdrive can securely connect to your private databases using Cloudflare Tunnel and Cloudflare Access.
AInteresting. I haven't tested with fly personally. Are you able to get it working with just psql across an arbitrary TCP tunnel to your DB, no hyperdrive in the loop?
My guess would be that the connectivity from your tunnel egress to your origin database isn't there, so cloudflared can't reach postgres
My guess would be that the connectivity from your tunnel egress to your origin database isn't there, so cloudflared can't reach postgres
Fseems to be the case @AJR
was right now pinging the fly.io folks also https://community.fly.io/t/cloudflared-tunnel-and-postgres/23927/4
if I setup a public IP on the DB, and connect via a xxxx.fly.dev url, i am able to connect with hyperdrive (no tunnel, same credentials).
and SSHing into another different machine in the same internal network, and runnning a psql into the db with the internal URL worksl (
But the issue comes from setting up the tunnel and not being able to hit the DB.
was right now pinging the fly.io folks also https://community.fly.io/t/cloudflared-tunnel-and-postgres/23927/4
if I setup a public IP on the DB, and connect via a xxxx.fly.dev url, i am able to connect with hyperdrive (no tunnel, same credentials).
and SSHing into another different machine in the same internal network, and runnning a psql into the db with the internal URL worksl (
psql postgres://user:pass@database.internal/db-name)But the issue comes from setting up the tunnel and not being able to hit the DB.
Fly.io
It might help if you could say more about your Postgres instance, why TLS is a hard requirement in this context, and the full details of the connection strings have been tried so far: both the cases that succeeded and the cases that failed. (* out any passwords, of course—and feel free to do the same for any names that you consider sensitive—b...
DDoes using
now()Yes. Any volatile function will disable caching for that query.
AYou can check in the
pg_proc catalog table what the provolatile designation for any given function is, if needed.
IWe have started seeing an increased number of
Error: write CONNECTION_CLOSED <id>.hyperdrive.local:5432 which look like peer timeouts from our DB side in the last couple of weeks (maybe more recently?)
RHi All, any idea when we can expect MySQL support
AASoon!
Dis sthe new pool placement system live yet?
AFor all new or updated Hyperdrives, yes. Also, we've begun backfilling to existing Hyperdrives. If you want yours bumped to the front of the line, just toss the ID here or in a DM and I'm happy to do so.