Integration of MySQL with NodeJS Backend and ReactJS FrontEnd

Question

I want to develop an ERP application with ReactJs in FrontEnd, NodeJS in BackEnd and MySQL for the database.

My ERP is also the management of customers, suppliers, purchase orders, delivery notes and products.

I want to know about the integration of MySQL with NodeJS does it require ORM models like Sequelize?

Thanks in advance.

No, it does not. You can connect from your code directly to MySQL without any ORM. — Shadow
– Shadow, Commented Jun 27, 2018 at 11:15
no, unless you want to use ORMs. you can search to simple module in npmjs.com to handle data connection and other raw things. And then just write SQL queries. If you prefer to use ORM - you may find also few I believe. — zmii
– zmii, Commented Jun 27, 2018 at 11:16
I want to use MySQL with nodeJS directly, but I don't know if it is possible or not on my project ? — Ichrak Mansour
– Ichrak Mansour, Commented Jun 27, 2018 at 11:19

gnomes · Accepted Answer · 2018-07-20 14:13:41Z

1

There is no absolute need for an ORM. You can install the mysql driver for node.js through npm and include it in your project. The documentation can be found here: https://www.npmjs.com/package/mysql

You could implement it like this:

var sql = require('mssql');

var config = {
    user: "databaseAccountUsername",
    password: "databaseAccountPassword",
    server: "databaseServerAddress",
    database: "databaseName",
    options: {
        encrypt: false
    }
}

const pool = new sql.ConnectionPool(config);
    pool.connect(err => {
    if(err) {
        console.log(err)
    }
});

function getCustomers() {
    var request = new sql.Request(pool);
    request.query("SELECT customer_id, first_name FROM customers")
    .then((result) => {
        res.end(JSON.stringify(result.recordsets[0]));
    })
    sql.close();
}

I suggest making your queries in your routes and handling them with express or any other request/response library

edited Jul 20, 2018 at 14:13

answered Jun 27, 2018 at 12:31

gnomes

391 silver badge5 bronze badges

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

1 Comment

gnomes Over a year ago

@CodeLover Not sure what you meant by your comment, but I assume you wanted the post edited with the code using the library.

Collectives™ on Stack Overflow

Integration of MySQL with NodeJS Backend and ReactJS FrontEnd

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