safe-pg-migrations
strong_migrations
| safe-pg-migrations | strong_migrations | |
|---|---|---|
| 6 | 17 | |
| 481 | 3,859 | |
| 1.3% | - | |
| 8.5 | 7.9 | |
| 1 day ago | 7 days ago | |
| Ruby | Ruby | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
safe-pg-migrations
- Show HN: safe-pg-migrations, ActiveRecord migrations for Postgres made safe
- Gérer ses migrations sans downtime
- Show HN: Zero-downtime PostgreSQL migrations for Ruby on Rails
-
Database... or Goose?
ps. the gem being showcased here is https://github.com/doctolib/safe-pg-migrations
At Doctolib, we developed safe-pg-migrations, a tool which automatically makes migrations safe. In 2018, we open-sourced this library. From an internal solution developed by our team only, it is now used on other projects, and even received contribution from external authors.
-
Release a new gem version
At Doctolib, we proudly maintain and develop the gem safe-pg-migrations, which makes migrations safer. Once in a while, after each relevant updates, we release a new version.
strong_migrations
-
Careful with That Lock, Eugene
In the Rails world, the gem strong_migrations can be used to detect these: https://github.com/ankane/strong_migrations
The docs include a handy articulation of fixes.
-
Must-have gems for mature Rails
gem "strong_migrations" - https://github.com/ankane/strong_migrations | Helps devs write non-blocking migrations, a must-have.
-
Migration Best Practice
Frameworks will have a preferred solution. We use Rails with the strong_migrations gem which is great: https://github.com/ankane/strong_migrations
-
How does Rails handle out of order migrations (when working on different local branches)
There’s no real way to test, but you can use gems like https://github.com/ankane/strong_migrations and not allow to merge branches unless they are up-to-date with main.
-
[AskJS] Is there any alternative to the strong migrations gem?
The strong migrations gem in Rails alerts when you're trying to make a migration that may be dangerous. Does anyone know an alternative for Javascript? Or maybe for raw SQL.
- Adding first and last name to existing app running on Heroku
- Enforcing Zero Downtime Django Migrations
-
When Postgres blocks: tips for dealing with locks
Half of the problems in this article are migration related.
I am extremely grateful that some people have created awesome libraries like strong migrations https://github.com/ankane/strong_migrations. Even if you are not using rails, bookmark its readme, it is an awesome cheat-sheet when writing a migration.
- Best practices as code using RuboCop
-
Why I Enjoy PostgreSQL – Infrastructure Engineer's Perspective
I would suggest taking a look at strong migrations[1]. It's a rails project, but the readme does a great job explaining what it checks for and what safe alternative to use instead. I still link to their explanations in PRs for non-rails projects.
[1]: https://github.com/ankane/strong_migrations#checks
What are some alternatives?
migration_signature - Generate signatures for Rails migration files when they are run and check them in CI.
phony_rails - This Gem adds useful methods to your Rails app to validate, display and save phone numbers. It uses the super awesome Phony gem (https://github.com/floere/phony).
pg-osc - Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL
money-rails - Integration of RubyMoney - Money with Rails
online_migrations - Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).
lockbox - Modern encryption for Ruby and Rails
ghost_adapter - Run ActiveRecord migrations through gh-ost
data-migrate - Migrate and update data alongside your database structure.
Large Hadron Migrator - Online MySQL schema migrations
Pagy - 🏆 The Best Pagination Ruby Gem 🥇
flipper - 🐬 Beautiful, performant feature flags for Ruby.