Here is my view on it, we cannot say different DBs measure equally and fit same purposes. It all depends on your needs:
Lacks a lot on filter functionalities, all needs to be filtered from the frontend. It has basic API endpoints with no filter engine (Similar to Airtable and XANO, but these have backend filter).
Apps that rely a lot on images, you will consume DB fast, you should then use AMZ S3 that has a small cost on top but use Integromat or tools like Adalify for this (Another cost on top)
Possibility of creating relationships with other collections. but only simple relationships (Airtable and XANO you can do multiple and complex relationships)
Free up to some 1200 records.
10$ 5000 records
You can create more complex relationships than Adalo
only 2GB of attachments (Not good for media apps), (5GB for the 10$ plan) or use AMZ S3 as similar to Adalo (previous point)
More filtering on the server side (Airtable)
Also filtering from Adalo side
Free up to 10.000 records (No record limit but with a 3GB database storage in the 59$ plan, this is a lot just for records not counting media)
You can create more complex relationships than Adalo and Airtable
No disclosure of GB for media in the free plan (59$ plan you get 10GB) or use AMZ S3 as similar to Adalo (previous point)
Region selector (not possible in Airtable or Adalo) - Paid Plan only
No rate limit (Airtable and Adalo have a rate limit) - Paid Plan only, but free plan has generous rate limit better than Adalo and Airtable.
You can add much more complexity on the XANO side to transform data before getting it in Adalo
To sum it up
Good for apps that rely in Basic/Medium complexity
Good for apps that you don’t rely on massive amount of Media
Good for apps that don’t have complex relationships
Good for apps that rely in Basic/Medium complexity (But one level up than Adalo)
Good for apps that rely more in Media than using Adalo (Here you can always hack by using more Bases)
Good for apps that need more relationships or filters than Adalo
Paid plans also gives you some automations behind
Worse priced than Adalo but better priced than XANO
Good for apps that rely in high complexity
Good for apps that rely more in media than airtable and Adalo
Good for apps that need more relationships and filters than Adalo and Airtable
Has a higher price compared to the others (if you consider paid plans)
There are other ways to go also behind these 3, but requires more technical knowledge and time to setup as Adalo is not compatible out of the box.
I am biased as I prefer to use all with XANO (I am not affiliated at all, just my go to DB, Backendless and Supabase are also great), whether simple or heavy apps, but some customer ask for Airtable and Adalo, I then use it, it is all a matter of bugdet, complexity and data volume vs media volume.
Have fun Adaloing