actual_db_schema
Lol DBA
actual_db_schema | Lol DBA | |
---|---|---|
2 | 2 | |
235 | 1,572 | |
19.6% | - | |
7.1 | 0.0 | |
15 days ago | 2 months 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.
actual_db_schema
-
How does Rails handle out of order migrations (when working on different local branches)
https://github.com/widefix/actual_db_schema gem automatically runs migration/rollback on your current branch. You need to write reversible migrations always though.
-
Keep Rails DB schema consistent while switching between branches with no additional actions
Switching between branches you might end up with inconsistent DB in the current branch due to migrations run inside other branches. I've just released a gem that solves that issue for good: https://github.com/widefix/actual_db_schema
Lol DBA
-
Must-have gems for mature Rails
gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
-
Rails application boilerplate for fast MVP development
lol_dba for indexing
What are some alternatives?
strong_migrations - Catch unsafe migrations in development
PgHero - A performance dashboard for Postgres
zero_downtime_migrations - Zero downtime migrations with ActiveRecord 3+ and PostgreSQL
Scenic - Versioned database views for 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).
Rails DB - Rails Database Viewer and SQL Query Runner
SchemaPlus - SchemaPlus provides a collection of enhancements and extensions to ActiveRecord
Foreigner - Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb
Large Hadron Migrator - Online MySQL schema migrations
Upsert - Upsert on MySQL, PostgreSQL, and SQLite3. Transparently creates functions (UDF) for MySQL and PostgreSQL; on SQLite3, uses INSERT OR IGNORE.
Shiba - Catch bad SQL queries before they cause problems in production
Database Cleaner - Strategies for cleaning databases in Ruby. Can be used to ensure a clean state for testing.