I gave a talk about Glide to the Lexington (MA) Computers & Technology Group. You can see this talk at:
One of my good friends sent me a set of questions based on what I talked about as well as what I showed in the demo of using Glide to create an app for our group. I don’t feel qualified to answer these questions, so I submit them to the community at large. I appreciate anything you can contribute to answering these questions. You don’t. have to answer them all – feel free to pick off one of the four questions and answer it.
A couple of “privacy and security” questions.
Question 1: First, authentication. Suppose I have an app that’s only intended for “authorized users.” How does someone who starts up the app on their phone authenticate themselves? Does Glide provide an authentication service? Is it username/password? Do they use 2FA? Of course, there’s not only the binary question of whether or not a given user can access the app’s data but also what the particular user’s rights are—to read, to modify, …
Hopefully, one authenticates to a specific app, and not just to an overall Glide account.
Question 2: Second, the privacy of the app’s data. It’s all in spreadsheets, stored either as Google docs in the Google cloud or in Glide’s own cloud storage (I think you said that was a feature in the newest version). What keeps an app’s data private to the users of that specific app, and prevents it from being spied on or, worse, modified by, others—either other Glide users or outside hackers? I.e., how tight is Glide’s security, and do they assume any liability for keeping your data private? Or should one use Glide only for apps that don’t have any privacy concerns re their data?
Question 3: Third, security. How is data “in-flight” between the app and Glide’s server protected (or is it?)?
And a few more questions on other topics:
Question 4: Is there a way for a Glide app to access data contained in a database that is not a Glide spreadsheet or table; i.e., a 3rd party database, perhaps containing real-time data. For example, suppose my company had a trouble ticket system that kept its database on my company’s own server. I want to make it easy for my field service team to access the trouble ticket system while they’re out and about, so I want to create an app for them to do that. But, the app needs to access the actual trouble ticket database on my server; the trouble ticket database is not going to be uploaded to a Glide table/spreadsheet. And of course, such access to a third-party database needs to be in real-time, because the data can change.
Thanks: I will appreciate answers to any of these questions.