Create a notification server using MySql/ Node js

Question

I am working on a project where I should post notification whenever an database event is fired.

I am using NODE for this. BUt I am not sure whether I'll be able to do it or not.

I came across this question On SO but It didn't help much.

What my Real questions are:

1) Is there anything like reading MySql triggers in Node js. ? Can I push instant notification as soon as a row is entered in the desired table?

2) If Yes, How should I go about it?

3) If it is not possible and I have to check the DB changes manually after every few seconds, Why should I use Node.js instead of making asynchronous calls from browser after every few seconds using jQuery?

Any help would be appriciated...!

hexacyanide · Accepted Answer · 2013-09-03 02:52:17Z

1

As for as I know, there isn't any simple way to read database triggers in Node, so a common solution is to use Redis as a publish system, and have a connector module perferm the actual database query. A very popular MySQL connector for Node is this one, so I will be using it as an example.

When using a module, the "MySQL triggers" you're looking for are just simple callbacks that you would find with most asynchronous modules. Here's an example of a query with the node-mysql module:

var post  = {id: 1, title: 'Hello MySQL'};
connection.query('INSERT INTO posts SET ?', post, function(err, result) {
  //the database transaction has completed, notify the client
});

When the callback is called, that means the database operation has either completed, or failed (check the err property in the callback to check this). You could then send this change to a browser using EventSource/Server-Sent Events or WebSockets.

As a side answer to your third question, pushing data from the server to client will always be more efficient than the client consistently asking for data, because the server is not guaranteed to have need data when the client has asked for it.

answered Sep 3, 2013 at 2:52

hexacyanide

92.4k31 gold badges168 silver badges162 bronze badges

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

3 Comments

writeToBhuwan Over a year ago

Can I get a full documentation of 'node-mysql' somewhere? Can you please explain the code you've written? I am little new to Node JS DB

writeToBhuwan Over a year ago

+1 for the third answer.. Though I am not completely satisfied with first two explanations... So not accepting it as an answer..

hexacyanide Over a year ago

The documentation for the module is on the GitHub page, the same link in my answer. The code I've written performs an insert on an established database connection, and returns the result in the callback.

Collectives™ on Stack Overflow

Create a notification server using MySql/ Node js

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related