Skip to content

Latest commit

 

History

History
20 lines (14 loc) · 564 Bytes

File metadata and controls

20 lines (14 loc) · 564 Bytes

Hassle free, Fetch & show Live Data from Mysql / SqlServer using Node.JS & Socket.IO

Socket.IO : To connect web socket connection with server which will emit data every second from DB.

/getLiveData : Endpoint to check connection is ready we can fetch Data from DB.

Query : SELECT * FROM node_test.View_Pending - MySQL query to Fetch data from DB (VIEW)

getLiveData : Socket name from which we listen & emit data to & fro

UI : Can export to CSV Can start / stop listening to data (Switch) Can search data from table

![Live Data Fetch](Live Data Fetch.jpg)