How to Make an App Using Your SQL Data

[@johnmtaylor8841]

Yes, please Create a video on how to setup and add a Sequel Database!

[@ncd9437]

Love your videos, thank you very much for your hard work! I would love a video on how to set up a SQL database! (MySQL)

[@effsocialism2543]

I'd like a video on setting up a database. That's actually what I was searching for written I found your video... Well, understanding databases.

[@AppSheetTraining]

Thank you for the recommendation! We will add it to our list.

[@valdilsonsilva4198]

Top de mais caras, obrigado. Estou super empolgado com o appsheet.

[@youngstasan4047]

Thank You Very Much

[@AppSheetTraining]

You're very welcome!

[@paulleroy4606]

Nice job, thank you. Also... would be nice if you'd have a video on accessing a database in Google Cloud. Amy Idea how Appsheeets behaves with a NoSQL DB such as Google Firestore?

[@AppSheetTraining]

Hi Paul, the best database for AppSheet is a SQL database. AppSheet requires tabular structured data. Firestone can be treated as a tabular structured dataset, but does not offer performance benefits over SQL. Any NoSQL db has to be connected through a specially formatted API interface. You can read about the specs through AppSheet’s help articles on the “Apigee connector”

[@isaquilloalaluf1186]

Thanks for sharing the video, very good. I only doubt remains. According to my understanding, if I want to connect AppSheet to an on-premise database, I would only need to add that list of IPs that you showed to my database? Or… Should I need to configure a VPN on the server where the local database is so that AppSheet can connect?

[@ostwolf]

Thank You!

[@AppSheetTraining]

You're welcome!

[@user-ji5pr6fn4p]

Will AppSheet just load the contents of the SQL database ONCE or will it also sync the changes to it?

[@yuliap5979]

Thank you for a helpful video. I'd like to ask whether it's possible to retrieve data using SELECT in this case? Are there primary keys and foreign keys?

[@AppSheetTraining]

Yes the select function returns a list of column values from the rows that pass the filter condition you set.

[@user-ji5pr6fn4p]

If I host a SQL database with GCP and access it for many different applications. Will AppSheet sync with these changes? How often does it update?

[@vinothkumars7421]

Does it work Azure sql db

[@zoomcam7706]

Thank you sir

[@AppSheetTraining]

For sure, glad you found it helpful!

[@emmanuelg.adzaworlu6295]

Help me set-up a SQL database

[@TrisnaWijaya]

thank you, how i can show image to app sheet from link in mysql?

[@AppSheetTraining]

Is the image a public URL or is it a binary blob?

[@TrisnaWijaya]

@@AppSheetTraining public URL, the image saved in my web hosting.

[@AppSheetTraining]

Attaching your MySQL table to appsheet and setting the Column containing the URL to the “Image” type should cause that image to appear in your app

[@gilbertgatito6666]

porque no lo hacen mejor en Mongo DB o fire base

[@johnkarns8926]

Is the business option super pricey? I don't want to start paying for something I don't even know if I will use just to learn it and then waste my time and money both.

[@AppSheetTraining]

Most of AppSheets features are free to test with. You typically don’t buy licenses until you’re ready to deploy to live users.

[@johnkarns8926]

@@AppSheetTraining Yes but how can I test with SQL if I don't have a paid business account. Thanks for your answer.

[@AppSheetTraining]

I believe you can. If you have trouble, please email us at [e-mail]

[@claudinecustodio1232]

Hi, can I connect aws aurora dB to appsheet?

[@AppSheetTraining]

Aurora is SQL-like ,which means in theory it should be compatible, but AppSheet does not have an explicit connector for it. That means you need to try to use the standard Cloud Database connector and connect via IP address of the database or server connection endpoint

[@claudinecustodio1232]

@@AppSheetTraining Thank you, can you cite some Cloud Database connectors, are they similar to Dreamfactory? Sorry I have very limited knowledge in databases. My boss wants me to explore appsheet and figure out if it's possible to use aurora as datasource. Aurora is our IBM Maximo's database, he's considering using appsheet as the user interface.

[@AppSheetTraining]

@@claudinecustodio1232 According to this ( docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Connecting.html ) documentation: "You can connect to an Aurora DB cluster using the same tools that you use to connect to a MySQL or PostgreSQL database. You specify a connection string with any script, utility, or application that connects to a MySQL or PostgreSQL DB instance. You use the same public key for Secure Sockets Layer (SSL) connections. In the connection string, you typically use the host and port information from special endpoints associated with the DB cluster. With these endpoints, you can use the same connection parameters regardless of how many DB instances are in the cluster." If you can get the connection string you should be able to get connected like you would other types MySQL. Once you have that set up you can run some basic tests to see if it works as you expect. If you would like to buy some consulting hours we would be more than willing to try and help you figure out more of the specifics.

[@claudinecustodio1232]

@@AppSheetTraining Thank you, really appreciate it!

[@AppSheetTraining]

@@claudinecustodio1232 Any time!

[@nympho25]

title says how to make an app....u just showed us an app u have that uses sql data bases...this vid is 3yrs old tho....still will look into it