We have just set up a MySQL database, and we want to use it inside of our Node.js back end. There are many libraries to connect and query your MySQL database. We are going to use Sequelize in this book.
Alternatives include Waterline ORM and js-data, which offer the same functionalities as Sequelize. What's 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...
