can we use triggers in Node.js and MySQL ? for example I have in my database a table A. And when a user edit a record a message appear : " the table is modified"
any suggestion !? and thank you
Asked
Active
Viewed 4,251 times
2
-
That's not how triggers work. – SLaks Jun 06 '13 at 19:32
-
can you explain me how i can do my example ?? thank you. – dardar.moh Jun 06 '13 at 19:35
-
There is no simple way to do that that I know of. Consider changing the processes that write to the DB to push a notification over something like Redis or RabbitMQ. – SLaks Jun 06 '13 at 19:40
1 Answers
2
It's technically possible to have a MySQL trigger call a user-defined function (UDF) that can contain a system call using sys_exec(), for example. However this solution would be complicated and you would still need to have the client poll the server for changes if you want to display a message in near real-time.
Personally I wouldn't bother with using triggers and just have another process monitor for changes which I would then poll periodically. You could possibly check the table's last update time. The exact implementation would depend on the details of your database structure and how much traffic you need to handle.
Here is a similar question that has more discussion: Invoking a PHP script from a MySQL trigger
Community
- 1
- 1
nullability
- 10,545
- 3
- 45
- 63