Hi @anas, in my experience Airtable is relatively slow, both for search and write operations. I compared Baserow and Airtable performance recently by inserting 1,000 random records (with one text and one boolean field).
This operation took almost thrice as long on Airtable:
This was on a free plan, I don’t know if Airtable offers better performance on their paid plans (in which case the results could of course look different).
In addition, Baserow is powered by a regular PostgreSQL instance under the hood, so if you are self-hosting you’re not just limited to the n8n Baserow node (and the Baserow REST APIs), but could also connect to the PostgreSQL database directly for the best possible performance and flexibility through regular SQL queries.
For the best possible performance (while still having a UI letting you view and edit the database directly), Supabase would be king though. The above test (creating 1,000 records) takes less than a second using n8n:
So tl;dr Supabase is probably your best bet here, but Baserow is a little easier and will still be considerably better than Airtable.