Libraries & frameworks
database_consistency
djezzzl/database_consistency
DatabaseConsistency is a Ruby gem for Rails/ActiveRecord that detects mismatches and inefficiencies between the database schema and model validations, indexes, and foreign keys.
Topics
Related projects
active_record_doctor1.9kActive Record Doctor is a Rails gem that audits database health. It detects missing indexes, foreign keys and constraints, unused tables and model mismatches, then helps generate corrective migrations.
database_validations571DatabaseValidations is a Ruby gem that backs ActiveRecord uniqueness and association validations with real database constraints, improving consistency and cutting redundant queries.
scenic3.6kScenic adds versioned database-view support to Rails migrations, letting you define SQL views in files and generate reversible, schema-tracked migrations.
counter_culture2.1kCounter_culture is a Rails gem that supercharges counter caches. It keeps denormalized counts accurate across nested associations, supports dynamic columns and running totals, and can repair drifted counters.
lol_dba1.6klol_dba is a Ruby gem for Rails applications. Its rake tasks scan models and associations, report columns that likely need indexes, and generate SQL migration scripts for the missing indexes.
activerecord-sqlserver-adapter980This adapter connects Rails ActiveRecord to Microsoft SQL Server, supporting native types, migrations, stored procedures, bulk upserts, and query plan inspection.