I made an app to test some functionality. It’s a game where users hit an action button and that drives a data change that I wanted to push to all users in real time. I didn’t actually expect it to work. I presumed I’d have to get the users to hit the refresh button. But on a lark I set the data up in an appsheet database instead of a google sheet and it sure seems like it’s keeping all the connected users updated without them having to refresh. Below is link to a vid where I just used 6 different “full screen” windows set up to impersonate 6 different users. You’ll see that the near-real-time connections work pretty well. I’ve also done this with two phones and a computer (no impersonation) with one of the phones being on cellular data and the other phone on the same wifi as the computer. Not really a real world test yet, I get it, but it’s still potentially exciting. Does this scale? I used to use Pusher to do this sort of websocket work and if appsheet just does it for me naturally I’d love it.
Here’s the youtube vid: https://www.youtube.com/watch?v=NC-k44nW6fc
Thoughts on scalability?