Hi 
,
To be honest, when it comes more than a few tables I would intuitively turn to SQL databases even when we are not talking about ten-, hundred-thousands or millions of records.
But as soon as an SQL DB is used, the license of the app jumps to the enterprise category.
I thought it would be interesting to “interview” the community about the suggestions when it comes to choosing the ideal data source to achieve idela price/value ratio.
(Sorry if a similar discussion is already existing. I didn’t find it)
Based on your experiences what are the
- use cases where you keep Google Sheets as the data source?
- what are the limits when you would switch to an SQL DB instead of going with Sheets?
(I know the hard limitations of Sheets but I guess the UX of the App can be bad way before any hard limitation is reached)
What are the basic trade-offs that we have to consider when choosing between the usage of Sheets and an SQL DB?
(For example, during the Developer course in one of the labs I noticed that the sync is slower when Sheet is used with custom cell formula compared to my experience with SQL datasource)
And of course any other aspect is welcomed that I forgot to ask 
Ps.: I didn’t mentioned the AppSheet DB because I haven’t read any good about it, so I just left it out of the options. Feel free to challenge it 