Add Postgres adapter for socket communication
Since we have more than one server, we need this adapter as a way to notify all the servers of a specific event, so all the clients get notified. For example, we receive a valid payment on only one server, and we need a way to notify all the users who might be connected to the other server.
✅ Tests will run for this PR. Once they succeed it can be merged.
Please provide context about why this is needed and what purpose does it serve
Would like to know more about this before it gets merged
https://docs.nestjs.com/websockets/adapter https://socket.io/docs/v4/postgres-adapter/
If i correctly understood the socket.io adapter docs, this is only needed in cases when we want to emit messages across multiple server instances, which does not seem to be the case for us, at least for now.