Building a Real-time Chat Application Using Strapi, Next, Socket.io, and PostgreSQL

commentsBot · June 28, 2022, 8:26am

Sending and receiving text messages in recent times are frequently done online and in real-time. Text messages in real-time chat applications are sent and received immediately, depending on the speed of the router. Realtime messaging is very essential in chat applications, and Socket.io grants us this privilege.

This is a companion discussion topic for the original entry at https://strapi.io/blog/real-time-chat-application-using-strapi-next-socket-io-and-postgre-sql

hemant · December 25, 2022, 1:37pm

Refer the below mentioned link to setup postgres through command for Macbook M1.

gist.github.com

https://gist.github.com/phortuin/2fe698b6c741fd84357cec84219c6667

postgres.md

Based on [this blogpost](https://www.codementor.io/@engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb).

Install with Homebrew:

```bash
$ brew install postgresql
```

Run server:

This file has been truncated. show original

commentsBot · December 25, 2022, 1:37pm

sipamungkas · August 30, 2023, 12:29pm

I have a question, Is it effective to store online userId and socketId in the database, and also is it effective to store messages in the database directly and emit an event after the message has been saved?
I mean if there are so many users, how will we handle it if everyone sends messages at the same time and we save it directly to the database?

Thanks in advance