Hello guys. I have built a chat app on Supabase but I'm not sure if postgres is good for a realtime chat. My main concerns are about multiple concurrent writing operations in db. For example, if we have 1000 connected users each user has to send last_time active for presence every x seconds. If 1000 users use chat at the same time, the typing function could send 1000 concurrent reqs to db. Aren't these too many requests? Please correct me if I'm wrong.

Hello @theuknowner! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

You should probably ask this as a GitHub discussion here: https://github.com/supabase/supabase/discussions so our Realtime Team can see your use case and weigh in on the discussion.

theuknowner (2022-05-12)

There are some new features coming to our realtime product that would be perfect for what you're doing.