Geek asks and answers

Does anyone have a short example of Android and Cloud SQL

I understand that the Google App Engine (GAE) is very efficient, and I would like to determine the correct way to create a database schema (outside of Android) and start filling the database (after deploying my Android application). Then I would like to query the database (outside of Android). I was hoping this would be exercise 10-20, but it is turning into the much more complex task that I expected.

Out-of-band steps

  • Create the database through the command line using the correct GAE authorization.
  • Query database through the command line using the correct GAE authorization.

I want to repeat that I do not want to write Java code to create or query a database. I'm more interested in using SQL or an SQL-like language directly against using Java.

Android steps

  • Insert rows into the database using the correct GAE authorization, encryption, etc.
+3
source share
2 answers

Here are two ways to issue SQL statements to your Cloud SQL instance:

https://developers.google.com/cloud-sql/docs/commandline

https://developers.google.com/cloud-sql/docs/sql_prompt

As for inserting rows into a database with Android, you need to write a GAE application to act like a proxy. An application can then open the REST API or any other API you want.

+1
source

More articles:


All Articles