Real time non-push notification in nodejs

Can someone help me to design notification in Node.js and MySQL? The notification should not be push notification but real time i.e I want to store it as well like Facebook etc.

Comments

[Dávid Szabó]

So what do you need help in? Do you need database design or library recommendations or?

[sudoshreyas]

basically i want to do it exactly facebook or in fact dev.to has done.I do not know how to proceed.

[sudoshreyas]

actually both.

[Dávid Szabó]

Where are you at right now?

Database design depends on the features you need.
You can just simply create a notification table, something like this

id - integer
user_id - integer
content - varchar or text
read - boolean
created_at - timestamp

dev.to and facebook is much more complicated than a simple notification

Using google I found a discuss which may help: hashnode.com/post/architecture-how...

[sudoshreyas]

thanks a lot