How to get real time data from mysql DB in browser with Node.js

I'll try to answer this as best as possible as I think there are many solutions to this, and I am not entirely sure of your environment setup.

If you want Node to get Real-time data from MySQL and display that on the DOM, there are several things you will have to do (Frontend and Backend) in order to make this work, and it may not be very efficient if we took this approach. Might I suggest looking up the use of Web Sockets, or perhaps even Firebase to achieve your goal. Firebase, allows you to show data in real time even if someone else was to change the data from anywhere in the world, you would see it almost instantaneously. I hope this helps, I would need to know more in order to help you more. :)

Cheers.

Thanks Joshua Eagle,

My application is based on Php Zendframework. I tried Java Script setInterval function with ajax. It's working perfectly. This is running in each seconds. The problem with this is, it's consuming high CPU usage.

Hi Joshua,

Thanks. I didn't try Firebase as much. Basically my first requirement is I want show the user count in a page and it should change in realtime without refreshing.

I will try Firebase. If you could provide any link for this really helpful :).

Thanks very much :) !

This should help you achieve this goal real easily: https://firebase.google.com/

I'm going to see if I can create a simple example of at least showing the data to the user for you with firebase, and a place to update the data, and if you have two browsers open you should be able to see it update in both places instantly. :)

Thanks Joshua !! much appreciated :)

There is no PHP here, but here is a great example. Try running it in your apache server, and open it in two browsers. It should achieve what you are looking for. :)

https://github.com/eaglejs/googleFirebaseExample

Thank for the example, It's really helpful. I setup my account in firebase and got the config code :). Can I connect my mysql DB with Forebase DB.

Well, I don't think you can "connect" them in a clean way. I'm not sure what all you have in your mysql Database, but you may not even need mysql in this instance. But if you wanted to. You might have to look up a way on how to do this with PHP. I'm no php expert. But there are two choices that I can see. Either figure out how to use PHP to connect with your Mysql and update firebase based on the data of mysql, or simply use firebase straight. Either way, You will probably need PHP to figure this out. It's up to you. I found this php client for firebase. Hopefully this can get you in the right direction.

https://github.com/ktamas77/firebase-php

Actually I need to use MySql, its not just user count I may need to use other functionalities also. I want to find a way to connect my current MySql Db with firebase. Current Mysql has around 50 Tables can't change that :(.

I found this https://zapier.com/zapbook/firebase/mysql/. what do you suggest on this?

That might work, I have never used it. Give it a shot! :)

Hi Joshua,

Could you provide any links or tutorial related to websocket integration. I tried firebase, but we can't connect mysql with Forebase DB. we need to duplicate Db's for this. So I think lets try websocket. I'm new to nodejs, but I love to learn this.

Thanks Joshua for your supports

Give these a shot. I know Node.js example is a little more involved, an you can omit a lot of this code, but the concept is there.

http://code.tutsplus.com/tutorials/using-nodejs-and-websockets-to-build-a-chat-service--net-34482

Alternatively, I believe PHP has a plugin that might be able to help you. This might be more the route that you might want to take. Since it adheres to your stack.

http://socketo.me/