Can appsheet use a Google cloud Datastore as ...

(Christian Farley) #1

Can appsheet use a Google cloud Datastore as data source?

(Praveen Seshadri (AppSheet)) #2

Do you mean specifically something like mySQL hosted in Google cloud? Yes.

(Christian Farley) #3

I mean the specific Google Cloud product called “Datastore” which supposedly has a “No SQL” feature, while also offering an “SQL Like” interface.

(Christian Farley) #4

See the 3rd, 4th, 5th, lines in this table: cloud.google.com - Choosing a Storage Option | Google Cloud Choosing a Storage Option | Google Cloud cloud.google.com

(Praveen Seshadri (AppSheet)) #5

Christian, it isn’t the best choice for an appsheet app. You should use DataStore for hierarchical and semi-structured data.

We do support AWS DynamoDB which is similar. But a structured SQL store is a much better fit in general.

(Christian Farley) #6

Thanks @praveen Makes sense. I have already migrated my data source to a MySQL server on Google Cloud, and getting blazing perf increases.

But my next problem is that while I was using Google sheets as data source, I had developed several back end scripts. And I have not found a way to port these scripts to interact with the MySQL tables. So I am blocked.

Any advice?