active_record_doctor vs Lol DBA

active_record_doctor

Identify database issues before they hit production. (by gregnavis)

Lol DBA

lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts. (by plentz)

Database Tools Rails Database Migrations SQL Ruby ruby-on-rails Gem database-migrations

Source Code

Suggest alternative

Edit details

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

active_record_doctor		Lol DBA
	Project
4	Mentions	2
1,630	Stars	1,571
-	Growth	-
6.6	Activity	0.0
29 days ago	Latest Commit	about 2 months ago
Ruby	Language	Ruby
MIT License	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

active_record_doctor

Posts with mentions or reviews of active_record_doctor. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-12-28.

Many of us can face issues working with ActiveRecord due to its inconsistency with the database schema. That's why I have built database_consistency, which can help you avoid the most common issues and improve your application's performance.
3 projects | /r/rails | 28 Dec 2022

Thank you for your contribution! How would you compare this gem to https://github.com/gregnavis/active_record_doctor?
Troubleshooting a RoR Application in Production
2 projects | /r/rails | 24 May 2022

Start with finding mixing indexes: https://github.com/gregnavis/active_record_doctor
Windmill.dev
6 projects | news.ycombinator.com | 5 May 2022

What did you build the website with? It looks really nice and I’m looking for something I could use with my project. [1]
[1] https://github.com/gregnavis/active_record_doctor
15 Resources I Learned Something From This Weekend
5 projects | dev.to | 27 Sep 2020

gregnavis / active_record_doctor

Lol DBA

Posts with mentions or reviews of Lol DBA. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2024-02-02.

Must-have gems for mature Rails
8 projects | dev.to | 2 Feb 2024

gem "lol_dba" - https://github.com/plentz/lol_dba | Inspect the state of table indexes.
Rails application boilerplate for fast MVP development
63 projects | dev.to | 6 Aug 2021

lol_dba for indexing

What are some alternatives?

When comparing active_record_doctor and Lol DBA you can also consider the following projects:

Rails DB - Rails Database Viewer and SQL Query Runner

PgHero - A performance dashboard for Postgres

ActiveRecord::DataIntegrity - Check data integrity for your ActiveRecord models

Scenic - Versioned database views for Rails

Blazer - Business intelligence made simple

prosopite - :mag: Rails N+1 queries auto-detection with zero false positives / false negatives

SchemaPlus - SchemaPlus provides a collection of enhancements and extensions to ActiveRecord

BatchLoader - :zap: Powerful tool for avoiding N+1 DB or HTTP queries

Foreigner - Adds foreign key helpers to migrations and correctly dumps foreign keys to schema.rb

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).

Large Hadron Migrator - Online MySQL schema migrations