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

• migration_data

  1 364 0.0 Ruby

  Migrate data along with schema migrations in Rails and keep them up to date.

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

• Large Hadron Migrator

  3 1,815 0.0 Ruby

  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

• InfluxDB

  www.influxdata.com

  sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• maintenance_tasks

  2 903 9.0 Ruby

  A Rails engine for queueing and managing data migrations.

  

  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.

Suggest a related project