I have several applications that currently utilize more than one Google Sheet as their source data.
Recently, I have been considering transitioning away from Google Sheets and formatting this data into one Appsheet Database.
Is it better to have several databases (one per app) or one large database that all apps can be pointed to?
Thanks in advance for any input!
I would consider the limits imposed on Appsheet databases found here https://support.google.com/appsheet/answer/12653576?sjid=9576256980182984654-EU an pasted below:
Based on this I would evaluate if every single sheet within a Google Spreadsheets file totals to more than the outlined row limitations. So lets say you are transitioning a Sheets file to a Appsheet DB, you have 21 sheets, each with 10,000 rows of data (this might also exceed Sheets limitations, I did not check this). So in this instance you are exceeding both the 20 tables per database and 200,000 rows (Enterprise subscription) per database limitation. So then you would need to consider splitting your Sheets file into at least two databases, and furthermore you would also need to consider how much data is added in the future. Also, in this instance, now you are taking up two database slots out of the total databases allowed.
So, generally speaking, I would really evaluate scalability of your data. If the projected amount of rows added to a single database (not table within the database) is rather large, I would consider an alternative. I am currently running an experimental Appsheet DB that I will likely end up exporting to Cloud SQL that tracks various data for a period of 12 years currently with 1620 total rows. So in this case just by determining a basic average I should expect the entire database to grow by 135 rows per year, which is not necessarily significant enough under the Enterprise plan, however under the core or starter limits I may only be able to add another 6 years worth of data before I reach the row limitation. Just something to think about.
