Squasher

Squasher compresses old migrations in a Rails application. If you work on a big project with lots of migrations, every rake db:migrate might take a few seconds, or creating of a new database might take a few minutes. That's because Rails loads all those migration files. Squasher removes all the migrations and creates a single migration with the final database state of the specified date (the new migration will look like a schema).

Installation

You don't have to add it into your Gemfile. Just a standalone installation:

$ gem install squasher

@note if you use Rbenv don't forget to run rbenv rehash.

If you want to share it with your rails/sinatra/etc app add the below:

# Yep, the missing group in most Gemfiles where all utilities should be!
group :tools do
  gem 'squasher', '>= 0.3.0'
  gem 'capistrano'
  gem 'rubocop'
end

Don't forget to run bundle.

To integrate squasher with your app even more do the below:

$ bundle binstub squasher
$ # and you have a runner inside the `bin` folder
$ bin/squasher

Usage

@note stop all preloading systems if there are present (spring, zeus, etc)

Suppose your application was created a few years ago. %app_root%/db/migrate folder looks like this:

2009...._first_migration.rb
2009...._another_migration.rb
# and a lot of other files
2011...._adding_model_foo.rb
# few years later
2013...._removing_model_foo.rb
# and so on

Storing these atomic changes over time is painful and useless. It's time to archive all this stuff. Once you install the gem you can run the squasher command.

$ squasher 2014 #compress all migrations which were created prior to the year 2014

You can tell squasher a more detailed date, for example:

$ squasher 2013/12    #prior to December 2013
$ squasher 2013/12/19 #prior to 19 December 2013

Options

-d/--dry - execute in dry mode - test a squashing process without deleting old migrations. The final output will be printed in the console.

-r/--reuse - reuse a database from previous squashing process. The option can be used in the next cases:

• you've run squasher in dry mode before and there were no errors
• you're squashing migrations gradually. For example, you want to squash migrations from 2013 till 2015, but the process breaks in a migration from 2014. In this situation you squash till 2014, save the squasher's database at the end, make a patch in the broken migration and run again the suite with -r option. As the result squasher will not need to create the db schema and all data from the previous migrations will be there.

-e/--engine - tell squasher that you are squashing a Rails engine. To squash migrations you need to configure a dummy app. If your dummy app located outside the engine's folder provide path to it as the next argument squasher --engine ../my-engine-app 2016

-m/--migration - for correct work with Rails 5 specify a migration version like squasher -m 5.0 ...

Requirements

It works and was tested on Ruby 2.0+ and Rails 3.1+. It also requires a valid development configuration in config/database.yml and using Ruby format in db/schema.rb (default Rails use-case). If an old migration inserted data (created ActiveRecord model records) you will lose this code in the squashed migration, BUT squasher will ask you to leave a tmp database which will have all data that was inserted while migrating. Using this database you could add that data as another migration, or into config/seed.rb (the expected place for this stuff).

Changelog

• 0.5.1
  • Fix work on Windows machines (@tobmatth)
• 0.5.0
  • Rework command line integration. Fix clean process with Rails 5
• 0.4.0
  • Support rails versioned migrations which were introduced in Rails 5
• 0.3.1
  • fix init migration generation
• 0.3.0
  • rails engines support (@JakeTheSnake3p0)
  • move messages from JSON file to YAML
  • allow to use a db config with a "soft" parsing errors
• 0.2.2
  • strip white spaces in init migrations
• 0.2.1
  • support rails 5
• 0.2.0
  • add dry mode and ability to reuse the previous squasher database
  • improve database config processing
  • raise the minimum supported version of Ruby
• 0.1.7
  • a regression fix of the log output (@lime)
  • improve a multi-platform support (@johncarney)
• 0.1.6
  • support multiple database settings (@ppworks)

Contributing

1. Fork it
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create new Pull Request