Actually First I was also using Firebase but some times when my project have many tags and bucket then I got messed with them then I tried Airtable and I loved It.
Just some rows and columns and thatās it.
I use it in Spanish and it goes perfectly. What you have to do is to use the web component and use the Uri_Encode_Text block and when you get the data you have to use the Uri_Decode_Text block, and with this you donāt have problems with special characters.
Each of the databases has its advantages. For example Airtable is better for sorting and filtering the data (try sorting the firebase data by date and name for example and you will see that you canāt). In Airtable you can use the views, to show only the data you are interested in (there are many people who donāt know how to use the views). You can create calculated fields. When you put a data, another column will be filled with a calculated data based on another one you put.
Obtaining data in Airtable is easier. In Firebase if you donāt know how to use the project bucket well you get nothing.
The problem with firebase is that if you make many requests, the free plan becomes small and you have to payā¦ I had an app with 100 users and firebase stopped working because I had the free planā¦
I prefer Airtable, but for projects that require a real-time response, firebase is the best.
Both of these have limitations if you have a larage usage and large data to store
So the best alternative is to use
my sql
And i request @Kodular to add firebase firestore which can also be used instead of mysql
So at this time we have mysql and not have firestore
So try my sql incase u have a large data
But if u have small database then
air table is for u
And if u r working to show data in realtimes then firbase is best
Conclusion
The choice of your database depends on your data and its usage
And type of your audience
So instead of believing what others are saying is not enough everyone is giving their best according to their own experience but you have to choose only what you need and whats your need
How much data can be stored in Google spreadsheet ??
I used airtable before, but it have some limitation. Firebase is more professional but harder. If your project is not too big, you may use airtable instead.
use firebase
because firebase is firebase there is no comparison between airtable and firebase
I would say airtable < firebase. However the connection limit in free plan is quite high
For me both are bad but I vouch for firebase , airtable is super bad
MYSQL or MongoDB are way better.
Lets do a final poll
Which database do you prefer ??
- Firebase
- Airtable
- MySQL
- Other
0 voters
Because I donāt know how to use MySQL, so I prefer firebase
- MySQL / SQLite good as general purpose database
- Airtable is great for Media-focused database
- Firebase great for real-time DB needs and it is key value database which you can easily use to store JSON data.
- Redis is another good real-time database.
So,
Letās do all the goods and bads or Airtable and Firebase in a single post.
Mostly use Airtable Spreadsheet, It Works Fine With Large Data Too (Load Small Numbers of Row And after it loads, Get Another Rowsā¦) (Thanks to @The_K_Studio for this method) and now I wanna try to use MySQL Database (Currently I Havenāt Any idea about its performanceā¦ Update u soon
For most of the apps, which have some data stored on the internet, airtable is the easiest and the best
For other apps, like chat app, firebase or MySQL is the only way.
So, it is hard to say I use what? Answer would be I use firebase and airtable
Therefore, which one do you think works best with all kind of apps, small and big?
- Firebase
- Airtable
- Both are Equal =
0 voters
NB- Do not vote because only other are voting that choice, vote on that you think is best
Airtable is good but slower than firebase
you can use json
Airtable is much better than firebase because you do not need to pay more to airtable if in future your app gains users but is firebase is very expensive
Hey i see many people are using airtable for user database . but when i used in past its not working for me i faced some issue like . when a user update their data the index no is gone difference .like 3 colum name mobileno and email , first time i get the data in right index .but when a user make update request and a new user submit data the index no go mismatch like mobile no store in email or email store in mobile noā¦ so i have post on kodular but not get the issue solved thatās why i move in MySQL its little slow but you can get any data according to your need .
I have a simple question.
If airtable Crossed 5 connection per second then I get which error.
Not 5 connections maybe.
5 API requests.
I donāt know the error.
Just donāt use Airtable.
Airtable provides api for office works, not for app backend.