Schema Migrations on Every Deploy: Run Them When Your App Starts

[julia-kafarska]

Full tutorial with screenshots: https://blog.light-cloud.com/tutorials/database-migrations-in-deploys

Part 7 of 8 of the series Databases on Light Cloud.

Run database migrations on every Light Cloud deploy: a node-pg-migrate SQL file, npm start running it before the server, and why rollbacks leave the schema alone.

Level: Intermediate · Time: about 15 minutes · Plan: Lite · Stack: PostgreSQL, Node.js, node-pg-migrate

Steps

• Step 1: Add node-pg-migrate
• Step 2: Write the migration
• Step 3: Run it on start
• Step 4: Push and watch

Source code: https://github.com/light-cloud-com/tutorial-database-basics

---

Questions, problems with a step, or a screen that no longer matches the console? Reply here. Every tutorial is re-run on the live platform before it is published, and this thread is where fixes get discussed.