Clients connected in real time

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?

Use Quick sync to instantly see other users’ changes

Thanks, Steve. I had seen that but it always seemed to me to be at odds with earlier support posts that warned folks away from such things, especially when people were trying to do inventory-type apps. This is great that it’s working so well. I wonder what scale people have tried (I’m thinking of dozens of groups of students all playing my game with dozens of friends, for example).

2 Likes