## Summary

Database migrations.

Usage

Install globally:

npm install dbmigrations -g

...or in your project (doesn't need to be nodejs):

npm install dbmigrations --save-dev

Create ./migrations directory:

mkdir migrations

Create migration file:

dbmigrations create --name create_users

Run migration against database:

dbmigrations migrate --url postgres://localhost/test

Passwords can be read from ~/.pgpass file.

You can also create js-based migration file with --js flag.

Use dbmigrations --help or dbmigrations migrate --help for sub-commands to get more info.

Configuration

You can create ./.dbmigrations.json configuration file. You can define environments (a list of urls):

{
  "envs": {
    "dev": [
      "postgres://localhost/test1",
      "postgres://localhost/test2"
    ],
    "staging": [
      "postgres://staging/test1",
      "postgres://staging/test2"
    ]
  }
}

To run migrations for all databases defined in environment use:

dbmigrations migrate --env dev

Notes

• currently only postgres is supported
• currently there's no support for down-migrating

If you're interested in any of those (or you think something else is missing) please create an issue or pull request.

License

MIT