Which database use

[pagueservicios]

Hi, I am making  a appsheet app which needs to validate the name, last name, and user ID of 4 million people. Excel or google sheets dont support that mucho data. Do you think SQL would work?

The app im making it in google sheets and its pretty simple it only looks for the ID i put in the ID text box and brings back the complete name. After that It looks for 2 more data in the goolgle sheet table and thats it. 

Thanks for your help

[JPAlpano · Accepted solution]

SQL or BigQuery.

AppSheet is cooking something to offer it's own database, but no clues yet as to the timelines.

There are some rumors that it will be based on the new Google Tables which is currently in beta.

[SkrOYC · Accepted solution]

It's basically an AirTable clone that's meant for AppSheet, so no real database IMHO

[JPAlpano · Accepted solution]

SQL or BigQuery.

AppSheet is cooking something to offer it's own database, but no clues yet as to the timelines.

There are some rumors that it will be based on the new Google Tables which is currently in beta.

[SkrOYC · Accepted solution]

It's basically an AirTable clone that's meant for AppSheet, so no real database IMHO

[pagueservicios]

I have never used SQL and linked it to appsheets. Its it easy. I have a hosting which is site5.com and i can make a mysql database but dont now how to put the info in the database. If you have any docs or videos I will thank you! Thanks for your help!!

Regards

[pagueservicios]

Hi JPAlpano thanks for your help. I havent used SQL but have a hosting which I already made the mysql DB. Im trying to upload the txt with the client DB but its 420mb and it doesnt let me import. Any help?

Regards

[SkrOYC · Accepted solution]

Supabase mets AppSheet - Google Cloud Community