UPDATE: added support for remove_index :users, :name=>:index_name

Mysql::Error: Duplicate key name ‘index_xxx’: CREATE INDEX `index_xxx` ON `users` (`xxx`) ?
Mysql::Error: Can’t DROP ‘index_xxx’; check that column/key exists: DROP INDEX `index_xxx` ON users ?
nevermore!

class TestAddRemoveIndex < ActiveRecord::Migration
  def self.up
    add_index :users, [:a, :b], :quiet=>true
    add_index :users, [:a, :b], :quiet=>true
  end

  def self.down
    remove_index :users, [:a, :b], :quiet=>true
    remove_index :users, [:a, :b], :quiet=>true
  end
end

These patches allow you to add indices in a migration that will only be created if they do not already exist, or to remove indices only if they already exist through :quiet=>true.

module ActiveRecord::ConnectionAdapters::SchemaStatements

  def add_index_with_quiet(table_name, column_names, options = {})
    quiet = options.delete(:quiet)
    add_index_without_quiet table_name, column_names, options
  rescue
    raise unless quiet and $!.message =~ /^Mysql::Error: Duplicate key name/i
    puts "Failed to create index #{table_name} #{column_names.inspect} #{options.inspect}"
  end
  alias_method_chain :add_index, :quiet

  def remove_index_with_quiet(table_name, *args)
    options = args.extract_options!
    quiet = options.delete(:quiet)
    if args.empty?
      remove_index_without_quiet table_name, options
    else
      remove_index_without_quiet table_name, *args
    end
  rescue
  rescue
    raise unless quiet and $!.message =~ /^Mysql::Error: Can't DROP/i
    puts "Failed to drop index #{table_name} #{(args[1]||options[:name]).inspect}"
  end
  alias_method_chain :remove_index, :quiet

end

Charting for Active Record was never easier, choose type, model, attribute -> BOOM you`ve been graphed 😀

Checkout DB Graph Rails Plugin/Gem

Since there are so few tips and tricks collection, I wanted to share what I use most often.

These are my shortcuts, i changed some of them, so try searching for the text in keybord shortcuts view.

• Go to line Strl+L
• Open Resource (any file) Ctrl+R
• Open type Ctrl+O
• Delete line Ctrl+D
• Move line up/down Ctrl+Alt+Up/Down
• Copy line up/down Ctrl+Shift+Up/Down
• Insert next matching word, this is no intelligent autocomplete, but just takes the next work that matches the currently started work Ctrl+K
• Close editor Ctrl+W
• Show file in files view Ctrl+Shift+2