How to switch between mysql and mongodb in nodejs

Question

I'm setting up a new nodejs API which will deliver the data on the front end side as soon as the user click a "Search" button. I want to implement a functionality in which user is able to select which db to use i.e( Mysql or MongoDB). So how can I switch between both the database in a single API.

Waqas Javed · Accepted Answer · 2019-10-10 05:44:18Z

3

Well you can have instances of Mysql and MongoDb both on Node.js side. You will be sending selected db inside the API and based on the selected db you will use the instance. In this case you will have to implement both Mongo and Mysql queries.

if(selectedDb == "MongoDB"){
   // db.collection.find(query, projection)
   // use Mongo Logic here
}else{
    con.connect(function(err) {
      if (err) throw err;
      con.query("SELECT * FROM customers", function (err, result, fields) {
        if (err) throw err;
        console.log(result);
      });
    });
}

I hope it solves your problem.

answered Oct 10, 2019 at 5:44

Waqas Javed

4242 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

varun chauhan Over a year ago

i will try this approach. Thanks for the help

Collectives™ on Stack Overflow

How to switch between mysql and mongodb in nodejs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related