Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 29, 2021 11:23 AM
If many devices , like in hundreds fetch Airtable sheet data simultaneously, will there be an error, Or can Airtable handle this.?
Aug 29, 2021 11:47 AM
Welcome to the Airtable community!
What type of users are you thinking of having? If you will building your own portal with the REST API, it will not work.
The API is limited to 5 requests per second per base. If you exceed this rate, you will receive a 429 status code and will need to wait 30 seconds before subsequent requests will succeed.
Other methods of accessing Airtable data do not have such strict limits (e.g. base collaborators using the actual user interface, or publicly shared views published on the internet). However, in general Airtable is not designed to scale up to hundreds of simultaneous users. People who use Airtable as a backend for a website usually need to introduce a caching layer.
Aug 29, 2021 10:56 PM
Hello, I will be integrating Airtable with the Thunkable App building platform. It is an Information app that at first bootup fetches data from Airtable sheets and stores it on the phone.
Aug 30, 2021 09:30 AM
If you anticipate the users may “boot up” or open the app at similar times, the answer is still no. You need to forward-cache the data to support heavy access hits to your Airtable service.
One approach is to sync your Airtable data to a SQL database (using this service) and build your app to pull from the SQL data instead of the Airtable service.