Yes, please Create a video on how to setup and add a Sequel Database!
@ncd94372 жыл бұрын
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)
@effsocialism25433 жыл бұрын
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.
@AppSheetTraining3 жыл бұрын
Thank you for the recommendation! We will add it to our list.
@valdilsonsilva41983 жыл бұрын
Top de mais caras, obrigado. Estou super empolgado com o appsheet.
@youngstasan40474 жыл бұрын
Thank You Very Much
@AppSheetTraining4 жыл бұрын
You're very welcome!
@paulleroy46063 жыл бұрын
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?
@AppSheetTraining3 жыл бұрын
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”
@isaquilloalaluf11865 ай бұрын
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?
@ostwolf4 жыл бұрын
Thank You!
@AppSheetTraining4 жыл бұрын
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?
@yuliap59793 жыл бұрын
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?
@AppSheetTraining3 жыл бұрын
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?
@vinothkumars74217 ай бұрын
Does it work Azure sql db
@zoomcam77064 жыл бұрын
Thank you sir
@AppSheetTraining4 жыл бұрын
For sure, glad you found it helpful!
@emmanuelg.adzaworlu6295Ай бұрын
Help me set-up a SQL database
@TrisnaWijaya4 жыл бұрын
thank you, how i can show image to app sheet from link in mysql?
@AppSheetTraining4 жыл бұрын
Is the image a public URL or is it a binary blob?
@TrisnaWijaya4 жыл бұрын
@@AppSheetTraining public URL, the image saved in my web hosting.
@AppSheetTraining4 жыл бұрын
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
@gilbertgatito66662 жыл бұрын
porque no lo hacen mejor en Mongo DB o fire base
@johnkarns89263 жыл бұрын
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.
@AppSheetTraining3 жыл бұрын
Most of AppSheets features are free to test with. You typically don’t buy licenses until you’re ready to deploy to live users.
@johnkarns89263 жыл бұрын
@@AppSheetTraining Yes but how can I test with SQL if I don't have a paid business account. Thanks for your answer.
@AppSheetTraining3 жыл бұрын
I believe you can. If you have trouble, please email us at info@appsheettraining.com
@claudinecustodio12324 жыл бұрын
Hi, can I connect aws aurora dB to appsheet?
@AppSheetTraining4 жыл бұрын
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
@claudinecustodio12324 жыл бұрын
@@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.
@AppSheetTraining4 жыл бұрын
@@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.