Page 1 of 1

Google Cloud SQL

PostPosted: Wed Jun 17, 2020 1:58 pm
by rafig
Hi all,
hope everyone is well...
I was wondering if anyone has used 'Google Cloud SQL' with Servoy to host their back-end SQL database (PostgreSQL or MySQL)?
I'm interested in looking at alternatives to AWS and this seemed like a good alternative, with a number of useful features.
However, it seems quite complex to configure access for a solution that isn't running on Google's Cloud services (whitelisting IP addresses / setting up special drivers...)
https://cloud.google.com/sql/docs/postgres/connect-external-app
If anyone here has, or if Servoy have looked in to it, can you let me know if it is easy and/or how best to do it??
Thanks
Rafi

Re: Google Cloud SQL

PostPosted: Fri Jun 26, 2020 10:25 am
by rgansevles
Rafi,

I do not have experience with google cloud or tried it myself, but from a glance of at these docs, I think the easiest way could be to set-up the cloud_sql_proxy and use localhost in the jdbc url for Servoy

Rob

Re: Google Cloud SQL

PostPosted: Fri Jun 26, 2020 10:36 am
by rafig
rgansevles wrote:Rafi,

I do not have experience with google cloud or tried it myself, but from a glance of at these docs, I think the easiest way could be to set-up the cloud_sql_proxy and use localhost in the jdbc url for Servoy

Rob

Thanks Rob, I might give that a try...
Rafi