C# best connection method?

[Ryan Johnson]

Hey guys,

Pretty new to MySQL and google cloud as well.

I have a c# WPF & Xamarin Android application that uses a SQlite Database to input some data and read it for my small business.

Now I want to expand it to the cloud so that multiple people can read/write information and share the same database.

I understand about RESTful web api and found some example code for PHP that i deployed to the app engine and it works without issue.

Problem is i dont think its as secure as it should be? anyone can visit my app engine URL which costs money each time they do and might open the app for them to figure out how to POST,GET information.

So the access options were to assign whitelisted IP's which is near impossible as mobile devices and broadband IP's change on a daily or weekly basis.
Second option was to whitelist gmail accounts, which i really dont want to force users to sign up for gmail if they dont have it.

So can someone please explain what is the best method to connect to a Cloud SQL Database, i think i am half way there with the the app engine REST php script.

Thanks

[Ryan (Cloud Platform Support)]

Salutations Ryan,

RESTful API is one option.  If you are ok with using Java or Python you can also use endpoints which gives you more control over the data passed back and forth. You can then use any email address (simply include it in the call and check Datastore if they are allowed access).