Category

Active Record Index Assistants

Utilities to point you at potentially missing database indices

0.65
A long-lived project that still receives updates
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.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.51
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.49
No commit activity in last 3 years
No release in over 3 years
SchemaPlus is a gem that simply pulls in a collection of other gems from the SchemaPlus family of ActiveRecord extensions
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.29
Low commit activity in last 3 years
No release in over a year
Adds a generator for creating a foreign key migration based on your current model associations
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
0.04
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.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
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.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019