Category Archives: Nodejs

Nodejs

How to connect MySql database with Nodejs

Nodejs is a powerful platform which used for real-time data with flexible of handling data in file system or database side.  Today tutorial we are going to discuss about the connecting MySql with Nodejs.

Before getting into our code part, first will discuss about things needed for MySql connecting with Nodejs then will move to our code side.

First we need to check the MySql package is installed in our current Nodejs version or not. We have the command to check list or individual package installed in Nodejs. If the package is installed it will display the package else show “(empty)” value.

Display list of packages

Nodejs npm list command

Nodejs npm list command

Nodejs npm list packages

Nodejs npm list packages

Let’s see how to execute individual package and their output display. Continue reading

How to monitor connected and disconnect user IP Address in Nodejs

Nodejs have the ability to track the connected and disconnected user IP Address with socket.io node package.

What is Socket.io ?

Socket.io enables real-time directions which is event based communication. Its works on all the platform, browser or device on reliability and speed. We need to check few package it’s installed or not.  if not you can install socket.io and ip both package from your terminal.

Installing socket.io package

Installing socket.io package

Installing ip package

Installing ip package

Once you have installed both the packages, let’s include our needed package into our code and create server where our code will on that port.

var app = require('http').createServer(handler),
	io = require('socket.io').listen(app),
	ip = require('ip');
	app.listen(8001);

handler function will print “Welcome” in browser. Continue reading

Installing npm in NodeJs

NPM is node package manager for NodeJs, which is written fully in JavaScript. NPM runs on terminal or command line and manages dependencies if needed, when author include on the package.

npm-logo

npm logo

To install package just run the below command in terminal or command line. Continue reading

Installing Nodejs in Windows Operating System

nodejs-darkWhen I was analysing real-time data with PHP, MySQL and JavaScript. I came to know some basic stuff like ajax calls, but its not real because we need to set request based on interval.

For example I need to refresh the data, whenever new data is added or update in database. But ajax calls will refresh the data based on the interval.

After that I came to know its not proper way to go, because refresh data means whenever new data got inserted or updated it should be reflected.

So I switched over to Nodejs for real-time data stuff, before installing Nodejs.
We will have brief discuss about it.

What is Nodejs ?
Nodejs is a platform built on v8 Javascript Engine for easy building fast, scalable network applications. Its non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices.

Continue reading