Advice on how to use hyperdrive externally
From my understanding hyperdrive is meant to only accept traffic within the cloudflare network e.g workers
I am looking to access the hyperdrive connection string externally to lessen my latency, however that requires some work around
How would I approach this? My current idea is a worker that somehow can route requests to the hyperdrive and have it's own public connection string of sorts
however this is unlikely, as postgres in itself requires a TCP connection which afaik workers don't support
14 Replies
TLDR: I need to access hyperdrive outside of cloudflare via a postgres connection string, how do I do it?
I don't think this is possible. You could try exposing the connectionString of the current request via the Bindings, but I don't think that will work
yep that wouldn't work, the connection string that hyperdrive returns is not public to the internet (you get some hyperdrive.local URL which is not valid)
I'd love it too if cloudflare offered something like that
it isn't too far from just having an extra worker which proxies requests to hyperdrive, the only difference is that you can't use a postgres connection directly
which means TCP but workers should support that? (not sure)
Well iirc workers arent long lived so you'd have to reconnect every 30s (I might be wrong here) but maybe you could try sending the raw sql statements via https to the worker and then using the response as the result?
what about workers unbounded?
What was that again?
long living workers
Well I dont think you can connect via raw tcp to a worker at all
Maybe im not understanding what youre getting at
Cloudflare Docs
TCP sockets · Cloudflare Workers docs
Use the connect() API to create outbound TCP connections from Workers.
not sure if this is what I'm looking for
Workers can use tcp for example for postgres connections but you can't send tcp packets to them directly
they're outbound, from the worker, to something else
gotchu
hmm
this might sound silly, but maybe cloudflare tunnels could be part of the puzzle in some way
nvm they're outbound only