Android app using Google cloud Endpoints: Datastore vs SQL

Question

I want to develop a new Android application and I was wondering about the architecture to use. My idea is to host my app on Google App Engine, using the Google Cloud Endpoints as backend. The only problem is that Google Cloud Endpoints use Google Datastore (that is a non-relational database, while I wanted to use a relational one).

So my questions are:

-Is there the possibility to change the logic of Google Cloud Endpoints using Google Cloud SQL ?

-If not, is there the possibility to use Google Datastore in a relational way (with references between tables) ?

Thanks.

Answer 1

Is there the possibility to change the logic of Google Cloud Endpoints using Google Cloud SQL ?

Google Cloud Endpoints's purpose is to allow you to develop REST apis for your application. What's inside the implementation of the REST methods is totally your choice. You can call Google Data Store, Google Cloud SQL, call MemCache, call other services, whatever you want. Cloud Endpoints does not force you to use anything. Its main purpose is to handle the communication RESTfully. That's all.

If not, is there the possibility to use Google Datastore in a relational way (with references between tables) ?

If that's all you want , entity references are managed using Keys in Google Data Store. But That does not make it relational. For example it will not complain if you delete an entity referenced by other entities like RDMSs normally do.