Book Image

Node.js 6.x Blueprints

By : Fernando Monteiro
Book Image

Node.js 6.x Blueprints

By: Fernando Monteiro

Overview of this book

Node.js is the most popular framework to create server-side applications today. Be it web, desktop, or mobile, Node.js comes to your rescue to create stunning real-time applications. Node.js 6.x Blueprints will teach you to build these types of projects in an easy-to-understand manner. The key to any Node.js project is a strong foundation on the concepts that will be a part of every project. The book will first teach you the MVC design pattern while developing a Twitter-like application using Express.js. In the next chapters, you will learn to create a website and applications such as streaming, photography, and a store locator using MongoDB, MySQL, and Firebase. Once you’re warmed up, we’ll move on to more complex projects such as a consumer feedback app, a real-time chat app, and a blog using Node.js with frameworks such as loopback.io and socket.io. Finally, we’ll explore front-end build processes, Docker, and continuous delivery. By the end of book, you will be comfortable working with Node.js applications and will know the best tools and frameworks to build highly scalable desktop and cloud applications.
Table of Contents (16 chapters)
Node.js 6.x Blueprints
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface

Creating the database on MySql


Before attempting to access the Mysql console make sure that it is running. To check that:

  1. Open terminal/shell and login your Mysql with the following command:

          mysql -u root
    
  2. Remember, if you are using a different user or password, using the following command and replace youruser and yourpassword for your own credentials:

          mysql -u youruser -p yourpassword
    
  3. Now let's create our database, type the following command:

          CREATE DATABASE mvc_mysql_app;
    
  4. The result after the command will be the following line:

          Query OK, 1 row affected (0,04 sec)
    

This confirms that the operation was successful, and we are ready to go forward.

Using db migrations to insert data on Mysql

Now is the time to do the migration of the schemes to the database. Again we use the sequelize-cli for this migration. Before we proceed, we need to install a Mysql module manually.

  1. Open terminal/shell and type the following command:

          npm install
    

    Tip

    Note that the Sequelize interface...