Skip to content

Courses
Tutorials
Practice
Contests

NodeJS Tutorial
NodeJS Exercises
NodeJS Assert
NodeJS Buffer
NodeJS Console
NodeJS Crypto
NodeJS DNS
NodeJS File System
NodeJS Globals
NodeJS HTTP
NodeJS HTTP2
NodeJS OS
NodeJS Path
NodeJS Process
NodeJS Query String
NodeJS Stream
NodeJS String Decoder
NodeJS Timers
NodeJS URL
NodeJS Interview Questions
NodeJS Questions
Web Technology

How to use .env file in NodeJS MySQL?

How to use Sequelize in Node.js ?

Last Updated : 20 May, 2020

Comments

Improve

Suggest changes

Like Article

Like

Report

Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite, and Microsoft SQL Server. Its features are solid transaction support, relations, eager and lazy loading, read replication and many more.

Features of Sequelize:

Sequelize is a third-party package to be precise its an Object-Relational Mapping Library(ORM)..
Standardization ORMs usually have a single schema definition in the code. This makes it very clear what the schema is, and very simple to change it.
No need to learn SQL – queries are written in plain JavaScript.

Setting up a Node.js app:

Start Node.js app using the following command:
```
npm init -y
```

Installation of Sequelize:

Sequelize needs MySql module installed in your project. if you have not installed MySql module then make sure before installing Sequelize you need to install MySql2 module. You need to install this module by using the following command.
```
npm install mysql2
```
After installing the MySql2 module, we have to install Sequelize module to install this module by using the following command.
```
npm install sequelize
```

Requiring module:

You need to include Sequelize module in your project by using these lines.
```
const Sequelize = require('sequelize');
```

Configuring database.js file:

   // Include Sequelize module 
const Sequelize = require('sequelize') 
  
// Creating new Object of Sequelize 
const sequelize = new Sequelize( 
    'DATABASE_NAME', 
    'DATABASE_USER_NAME', 
    'DATABASE_PASSWORD', { 
  
        // Explicitly specifying  
        // mysql database 
        dialect: 'mysql', 
  
        // By default host is 'localhost'            
        host: 'localhost'
    } 
); 
  
// Exporting the sequelize object.  
// We can use it in another file 
// for creating models 
module.exports = sequelize 
 
  

How to use .env file in NodeJS MySQL?

kartikmukati

Improve

Article Tags :

Node.js
Web Technologies
Node.js-Misc

Similar Reads

How to update data in sqlite3 using Node.js ?

In this article, we are going to see how to update data in the sqlite3 database using node.js. So for this, we are going to use the run function which is available in sqlite3. This function will help us to run the queries for updating the data. SQLite is a self-contained, high-reliability, embedded,

How to Setup View Engine in Node.js ?

View engines are useful for rendering web pages. There are many view engines available in the market like Mustache, Handlebars, EJS, etc but the most popular among them is EJS which simply stands for Embedded JavaScript. It is a simple templating language/engine that lets its user generate HTML with

How to Manage Users in Socket.io in Node.js ?

Socket.IO is a library that enables real-time, bidirectional, and event-based communication between the browser and the server. Managing users in Socket.io and Node.js typically involves handling user connections, disconnections, and broadcasting messages to specific users or groups of users Prerequ

How to use .env file in NodeJS MySQL?

Environment variables are list of properties defined by key and value used for storing configurations data for instance the database credentials, api keys and so on. In the past, these values were directly coded into your applicationsâ€™ code and were not flexible to change, but today we can store the

Node.js MySQL-Create Table Using Sequelize

Introduction to Sequelize: Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. Its features are solid transaction support, relations, eager and lazy loading, read replication and many more. Connect to MySql Database using Sequelize: To establish co

How to Send JSON Response using Node.js ?

NodeJS is the runtime environment, which can execute the javascript code on any platform. It is widely used to create and run web application servers because of its salient features. During production, several times we need to send the resources or some type of information as a response, and javascr

