Category

Active Record Index Assistants

Utilities to point you at potentially missing database indices

0.93
No release in over 3 years
Low commit activity in last 3 years
Adds helpers to migrations and dumps foreign keys to schema.rb
2016
2017
2018
2019
2020
2021
0.69
No release in over a year
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.
2016
2017
2018
2019
2020
2021
0.44
No commit activity in last 3 years
There's a lot of open issues
A rake task to track down missing database indexes. does not assume that all foreign keys end with the convention of _id.
0.42
No release in over 3 years
Low commit activity in last 3 years
SchemaPlus is a gem that simply pulls in a collection of other gems from the SchemaPlus family of ActiveRecord extensions
2016
2017
2018
2019
2020
2021
0.28
No commit activity in last 3 years
No release in over 3 years
Adds a generator for creating a foreign key migration based on your current model associations
2016
2017
2018
2019
2020
2021
0.03
No commit activity in last 3 years
No release in over 3 years
Adds support in ActiveRecord for foreign_keys, complex indexes and other database-related stuff. Easily create foreign_keys, complex indexes and views.
2016
2017
2018
2019
2020
2021
0.03
No commit activity in last 3 years
No release in over 3 years
Automatic Foreign Key automatically generates foreign-key constraints when creating tables or adding columns. It uses SQL-92 syntax and as such should be compatible with most databases that support foreign-key constraints.
2016
2017
2018
2019
2020
2021