Hyperdrive: making databases feel like t...

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.
10 Replies
thomasgauvin
thomasgauvin4mo ago
AlloyDB does seem postgres compatible, are you able to obtain a publicly accessible connection string to use with Hyperdrive?
$0
$0OP4mo ago
The cloudflare blog mentioned above states the following:
Hyperdrive works not only with PostgreSQL databases — including Neon, Google Cloud SQL, AWS RDS, and Timescale, but also PostgreSQL-compatible databases like Materialize (a powerful stream-processing database), CockroachDB (a major distributed database), Google Cloud’s AlloyDB, and AWS Aurora Postgres.
Hyperdrive works not only with PostgreSQL databases — including Neon, Google Cloud SQL, AWS RDS, and Timescale, but also PostgreSQL-compatible databases like Materialize (a powerful stream-processing database), CockroachDB (a major distributed database), Google Cloud’s AlloyDB, and AWS Aurora Postgres.
The documentation does not include instructions on how to connect to AlloyDB, so I am trying the same method as Google Cloud SQL. https://developers.cloudflare.com/hyperdrive/examples/google-cloud-sql/
Cloudflare Docs
Connect to Google Cloud SQL · Hyperdrive
This example shows you how to connect Hyperdrive to a Google Cloud SQL PostgreSQL database instance.
Isaac McFadyen
Isaac McFadyen4mo ago
So AlloyDB should give you a connection string for AlloyDB, and then you'll also have to whitelist the IP address that Hyperdrive uses. You're correct though, because it's not fixed you'll have to whitelist 0.0.0.0/0... and AlloyDB doesn't let you do that?
$0
$0OP4mo ago
Hello, I get an error.
No description
thomasgauvin
thomasgauvin4mo ago
It seems AlloyDB restricts the size of the network you can use to connect to it. From what I can tell from their docs https://cloud.google.com/alloydb/docs/connect-external, they recommend setting up an intermediary VM to proxy requests
$0
$0OP4mo ago
I will give up because the intermediate VM settings are complicated and the cost will be even more expensive. Thank you for your answer.
thomasgauvin
thomasgauvin4mo ago
Is this for a new project? Curious as to usage of AlloyDB instead of Cloud SQL https://cloud.google.com/sql/docs/postgres
Google Cloud
Cloud SQL for PostgreSQL documentation  |  Google Cloud
Using Cloud SQL for PostgreSQL
$0
$0OP4mo ago
Yes. It's for a new hobby project. https://subnect.com alloyDB seems to be fast, so I wanted to experience the speed. I'm currently using TiDB.
Subnect
Share Subjects, Connect Minds.
$0
$0OP4mo ago
I'm looking forward to hyperdrive mysql(TiDB) support.
Want results from more Discord servers?
Add your server