Please provide me with updated information about AppSheet Database.

AppSheet AppSheet Q&A
1

Hello everyone. The truth is, I believe in AppSheet and its potential. I’d like to test AppSheet’s database right now. I’d appreciate any updated insights on its pros and cons. I hope AppSheet is working on this project.

Would you use AppSheet’s database, or are you using other databases?

2

Hi @Gustavo_Eduardo

AppSheet database is not ready for production app, from my point of view:

  • too few rows/tables available with core plan (2500 rows per AppSheet database, 10 AppSheet databases)

  • not manageable through any script

  • interesting with Enterprise Plan when strictly speaking of data storage, but again: as far as I know, we can’t run any script against it. Should you need to run a batch of update, you are stuck.

Here are the limits, for information: Restrictions, limits, and known issues - AppSheet Help

However, I agree there is a huge potential here. Direct integration with the app editor and automations is a major benefit.

I would be interested in knowing if Apps Script services will provide a service such as DriveApp, DocumentApp…for AppSheet, like AppSheetApp maybe? @zito , would you have any information about this ?

Using MySQL with CloudSQL is perfect when you need higher data storage, specific data strategy, or better responsiveness.

Using BigQuery is perfect for read-only data (you can write too, but not recommended). However, key-rotation is not ensured at this time: it will probably be adressed with the upcoming integration connectors announced here (GA in the 1H of 2025): Re: AppSheet Roadmap Sneak Peek - Q1 - Google Cloud Community

3

Hi @Gustavo_Eduardo

For large datasets (250K+ rows), I’d still recommend Cloud SQL/BigQuery over AppSheet DB. Here’s why:

  1. No SQL Joins: Limits data combination.
  2. No Bulk Append: Data import is clunky.
  3. Performance: Slows down with large tables.
  4. Limited data transformation and no stored procedures or triggers.

Might be more limitations known but that’s all for now.

Thanks,

Ken

4

Dear @Aurelien ,

First of all, thank you for your detailed response, and sorry for the delay in replying. I saw it earlier, but I was busy and wanted to take my time to respond properly.

In short, AppSheet Database is still in its infancy. It’s a shame that it remains within AppSheet and doesn’t allow connections to other resources.

I’m going to look into MySQL. For now, I’m kind of a caveman with a computer—I still use Google Sheets, and I’m an architect turned app developer (a complete outsider). But I try to learn, so I think this will be my next goal.

Do you know if there’s a place where MySQL is free for prototype apps? I’d like to start testing without having the “trial period noose around my neck.”

5

@kennyboy

Thank you very much for your detailed response. It is very useful for anyone who has the same question today.

Both your answer and Aurelien’s will be marked as the solution; however, I will wait a little longer before marking the post as solved so that more people can share their opinions.

Just in case anyone has any additional questions throughout the day.

6

I don’t

I get your point :slightly_smiling_face: I don’t have it, but you may want to have a look to Google Skill Boost programme: https://www.cloudskillsboost.google/catalog?keywords=sql

7

Thank you very much @Aurelien , I’ll take a look at it.