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…)
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.
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…)
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…)