jordelver

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

jordelver

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

jordelver

gifify() {
  if [[ -n "$1" ]]; then
    if [[ $2 == '--good' ]]; then
      ffmpeg -i $1 -r 10 -vcodec png out-static-%05d.png
      time convert -verbose +dither -layers Optimize -resize 600x600\> out-static*.png  GIF:- | gifsicle --colors 128 --delay=5 --loop --optimize=3 --multifile - > $1.gif
      rm out-static*.png
    else
      ffmpeg -i $1 -s 600x400 -pix_fmt rgb24 -r 10 -f gif - | gifsicle --optimize=3 --delay=3 > $1.gif
    fi
  else

jordelver

So you think you wanna be a web developer...

Fork this, update your copy with answers.

They don't need to be precise - pseudo-code is fine in most cases.

Some questions don't have correct answers.

jordelver

module TaxCodeStrategies
  class UnitedStates
    def call(id)
      "US-#{id}"
    end
  end

  class Brazil
    def call(id)
      "#{id}-BR"

jordelver

# Convert any YouTube video into an audio file you can listen to on the go, using:
#   http://rg3.github.com/youtube-dl/

{ ~ } > brew install ffmpeg
{ ~ } > brew install ffprobe

{ ~ } > wget https://raw.github.com/rg3/youtube-dl/2012.02.27/youtube-dl
{ ~ } > chmod u+x youtube-dl

# Pick which video format you want to download.. (use any YT video link)

jordelver

class ActiveRecord::Base
  mattr_accessor :shared_connection
  @@shared_connection = nil

  def self.connection
    @@shared_connection || ConnectionPool::Wrapper.new(:size => 1) { retrieve_connection }
  end
end
ActiveRecord::Base.shared_connection = ActiveRecord::Base.connection

jordelver

#! /usr/bin/env ruby
# usage: 
# $ das_download.rb email password [download_directory]

require 'mechanize'
# gem 'mechanize-progressbar'

email    = ARGV[0] or raise('Please provide the email address for your account')
password = ARGV[1] or raise('Please provide the password for your account')
path     = ARGV[2] || './' 

jordelver

# shitty 


   attributes[:name] = options[:name] unless options[:name].blank?
    attributes[:first_name] = options[:first_name] unless options[:first_name].blank?
    attributes[:last_name] = options[:last_name] unless options[:last_name].blank?
    attributes[:linkedin_id] = options[:linkedin_id] unless options[:linkedin_id].blank?
    attributes[:company] = options[:company] unless options[:company].blank?
    attributes[:company_id] = options[:company_id] unless options[:company_id].blank?
    attributes[:linkedin_picture_url] = options[:linkedin_picture_url] unless options[:linkedin_picture_url].blank?