Google Cloud SQL

Questions and answers regarding general SQL and backend databases

Google Cloud SQL

Postby rafig » Wed Jun 17, 2020 1:58 pm

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
Servoy Certified Developer
Image
rafig
 
Posts: 562
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK

Re: Google Cloud SQL

Postby rgansevles » Fri Jun 26, 2020 10:25 am

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
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1901
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Google Cloud SQL

Postby rafig » Fri Jun 26, 2020 10:36 am

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
Servoy Certified Developer
Image
rafig
 
Posts: 562
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 2 guests

cron