lol_dba
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.
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...
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...
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...
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...
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 {...
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
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