lol_dba icon indicating copy to clipboard operation
lol_dba copied to clipboard

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.

Results 20 lol_dba issues
Sort by recently updated
recently updated
newest added

Hi, Say there's a UniqueEvent model with a `belongs_to :cause` association. `unique_events` table already has a multi-column uniqueness index like `[:cause_id, :some_type, :uuid], unique: true, name: "very_unique_index"`. `lol_dba` will still...

waiting feedback

Bumps [rails-html-sanitizer](https://github.com/rails/rails-html-sanitizer) from 1.4.2 to 1.4.3. Release notes Sourced from rails-html-sanitizer's releases. 1.4.3 / 2022-06-09 Address a possible XSS vulnerability with certain configurations of Rails::Html::Sanitizer. Prevent the combination of select...

dependencies

Can already be installed on Rails 7 release candidate versions but not on the actual released `v7.0.0`

Hi! I am using v2.1.8 and polymorphic indexes are still suggested despite them already being present in different order, see https://github.com/plentz/lol_dba/pull/107 Furthermore, I believe the suggestion should be in the...

waiting feedback

Hello Is it possible to get a changelog going forward? Cheers!

Tried this with an app that uses acts-as-taggable-on. A reccomended index looks like this but this fails with Rails 4. Any idea how to solve or should the index not...

bug
waiting feedback

I am getting this recommendation after installing the door keeper gem. ``` 1) DB Indexes sets the proper db indexes Failure/Error: expect(`rake db:find_indexes`).to match(/Yey, no missing indexes found!/), lambda {...

waiting feedback

Intercept Arel querys to allow query specific indexes. Maybe something like this: ```ruby LolDba.suggest_index do Customer.where(name: 'Diego') end ``` And we suggest an index on `name` related: https://github.com/rails/rails/tree/master/activerecord/lib/arel

enhancement

This is being fixed @ `has_many_fix` branch. This is the failing case that should be fixed https://github.com/plentz/lol_dba/commit/bf9c4eb7124d3f998d6cf65ffb3165a2068b4335#diff-d90d1bc62234f746df962016d75e56c8R58

bug