Best approach to save notification and posts

Question

1.00/5 (2 votes)

See more:

I am developing a notification and post system. I have done a database design where there are user ids for who is sending notification, to whom its being sent and notification text field.
Now my question is, should I save the notification with html format what I'll show in front end, like user name, user image etc or just save the raw data and make a join query with users table while fetching the notification.

What is the best structure?

And in facebook we can see post title like "ABC has shared BCD's post". And link on ABC and BCD. So do facebook save the full format in table or format it while fetching the data?

Can you please help me with the good approach please.

What I have tried:

I designed the database as stated above.

Posted 20-Jan-18 20:24pm

souvikcode

Updated 21-Jan-18 3:01am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2018-01-21T03:01:00

Solution 1

You should store the raw data such as the ids of the sender and recipient and also the message they want to send. It makes it easier to work with the data and will mean you store less redundant data in your database; you're not storing the "from" and "to" names for example, you just retrieve those when you show the message. It also means that if a user changes their name then when they view the message the correct name is always shown.

Posted 21-Jan-18 3:01am

F-ES Sitecore

Comments

souvikcode 21-Jan-18 10:09am

Thanks. I also think to save the raw data, but I'm worried can I set SignalR after fetching data by joining and then push the notification to users?
And what you think facebook also save raw data and while fetching it format as ABC shared BCD's post?
And the links to ABC and BCD are given in front end while showing the data?

F-ES Sitecore 22-Jan-18 4:13am

I've never used SignalR but I don't see why not. I doubt MS would create a technology that didn't allow you to join tables.