How I Setup Database Migration using Sequelize in Microservice Architecture

How I Setup Database Migration using Sequelize in Microservice Architecture

Learn how I setup database Migration using Sequelize in Microservice Architecture. I am having a conversation with Joe regarding setting up a migration script repository for microservice-based architecture. Creating we go through the step-by-step guide from scratch, let’s have a high-level overview of what we will be having.

Introduction

Once upon a time, I am having a conversation with Joe regarding setting up a migration script repository for microservice-based architecture. Here is how the conversation goes:

Me: Hey Joe, we’re using  Sequelize in our code. But how about our migration? Since we’re using microservice-based architecture if we write our migration file in each service, wouldn’t it hard to manage, and the scripts are scattered everywhere.

Joe: Erm… You probably right. How about we set up a repository called migrations. Where we will centralize all the migration scripts in that repo. So we could have an overview of all the changes in a single repository. What do you think?

Me: That sounds like a good idea. Let’s start looking & work this out.

Step-by-Step Guide

Before we go through the step-by-step guide from scratch, let’s have a high-level overview of what we will be having.

  • A Node Project with sequelize-cli dependencies
  • models folder which contains all the model to the table. We shall always have the latest model structure here so the whole team will check on the repository for the latest table structure.
  • migrations folder which contains all the migration script generated using sequelize-cli and the changes to the database which coded by the developers.

Without further ado, let’s start dive into the details.

technology javascript programming microservice

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Object-oriented Programming in JavaScript: Made Super Simple. DO NOT MISS!!!

Object-oriented Programming in JavaScript: Made Super Simple. Learn all about objects, prototypes, prototypical inheritance, this and more.

JavaScript: Chessboard Program

Exercise from Eloquent JavaScript. Today, we will write a function that forms a chessboard. You can find the exercise in the Eloquent Javascript book (3rd edition, chapter 2; Program Structure). Write a program that creates a string that represents an 8×8 grid, using newline characters to separate lines. At each position of the grid there is either a space or a “#” character. The characters should form a chessboard.

Learning JavaScript: Development Environments for JavaScript Programming

One of the nice things about learning JavaScript these days is that there is a plethora of choices for writing and running JavaScript code. In this article, I’m going to describe a few of these environments and show you the environment I’ll be using in this series of articles.

Learn JavaScript - Full Course for Beginners. DO NOT MISS!!!

In this video tutorial, we'll learn Learn JavaScript - Full Course for Beginners. This complete 134-part JavaScript tutorial for beginners will teach you everything you need to know to get started with the JavaScript programming language. DO NOT MISS!!!

Learning JavaScript: Data Types and Variables

To paraphrase the title of an old computer science textbook, “Algorithms + Data = Programs.” The first step in learning a programming language such as JavaScript is to learn what types of data the language can work with. The second step is to learn how to store that data in variables. In this article I’ll discuss the different types of data you can work with in a JavaScript program and how to create and use variables to store and manipulate that data.