Users can follow other users or questions, but they can receive messages when other users update answers or when questions have new answers
Users can process messages as read or unread, and can know the number of unread messages
What technologies need to be used under node? There are message queue subscriptions (redis?)
How should the database table be designed? It feels like each user has his own independent data that needs to be stored....
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
I think it’s just a table that saves users’ followers. Every time you want to get push information, just go to their personal database to get updated items based on your followers and then feed back. In fact, because push is not a function that requires high accuracy, it can be updated while the user is browsing the page, so it will not have much impact on the experience. Just look at your own needs.