Do you use migrations for data manipulations? What are the pro's and con's ?

This page summarizes the projects mentioned and recommended in the original post on reddit.com/r/rails

Our great sponsors
  • Scout APM - Less time debugging, more time building
  • SonarLint - Clean code begins in your IDE with SonarLint
  • SaaSHub - Software Alternatives and Reviews
  • migration_data

    Safely migrate data in ActiveRecord migrations and keep them up to date.

    Migrations - I use this gem https://github.com/ka8725/migration_data

  • Large Hadron Migrator

    Online MySQL schema migrations

    I may do it from the console or a task if I wanted to modify a large number of records, e.g. something in my Users table. I think you need a sense of how long the update will take - I'm not sure if there's any issue with migrations timing out or such like. If I modify my Users schema it takes 5 minutes or so as it has to make a copy of the table and swap it in and that works fine - https://github.com/soundcloud/lhm

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • maintenance_tasks

    A Rails engine for queueing and managing maintenance tasks for data migrations and backfills.

    We use this technique. https://github.com/Shopify/maintenance_tasks. It is similar to a job (it uses a job under the hood) that can be be paused, interrupted by a deploy, and even aborted.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts