Setting up Sqitch (Blog Post on Progress)

Sqitch is a command line tool that you can use for database migration. My purpose learning sqitch was so that I can know how to set up database migrations in pure SQL.

This is mainly a note and not a complete replacement for sqitch tutorial here that you can read here.

The first thing that you need to know about sqitch that it will have three directories. The directories are deploy, revert, and verify. The deploy directory will contain the SQL codes that you use to create the structure of the database. The verify directory contains SQL codes to verify the success of the deployment. The revert directory will, you guess it, contain SQL codes to revert the changes that you have made.

It has has two configuration files in the folder. One is a sqitch.conf and the other is sqitch.plan. The sqitch.conf contains the information about the database you use like the database address and the sqitch.plan contains the changes that you have made to your migrations.