Integrating Sequelize into our Node.js stack
We have just set up a MySQL database, and we want to use it inside of our Node.js backend. There are many libraries to connect to and query your MySQL database. We are going to use Sequelize in this book.
Alternative Object–Relational Mappers (ORMs)
Alternatives include Waterline ORM and js-data, which offer the same functionalities as Sequelize. What is great about these is that they not only offer SQL dialects, but also feature database adapters for MongoDB, Redis, and more. So, if you need an alternative, check them out.
Sequelize is an ORM for Node.js. It supports the PostgreSQL, MySQL, SQLite, and MSSQL standards.
Install Sequelize in your project via npm. We will also install a second package, called mysql2:
npm install --save sequelize mysql2
The mysql2 package allows Sequelize to speak with our MySQL server.
Sequelize is just a wrapper around the various libraries for the different database systems. It...
