In this chapter we will look at some basic concepts of a Node.js application using a relational database, in this case Mysql.
Let's look at some differences between Object Document Mapper (ODM) from MongoDB and Object Relational Mapper (ORM) used by sequelize and Mysql. For this we will create a simple application and use the resources we have available which is sequelize, a powerful middleware for creation of models and mapping database.
We will also use another engine template called Swig and demonstrate how we can add the template engine manually.
In this chapter we will cover:
How to use the Swig template engine
Changing default routes from an express generator to the MVC approach
Installing Squelize-CLI
How to use ORM with Sequelize Models
Working with database migrations scripts
How to dealing with MySQL database relations