we are considering using Airtable for a DB. We would need users who can access through UI (read only access) and also programmatic access and because Airtable is so user-friendly it is on our list to be considered.
Has anyone experience accessing programmatically Airtable via API? I heard the API is not very good and only supports HTTP.
Have you worked with any other DB that would fulfil these requirements? user-friendly UI for read-only-user and accessible securely via API
Also any suggested link about how to orchestrate the input/output from Airtable with Prefect?
Thanks in advance!