Can someone guide me what are pros and cons of using/not using both.
Is it true that airtable slows things down while firebase is fast.
Thanks in advance
Firebase is currently free but will not be so for a long time. Google already announced it. In the other hand, Airtable is free with a limit of 1,200 records.
Airtable takes the table structure of rows and columns but Firebase is an object oriented structure following JSON style so you access things like a files browser not like a spreadsheet.
I noticed, in Thunkable, the connection to Airtable is not very stable and the connection my reset with updates. In the other hand, Firebase is very stable and has more advantages such as storage to save files or authentication service.
The speed is a more complicated issue. I used both and can say that Firebase is faster and the speed is consistent apart from stored functions which are slower than Amazon. I noticed Airtable speed goes up and down like sea waves but I cannot say that this is due to Airtable as other factors effect the performance such as the speed of the internet connection.
3 Likes
Wow, thanks for detailed answer, I have many images that I need to store. So which one should I use?
1 Like
Both provides abilities to store images. Having said that, both recommend saving your images somewhere and store the URL in the DB
1 Like
So mediaDB - images to be stored and airtable - image URLs to be stored?
OK?
1 Like
In Airtable, you can set the field type as attachment which will allow any kind of files to be saved but from experience, I got problems trying to retrieve it in Thunkable. Of course this may change in the near future and the Thunkable team are working in updating the platform all the time.
As of know, the best is using MediaDB/cloudinary to store images and use the URL in Airtable.
2 Likes
OK thanks
@muneer I’m interested in hearing more about your experience with Airtable. Can you expand on what you mean by the connection to Airtable is not very stable and the connection my reset with updates? Obviously we want the experience to be smooth and easy for our users so if that isn’t the case please let us know. We’ll work on improving things as best we can.
1 Like
Yes @Steven, I noticed that a lot with Airtable and Google Sheets in November and December when the team are launching the enhanced Legacy UI (move invisible components to block screen) before the Drag & Drop UI. I stopped using it for that and also because Thunkable does not provide a way to use the filter function directly.
Now I am having the issues with another problem related to Airtable again. The Drag & Drop UI does not have the copy menu item to save a copy of the project in progress. So I share the project with my other account (free account @yahoo) but the real problem is the project is shared without the Airtable connections and instead all tables are replaced to local tables with the content of each cell as “Thunkable”. The real hassle is that once you try to restore the Airtable connectios you will have to visit each screen and rebind all components to AirTable tables and columns again which is time consuming and error prune.
This issue is not in Firebase RT DB.
airtable is better
but it can have 1500 cell
i think
1 Like
The free version is up to 1200 rows only in all tables. Which means if you have 3 tables each has 400 rows then you have to start paying to add more data.
@muneer, do you have a link for this? I couldn’t find that announcement.
1 Like
I was referring to the Flame plan which has been taken off and no loner offered
The current Spark plan ( the free plan) has a limit of 1GB of storage which will not be appropriate for base64/image type of data with reasonable user activity.
1 Like
Dear @Steven
Check this as a sample of the disconnection problem of Airtable
1 Like