Skip to main content

Nodejs and PostgreSQL Tutorial with Example

Postgresql database connectivity in NodeJS

PostgreSQL is one of the popular open source [Object]- relational database, PostgreSQL supports json datatypes as well as you can define your own datatypes so its a good choice to use in your project. If you are using Nodejs as backend then you need PostgreSQL database driver to connect with nodejs. There are various driver available but most popular and well documented  is node-postgres [pg] so today we are going to learn how to use PostgreSQL with nodejs using stored procedure and connection pooling. Let’s start. (more…)

Nodejs and MySQL Tutorial With Example

Nodejs and Mysql Database Connectivity

Today We are going to learn MySQL database connectivity with nodejs . MySQL is very popular and open source database people use so if you also going to use mysql in your project then this tutorial will help you.  You know database is required to save user data and mysql is good choice in this. In this tutorial i will cover calling simple query , stored procedure using nodejs application on mysql and how to call db query in high load website so lets start.

(more…)

Access SQL Server with Nodejs Tutorial

Nodejs and MS SQL Server Database Connectivity

Hello Friends, Today I am going show you how to connect SQL Server Database with nodejs. Developing a dynamic website required data to save on persistent place like database, So if you are using nodejs for your website development and using SQL Server as database to store data then you need connectivity between nodejs application to sql server database. There are many database drivers available for mssql connectivity with nodejs but I am going to use one of the popular and active driver for sql server is mssql , so lets start. (more…)

Simple Web Server Using NodeJs and ExpressJs

Nodejs and expressjs

Today , I am going to show you how to create a simple web server using node.js and express.js. If you are new about nodejs then read about nodejs on https://nodejs.org . You can create a web server with nodejs using few lines of code. Just to go nodejs home page and download the latest version of nodejs and install on your machine [windows, mac or Linux]. I have installed nodejs on my windows machine. To check whether nodejs has been installed successfully in your machine , go to command prompt and run command node -v it will print current version of nodejs if installed successfully. (more…)