Scaffold Project

SQL Migrations

🙋 Need help? Ask an expert now!

Maitaining an RDBMS for Your Web Service

Since this is meant to be a light course, for now please copy the migrations/, seed/, and dockersql directories from here, here, and here, respectively. The general idea is that we'll create .sql files that can be used manually (or with a mgiration tool) to create migrations and seeds that we can easily manage. We also have dockersql for the docker-compose sql initialization.

For more in-depth docs and reference, please check out migrate which is the tool that our migrations will be compatible with! Note that we will refrain from using/discussing the tool itself in this course.

The following sections will assume that you have copied (and hopefully reviewed!) the migrations/, seed/, and /dockersql directories from the GitHub repo, but have not yet executed them anywhere.