I’m looking to leverage either a MySQL or SQL Server database for the backend of my app (on Google Cloud)
I will be white labelling the app to publish on Google and Apple app stores.
I have two questions:
How does AppSheet handle connections to backend database? For example, is every user considered a “database connection” or does AppSheet use a separate mechanism to handle the communications back and forth between the Appsheet and database? As I look at the MySQL licensing, it looks like it the database connections max out at 4000 connections. So if Appsheet just does a pass through of users and our app has more than 4000 connections just wanting to address this item of scale now before I deploy.
Just looking to understand if Appsheet leverages some sort aggregated communication channel to backend database
Any feedback the user community has on either MySQL or SQL Server re: usage, performance, pricing etc. I’ve worked with SQL a lot but new to MySQL. However I know MySQL is heavily deployed and is generally considered a good reasonable database from a price perspective while performing equally as well as SQL Server.
Any feedback would be most appreciated.