ghost_adapter
wt_activerecord_index_spy
| ghost_adapter | wt_activerecord_index_spy | |
|---|---|---|
| 2 | 1 | |
| 18 | 77 | |
| - | - | |
| 1.5 | 0.0 | |
| 8 days ago | over 2 years ago | |
| Ruby | Ruby | |
| GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
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.
ghost_adapter
-
Changing Tires at 100mph: A Guide to Zero Downtime Migrations
At least for Rails there are several gems available (ie https://github.com/WeTransfer/ghost_adapter or https://github.com/departurerb/departure) that seamlessly hook into the existing migration system and will run all eligible migrations through gh-ost or pt-osc as needed. You're right that it's not free but it isn't all that far off either.
That said, online schema migrations are a specialized tool designed for very big tables that take hours to run an ALTER TABLE on. If all your tables are small enough that alterations take less than a second or so, don't bother and just block the table for a bit. It's fine.
-
Database... or Goose?
https://github.com/WeTransfer/ghost_adapter integrates gh-ost with activerecord and the departure gem does the same but for pt-osc.
wt_activerecord_index_spy
-
Ruby’s Hidden Gems: Bullet
As an extra tip, if you want to be even more protected against performance problems related to the database, take a look at the wt-activerecord-index-spy gem, which helps to detect queries that are not using proper indexes.
What are some alternatives?
strong_migrations - Catch unsafe migrations in development
divisionly-api - split expenses with friends
safe-pg-migrations - Make your PostgreSQL migrations safe
uniform_notifier - uniform notifier for rails logger, customized logger, javascript alert, javascript console, growl and xmpp
Large Hadron Migrator - Online MySQL schema migrations
Ruby Tests Profiling Toolbox - Ruby Tests Profiling Toolbox
Ruby on Rails - Ruby on Rails
bullet-test - A project to test the bullet gem
database-lab-engine - DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated.
bullet - help to kill N+1 queries and unused eager loading
reshape - An easy-to-use, zero-downtime schema migration tool for Postgres
Feedka - Get authentic, kindful, and constructive feedback from your friends, family, and co-workers.