You write to the database, and have a separate notification-sender that feeds on the database change stream, sends out notifications, and keeps track of which n

You write to the database, and have a separate notification-sender that feeds on the database change stream, sends out notifications, and keeps track of which notifications it has sent. If that process crashes, it will re-send one or maybe a few notifications.