How to Create Table in SQLite3 Database using Node.js ?

Creating a table in an SQLite database using Node.js involves several steps, including setting up a connection to the database, defining the table schema, and executing SQL commands to create the table. SQLite is a lightweight and serverless database that is widely used, especially in applications t

How to Connect SQLite3 Database using Node.js ?

Connecting SQLite3 database with Node.js involves a few straightforward steps to set up and interact with the database. SQLite is a self-contained, serverless, zero-configuration, transactional SQL database engine, making it ideal for small to medium-sized applications. Hereâ€™s how you can connect an

How to read and write files in Node JS ?

NodeJS provides built-in modules for reading and writing files, allowing developers to interact with the file system asynchronously. These modules, namely fs (File System), offer various methods for performing file operations such as reading from files, writing to files, and manipulating file metada

How to Use Prepared Statements in MySQL with Node.js

MySQL prepared a database by pre-compiling the SQL query with a set of placeholders for parameters. You could use the MySQL2 or MySQL library to be connected to your MySQL database and execute queries by passing the SQL statement with an array of values for the placeholders. It prevents SQL injectio

Corporate & Communications Address:

A-143, 7th Floor, Sovereign Corporate Tower, Sector- 136, Noida, Uttar Pradesh (201305)

Registered Address:

K 061, Tower K, Gulshan Vivante Apartment, Sector 137, Noida, Gautam Buddh Nagar, Uttar Pradesh, 201305

Advertise with us

Company
About Us
Legal
Privacy Policy
In Media
Contact Us
Advertise with us
GFG Corporate Solution
Placement Training Program

Languages
Python
Java
C++
PHP
GoLang
SQL
R Language
Android Tutorial
Tutorials Archive

DSA
Data Structures
Algorithms
DSA for Beginners
Basic DSA Problems
DSA Roadmap
Top 100 DSA Interview Problems
DSA Roadmap by Sandeep Jain
All Cheat Sheets

Data Science & ML
Data Science With Python
Data Science For Beginner
Machine Learning
ML Maths
Data Visualisation
Pandas
NumPy
NLP
Deep Learning

Web Technologies
HTML
CSS
JavaScript
TypeScript
ReactJS
NextJS
Bootstrap
Web Design

Python Tutorial
Python Programming Examples
Python Projects
Python Tkinter
Python Web Scraping
OpenCV Tutorial
Python Interview Question
Django

Computer Science
Operating Systems
Computer Network
Database Management System
Software Engineering
Digital Logic Design
Engineering Maths
Software Development
Software Testing

DevOps
Git
Linux
AWS
Docker
Kubernetes
Azure
GCP
DevOps Roadmap

System Design
High Level Design
Low Level Design
UML Diagrams
Interview Guide
Design Patterns
OOAD
System Design Bootcamp
Interview Questions

Inteview Preparation
Competitive Programming
Top DS or Algo for CP
Company-Wise Recruitment Process
Company-Wise Preparation
Aptitude Preparation
Puzzles

School Subjects
Mathematics
Physics
Chemistry
Biology
Social Science
English Grammar
Commerce
World GK

GeeksforGeeks Videos
DSA
Python
Java
C++
Web Development
Data Science
CS Subjects

@GeeksforGeeks, Sanchhaya Education Private Limited, All rights reserved

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy

Improvement

Suggest Changes

Help us improve. Share your suggestions to enhance the article. Contribute your expertise and make a difference in the GeeksforGeeks portal.

geeksforgeeks-suggest-icon

Create Improvement

Enhance the article with your expertise. Contribute to the GeeksforGeeks community and help create better learning resources for all.

geeksforgeeks-improvement-icon

Suggest Changes

min 4 words, max Words Limit:1000

Thank You!

Your suggestions are valuable to us.

What kind of Experience do you want to share?

Interview Experiences

Admission Experiences

Career Journeys

Work Experiences

Campus Experiences

Competitive Exam Experiences