This is a small Rust application for managing database migrations for MySQL.

It compiles into a single binary called rmmm.

Configuration, by default, is through the db/ directory of the directory in which rmmm is invoked. Migrations will live in db/migrations/v{version}.sql, rollbacks in db/migrations/v{version}_downgrade.sql, and structure will be dumped to db/structure.sql.

Basic usage:

1. cargo install rmmm
2. rmmm generate foo will pop up an editor for you to write a migration. Migrations may be any number of SQL statements on lines by themselves ending with the ; character. Comments are stripped.
3. rmmm status will show all pending migrations
4. rmmm upgrade latest will apply pending migrations. You can also upgrade (or downgrade) to a specific version.

Versions are just incrementing integers for simplicity.

Configuration is typically through environment variables:

| Environment Variable | Meaning | |----------------------|---------| | $DATABASE_URL | URL (mysql://) to connect to MySQL | | $MIGRATION_PATH | Path to store state (defaults to ./db) |

This work is licensed under the ISC license, a copy of which can be found in LICENSE.txt.

Why?

There are lots of migration management tools. A popular stand-alone choice is dogfish; there are also tools using richer libraries for various ecosystems such as barrel for diesel, or Python's alembic.

This tool is closest to dogfish, but avoids the various shell injection risks and uses the same DATABASE_URL configuration string as other common frameworks (Rust's mysql, Python's sqlalchemy, Ruby's activerecord, etc).