Chapter 2.  Build a Basic Website Using MySQL Database

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