Supabase + Google Cloud SQL foreign data wrapper
Hey guys! I am a lead engineer at a startup, currently looking in new technologies to build the new version of our app.
- The question: Has anyone ever used a foreign data table between Supabase and Google Cloud SQL?
- The need: Our current infra runs on GCP SQL using postgres. We want to maybe move to supabase for our new app, but we need to read some data from our old infra that has to be maintained for at least a while.
- The "bug": I've seen on google's documentation that: " This extension works for two Cloud SQL private IP instances within the same VPC network, or for cross databases within the same instance.
To connect to databases within the same instance, you cannot set host to localhost or to 127.0.0.1. Instead, you must use the IP address shown for your instance in the Google Cloud console. "
So am I being misled by google's doc?
- The question: Has anyone ever used a foreign data table between Supabase and Google Cloud SQL?
- The need: Our current infra runs on GCP SQL using postgres. We want to maybe move to supabase for our new app, but we need to read some data from our old infra that has to be maintained for at least a while.
- The "bug": I've seen on google's documentation that: " This extension works for two Cloud SQL private IP instances within the same VPC network, or for cross databases within the same instance.
To connect to databases within the same instance, you cannot set host to localhost or to 127.0.0.1. Instead, you must use the IP address shown for your instance in the Google Cloud console. "
So am I being misled by google's doc?
