# API and SQL database to store data
**URL:** https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060
**Category:** Questions about Thunkable X
**Created:** [May 7, 2020, 5:48pm UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060 "2020-05-07T17:48:14Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Andrea\_Marchisio](https://community.thunkable.com/u/Andrea_Marchisio)
#### Post date: [May 7, 2020, 5:48pm UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/1 "2020-05-07T17:48:15Z")
Hello,
I need to store thousand of rows generated by my app and I do not want to use Firebase because is json DB and Airtable because with free account give us just 1200 rows per DB. I’d like to use a SQL database.
Which DB do you recommend, which can be managed via API? (insert, select, update e delete)
Thanks
Andrea
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [May 7, 2020, 5:53pm UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/2 "2020-05-07T17:53:34Z")
If you dont want to use either of those, google sheets works with the new data components you are just storing info. There is no row limit but each sheet is limited to 5,000,000 cells. So take the number of colums you would use. divide 5 million by that. that’s how many rows you can use on one sheet.
I would also be willing to rent you space on my Airtable Pro 😉
Each table has up to50,000 rows
---
### Author:  [@Andrea\_Marchisio](https://community.thunkable.com/u/Andrea_Marchisio)
#### Post date: [May 7, 2020, 6:37pm UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/3 "2020-05-07T18:37:30Z")
yes spreadsheet is a good idea but you can’t do SQL; i like airtable very much but to have 50K rows it costs $ 20 / month. for example I already tried Snowflake DB managed with Integromat API. I prefer to use a DB …
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [April 2, 2021, 9:07pm UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/4 "2021-04-02T21:07:58Z")
> [@Andrea\_Marchisio](#):
>
> yes spreadsheet is a good idea but you can’t do SQL
Sorry to bump an old thread, but could you use something like this to link your DB with your Thunkable please @Andrea_Marchisio?
[https://www.sqltoapi.com/](https://www.sqltoapi.com/)
---
### Author:  [@traceykingmirzt](https://community.thunkable.com/u/traceykingmirzt)
#### Post date: [November 24, 2021, 11:43am UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/5 "2021-11-24T11:43:57Z")
Do you happen to know where you can store data and files in large quantities, but for free or very cheap? Now it’s quite problematic to find a job, so I’m trying to find a cheap way out of my situation.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [November 24, 2021, 11:46am UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/6 "2021-11-24T11:46:35Z")
Firebase and aws both have free or very lost cost options
Cloudinary has a nice free plan too
But it usually costs money to store larger files. How much data are you talking about here? What kind of files?
---
### Author:  [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)
#### Post date: [November 24, 2021, 12:40pm UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/7 "2021-11-24T12:40:45Z")
Amaon Web Services SQL is not but looks like a good option.
better you settle with Google Clould BigQuery So it has the docs ready.
> **[APIs and reference | BigQuery | Google Cloud](https://cloud.google.com/bigquery/docs/reference)**
Make you app.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:29am UTC](https://community.thunkable.com/t/api-and-sql-database-to-store-data/565060/8 "2024-11-08T11:29:23Z")