9. Notifications · The story

The story

The last feature of the course, and you get it the way you'd get it at work: as a description of what users should see. No table names, no columns, no hints about which SQL to use.

Feature: notifications

Users get a notification when someone likes one of their posts, comments on one of their posts, or follows them.

The bell icon shows how many unread notifications a user has.

Opening the dropdown lists their 20 most recent unread notifications, newest first. Each one reads like "bob liked Why I switched to Postgres" or "carla followed you".

Clicking "mark all as read" clears the count.

A user is never notified about their own actions.

If the post, or either account involved, is deleted, the notification disappears.