Web Notifications using MySQL Triggers

Question

I have several questions and I hope you guys could help me out. For the record, I'm developing a web application using PHP, CodeIgniter MVC, MySQL, etc.

Can I use MySQL triggers to create notifications? Is it the best way or practice in creating such a feature?
What does "polling" the database actually mean?
What is the best way to mark a certain notification "read" or "seen"? Is it right after a web page showing the notification has been loaded?

Vineesh · Accepted Answer · 2013-09-23 11:41:57Z

1

Can I use MySQL triggers to create notifications? Is it the best way or practice in creating such a feature? Yes you can. Whenever a new message comes to your system, you can update the notification table using trigger.

What does "polling" the database actually mean? "polling" is the Technic, to periodically/continuously fetch the data from your database table. This can be achieved using Synchronous AJAX request which can periodically call PHP script to see is there any unread notifications.

What is the best way to mark a certain notification "read" or "seen"? Is it right after a web page showing the notification has been loaded? The best way is to define a flag in your notification table, which will be updated once the user reads the notification.

answered Sep 23, 2013 at 11:41

Vineesh

4474 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

christianleroy Over a year ago

What if my notification is about a new event in the website and not about a message? I mean, for example, a new appointment reservation has been submitted? Is MySQL trigger the best way too?

Vineesh Over a year ago

If you are going to create a notification table for all the notifications in your website, trigger will be the best way to update your notification table. Otherwise you can query your event table directly to see If there any new events.

Collectives™ on Stack Overflow

Web Notifications using MySQL Triggers

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related