Love it! Great article! I also did this in late 2018 with PubNub and the transit system I did it for is still using it. I like the Ably choice as well.
I think there’s a vast opportunity for business processes that require real-time analytics and data, but my sense is that few companies lean on Airtable as the data store. The API is woefully underpowered to allow any granularity of real-time events and the low ceiling of approximately 50,000 rows makes Airtable a weak endpoint for data.
While we use it for certain alerting and collaborative events that require instant awareness, most of our real-time data move into ElasticSearch at the rate of ~28 million events per day.
