Rails 4: Patch JSON encoding to support emojis

Add this to file under `config/initializers/`

module ActiveSupport::JSON::Encoding
  class << self
    def escape(string)
      if string.ascii_only?
        string = string.encode(::Encoding::UTF_8, :undef => :replace).force_encoding(::Encoding::BINARY)
      end
      json = string.gsub(escape_regex) { |s| ESCAPED_CHARS[s] }
      json = %("#{json}")
      json.force_encoding(::Encoding::UTF_8) if json.ascii_only?
      json
    end
  end
end

List all tasks from your custom rake file

namespace :my_application do |ns|
  desc "Lists all tasks available"
  task :tasklist do
    ns.tasks.each do |t|
      name   = t.name_with_args
      spaces = name.length >= 25 ? "\t" : "\t\t" # hack for spacing
      puts name + spaces + t.comment.to_s
    end
  end
end

Postgres - SQL to get rows count for all tables

SELECT relname, n_tup_ins - n_tup_del as rowcount FROM pg_stat_all_tables where (n_tup_ins - n_tup_del) > 0 AND relname NOT LIKE 'pg_%';