How to organize notifications on the site?

Question

PHP

I implement comments for the site on posts in php / mysql (I write it myself because I like to create a new bike, but that’s not the point ...)
You need to implement a notification about a response or a new comment
How sensible to do it:
- notify immediately when added to the table
- create cron job
or your version...?

Answer 1

Implement the observer pattern or use the already built-in implementation of SplObserver