Is glide more of a solution for an MVP or can it scale with a company as the data size grows? Really trying to understand if there are performance issues with scale or not
Big Rows, which is current in Beta will allow up to 10M rows for your project, on Business and Enterprise Plans. In addition, you can scale Updates at a rate of $10 per 1,000. If you plan on having over 25k updates per month, you might as well get the Business Plan that already comes with 25k Updates and Big Table access in the future
Worth mentioning it currently has a lot of limitations. I don’t know if they can be removed at some point, but it’s much different compared to your current Glide Tables now.
Regarding the scalability of Glide I’m not 100% sure, but my sense is that you’d want a properly engineered product and backend for large scale applications. But the scalability of the underlying data sources (e.g. Airtable, Google Sheets, etc.) is definitely limited (likely more so than Glide itself).
Related records inherently happens and is a necessity as your data grows. Needing a database like Postgres, MongoDB, or Snowflake can handle these.
If Airtable or Google Sheets is what’s limiting you then here’s what you could do (based on other forum questions and some practices in the company I’m at). I’d recommend using an ETL service like Airbyte (https://airbyte.com) to get your data into a true database. If you want to keep using Airtable or Google Sheets but have that data in a more scalable system, you could use Bracket (https://usebracket.com) to send the data to a database but keep using Airtable / Google Sheets as a UI for your database.
You could also try using Zapier, Integromat, or Make as well but it may also run into scalability issues for this kind of use case.