What are the advantages of using an SQL database?

[Emilian_Bem]

As in the topic, what are the advantages of using a SQL database?

[Marc_Dillon]

1. Faster sync speeds
2. Security Filters are more effective at improving performance
   …

[Rafael_ANEIC-PY]

3- Sustaining an ungodly amount of rows.
4- Filter rows before sending them to your app by using sql views (or so i have read, never used sql)

[Koichi_Tsuji]

Rafael_ANEIC-PY:

4- Filter rows before sending them to your app by using sql views (or so i have read, never used sql)

Based on my past experiences with SQL, SQL view is not really improving performance, as it could be equivalent with AppSheet security filter, for your guidance.

[aeastham]

We had an app with Smartsheet data at the backend. We were hitting limits on cross sheet links and also performance. Converting it to SQL (Azure SQL database STD tier - approx $20 per month), gave a sevenfold increase in sync and update performance

[aeastham]

SQL is massively faster at this if your data is properly indexed, especially if your app is concurrent and you can’t use appsheet caching features

[SkrOYC]

5. You can burn money faster using AppSheet.
   Nah, just kidding. But I’ld love to have SQL support under Core subscription!

solutions.appsheet.com

AppSheet Pricing

Get information on AppSheet pricing for our Pro, Business, and Enterprise plans. Find the right fit for your small team, large team, or enterprise organization.

SQL is available just for Enterprise accounts

[Marc_Dillon]

6. Ability to add columns to the backend, at any time, without causing all of your users’ apps to completely error-out.