Monday, July 25, 2016

Re: [google-cloud-sql-discuss] Re: sql lite db and android

By the way, we don't recommend having connections from an app directly to Cloud SQL if you would have to embed the database credentials into the app. This is because is then possible for a hacker to extract the credentials and do more than they are authorized to your database. There are a few solutions for this:
  1. Make your app make HTTPS calls to a simple Google App Engine app, which does authorization checks before making requests to Cloud SQL. This also has the advantage that you can separate your database implementation from your app design.
  2. If you are only giving your app to users you completely trust, you might be OK with embedding credentials, although you should also use SSL.
  3. Use Firebase, which provides a database and secure remote API for apps with very little effort, along with many other convenient features.
David

On Mon, Jul 25, 2016 at 1:52 PM, 'Nicholas (Google Cloud Support)' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:
Thanks for sharing your questions here.

If you are indeed using SQL lite, the easiest solution may be Cloud SQL given its SQL compatibility.  This is essential a managed MySQL database service.  The costs would depend on the resources required for this Cloud SQL instance.  The pricing can be found here.

Depending on your read/write needs and the structure of your data, you may also want to consider Cloud Datastore.  The Datastore has Geographical point type that may be applicable to you.  The pricing page can be found here.

To provide more specific recommendations, we would need more information about the needs of your application.  For instance:
  • What are your data models like?
  • What kind of read/write volume do you expect?
  • What is your budget?
  • Do you intend to have a server-side application to handle these storage reads and writes or issue requests or REST calls directly to the storage medium (Cloud SQL, Cloud Datastore)?
Hope this helps.

On Monday, July 25, 2016 at 8:48:52 AM UTC-4, Khâlid ÊLMERRAH wrote:
hello, 
i wanna make an android app that stores locations, I've read that it's better to use a SQL lite db but i need a server where to store and sync data out of it.. could u please tell me a recommendation or an idea of what to do .. if google cloud can help.. how much will it coast ? thank you

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/78e65274-84e5-4750-b46d-1da700b32257%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAJZK_bZYzN_wMDrYEmYjfpT%3DP3HoH9R1gqSRsdHWoDJ%2BWGHAJg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment