sahidursuman

######################
#
#  Monkey patch to ActiveRecord to prevent 'implicit' checkouts. Currently tested with Rails 4.0.8, prob
#  should work fine in Rails 4.1 too. 
#
#  If you create a thread yourself, if it uses ActiveRecord objects without
#  explicitly checking out a connection, one will still be checked out implicitly.
#  If it is never checked back in with `ActiveRecord::Base.clear_active_connections!`,
#  then it will be leaked. 
#

sahidursuman

# encoding: utf-8

# Patch for auto_link method to chop text up into lines first,
# speeding up its run time considerably and making it resilient to bad or overly gigantic input

if defined?(ActionView::Helpers::TextHelper) && ActionView::Helpers::TextHelper.instance_methods.include?(:auto_link)
  module ActionView
    module Helpers
      module TextHelper
        unless defined?(slow_auto_link) # we don't want to method chain it twice...

sahidursuman

Background

I believe Ubuntu 16.04 comes with PostgreSQL 9.5. Thats good for a start, but it is a matter of time before you have the need of a PostgreSQL 9.6 cluster. For me it was to import a PG backup from Heroku.

The procedure couldn't have been any easier and is described below. If you are interested in upgrading your old cluster to 9.6 afterwards, you may be interested in this.

Instructions

sahidursuman

Capfile
config/deploy.rb
config/database.yml
log/*.log
**/*.spec.log
db/*.sqlite3
db/schema.rb
tmp/cache/*
tmp/pids/*
tmp/sessions/*

sahidursuman

sudo -i
cd
apt-get install build-essential checkinstall && apt-get build-dep imagemagick -y
wget http://www.imagemagick.org/download/ImageMagick-6.8.7-7.tar.gz
tar xzvf ImageMagick-6.8.9-1.tar.gz
cd ImageMagick-6.8.9-1/
./configure --prefix=/opt/imagemagick-6.8 && make
checkinstall

sahidursuman

for month_table in action*.txt; do                                                                                          
  echo "$(date) splitting $month_table..."                                                                                  
  split -l 1000000 $month_table curmonth_                                                                                   
  for segment in curmonth_*; do                                                                                             
    echo "On segment $segment"                                                                                              
    time mysql -hlocalhost action_credit_silo <<-SQL                                                                        
      SET FOREIGN_KEY_CHECKS = 0;                                                                                           
      SET UNIQUE_CHECKS = 0;                                                                                                
      SET SESSION tx_iso

sahidursuman

class Item < ActiveRecord::Base
  attr_accessible :description, :owner_id, :title, :image_url, :weekly, :daily,
                  :amazon_url, :image, :brand, :component
  belongs_to :owner, class_name: 'User'

  COMPONENTS = [:lens, :body, :accessory].each do |component|
    scope component.to_sym, where(component: component)
  end
  BRANDS     = [:canon, :nikon, :sony, :olympus, :other].each do |brand|
    scope brand.to_sym, where(brand: brand)

sahidursuman

var ITERATIONS = 100000,
    av = navigator.appVersion;

console.time('indexOf')
for (var i = 0; i < ITERATIONS; i++) {
  navigator.appVersion.indexOf("Mobile") > -1
}
console.timeEnd('indexOf')

console.time('regex')

sahidursuman

def maybe_login_from_token
  Rails.logger.info "maybe_login_from_token: '#{ params[:token] }'"
  return if (token = params[:token]).blank?

  if (user = User.find_by_token(token))
    Rails.logger.info "One time login token used for user #{ user.id }"
    sign_in(user)
  else
    Rails.logger.info "No user found from token: '#{ token }'"
  end

sahidursuman

require 'httparty'

class PixelPeeper
  include HTTParty
  base_uri 'www.pixel-peeper.com'

  def api_key
    ENV['PIXELPEEPER_API_KEY']
  end