Saturday, 20 May 2017

What is the best structure for a chat pub-sub? (PubSub server agnostic)

Hey guys so just so I'm using PostgreSQL with my server already so I thought I would use its PubSub capabilities with NOTIFY. I was wondering what would be the best way to publish chat messages? I thought of maybe creating one channel per user and publishing all types of messages for that user there, but I'm guessing that will eventually go over Postgres' cap for channels. Otherwise what would be the best way to structure this?



via Duxducis

No comments:

Post a Comment