Can appsheet use a Google cloud Datastore as ...

Can appsheet use a Google cloud Datastore as data source?

0 5 611
5 REPLIES 5

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

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

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

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.

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?

Top Labels in this Space