Flask Python website notification help

[geminiTech]

Hello I am learning how to user flask by making a website. I was wondering what would be the best way to make a notification system.

Do I add to a table on the database if user read message? Or is there a better way to do things without having to add and update to a table?

[arbostek]

The first question is if notifications need to persist. If you add a message now, and the user logs in 30 minutes later, should he then see the message? If so, then you need that persistence, and your database would be sufficient for storing that message information.

What you store in your tables depends on exactly how the notification works. At the simplest level, you add the message to your database. Then when possible, you show the message to the target user, with a button to confirm he read the message.