Open In App

How to Run Synchronous Queries using sync-sql Module in Node.js ?

Improve
Improve
Like Article
Like
Save
Share
Report

The sync-sql module is designed to make synchronous queries to the database. Since normal SQL queries are asynchronous in node.js but if you want to run it synchronously, then it is possible using this module. In synchronized SQL, the result set is returned when the query is executed. Note: Do not use this module in production mode as node.js is designed to be asynchronous. 

Installation of sync-sql module:

You can visit the link Install sync-sql module. You can install this package by using this command.

npm install sync-sql

After installing sync-sql you can check your sync-sql version in the command prompt using the command.

npm version sync-sql

After that, you can just create a folder and add a file for example index.js, To run this file you need to run the following command.

node index.js

Project Structure:

project structure

Now open MySQL and create a database for example ‘demo’.

Filename: index.js 

javascript




const Mysql = require('sync-mysql')
 
const connection = new Mysql({
    host:'localhost',
    user:'root',
    password:'password',
    database:'demo'
})
 
let result = connection.query('SELECT NOW()')
console.log(result)


Steps to run the program:

Make sure you install sync-sql using the following commands:

npm install sync-sql

Run the index.js file using the below command:

node index.js

Output:

Output of above command

So this is how you can run synchronized SQL queries in node js using sync-sql package.


Last Updated : 27 Mar, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads