Plan upgrade needed — click to fix it!

[Surdusvacca]

Wow, it is a nightmare for a stupid person as me to understand this.

I have an app that needs more than 2500 rows, so I connected the app to MySQL database.
Because of that, it throws this warning:

It is only possible to change plan between Appsheet Starter and Appsheet Core, which I already have.
Alright, I guess it actually wants me to purchase the EnterPrise Plan, so I tried to signup for that, but it wants me to verify domain name. I am not in a position in my company where I can do that. I am stuck here now.

Is this really how it works? Either I am stuck by using GoogleSheets for more than 2500 rows, Appsheet Database with max 2500 rows pr. database? 

I dont have any problems by paying for the Enterprise license, but this setup kind of limits my options now when I am not in a position where I can signup and verify with domain.

Am I missing something here?

[WillowMobileSys]

You want to check the app features from within the app itself.  You might have implemented a feature that requires a higher-level plan.

You can find the Deployment check feature as highlighted below:



I hope this helps!!

[Surdusvacca]

Hi @WillowMobileSys 

I do already know what the problem is. It is written almost at the beginning of the post 🙂

"I have an app that needs more than 2500 rows, so I connected the app to MySQL database.
Because of that, it throws this warning:"

[WillowMobileSys]

I see.  I thought it had been increased to 10k.  AppSheet Databases are very new and work for the most part.  There are some minor issues I see reported once in a while.  In my opinion, due to limitations, they are not yet ready for larger apps.  For those reasons, I do not use them.

Since you know the problem, you know you have basically only 2 choices:

1)  As @Steve suggested, Switch to Google Sheets - best option from a cost perspective. You can build very performant apps with hundreds of thousands of rows.

2)  If cost is not an issue AND you KNOW the app will be growing, then upgrading to an Enterprise plan to connect to SQL database is the best overall option.  You can use Security Filters in conjunction with the database to obtain the best performance metrics.

[Steve]

Why not just use Google Sheets?

[Surdusvacca]

@Steve 
Actually the main reason (maybe I am doing something wrong), is that syncing is not going very good when I do it with Google sheets. E.g. when someone deletes or edit data at PC1, it takes 1-2 minutes before the changes are visible at PC2. The little orange number is done in 1 sec, and even if I refresh the browser manually the changes are not there. This does not happend for some reason with sql database? And in general I just feel it is going faster with sql.

But anywho, I actually signed up for an Enterprise plus license today because I found this:
Specifically this line:

• If you have an Enterprise Plus subscription, you can build public apps; you don't need to purchase the Publisher Pro subscription.

This app contains no private data or anything, I want to make it a public app. 
When I am logged in to the new account that has the 'Enterprise' license, I dont understand how I prevent users from signing in? 

If I just go to the 'Security settings' and make it public, people are not forced to login, but I need to fully PREVENT them from logging as I dont want to end up with a hugh bill.

I am reading it wrong? I read it as I can do the same with the Enterpris Plus license as with the Publisher Pro?

[cikguhelmi]

my google sheet can handle my data more then 100k row.. still smooth

[Steve]

---

@Surdusvacca wrote:

E.g. when someone deletes or edit data at PC1, it takes 1-2 minutes before the changes are visible at PC2

---

You understand how AppSheet data syncs, yes? That a change by one user isn't seen by another until the other does something to pull the changes?