How to connect a database mysql (local hosting)

[DaGi07]

Hello guys,

i would connect to appsheet mysql database hosted in my macbook in order to try to create an app based on a real database like SQL. 

How can i connect my local host?

TKS guys

[takuya_miyai]

Hi @DaGi07 

It may be possible to use Dreamfactory, but I have not checked if it supports Mac.

https://help.appsheet.com/en/articles/2213968-connecting-to-an-on-premises-database

If you simply need a MySQL verification environment, I recommend you prepare it with GCP Always free.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Install-MySQL-on-Always-Free-GCE-and-use-it-from...

[DaGi07]

@takuya_miyai tks for your answer.

I noticed in the first article that you linked me that on the top of the page there is this announcement: AVAILABILITY NOTICE: Use of DreamFactory to connect securely to an on-premises database is not available to new customer configurations. It will continue to work for existing customer configurations.

This does means that now the use of DreamFactory is no longer available if i try to register? 

tks 

[takuya_miyai]

@DaGi07 

Sorry, I don't know, I've never used Dreamfactory.
But if it's a DB on your Macpro, I think it's just test data and I think it's safe to publish it.

In any case, it is recommended to prepare the DB with Cloud DB or GCE.

[Ami]

Hi

Can you connect to a sql database with a simple core plan at all?

[takuya_miyai]

@Ami 

For prototypes, you can specify the SQL server as the data source.
If you want to deploy it, you will need AES (AppSheet Enterprise Standard) or higher.

[Luis_DfG]

@takuya_miyai thanks for your response.

Understood that an AES would be needed to deploy it, but it's a Core Plan enough to set the SQL database as a data source? or can one do it also with Free accounts?

Thanks

[takuya_miyai]

@Luis_DfG 

Any plan can connect to SQL Server as long as it is prototype.

However, if you want to Deploy, the plan must be AES or higher.