Jeff Dwyer jdwyah


    
    View create.sql 
  
  
    File suppressed. Click to show.
  
  
            1
            2
            3
            4
            5
          
          
            create table events (
user_id int
date date_time
event text
)

          
    View 4.sql 
  
  
    File suppressed. Click to show.
  
  
            1
            2
            3
            4
            5
            6
            7
            8
            9
            10
          
          
            calculated as (select time_period,
  case when lag is null then 'NEW'
     when lag_size = 1 then 'ACTIVE'
     when lag_size > 1 then 'RETURN'
  end as this_month_value,
 
  case when lead_size > 1 then 'CHURN'
     else NULL
  end as next_month_churn,
 

    View 3.sql 
  
  
    File suppressed. Click to show.
  
  
            1
            2
            3
            4
            5
          
          
            lag_lead_with_diffs as (
  select who_identifier, time_period, uses_outlook, lag, lead, 
    time_period-lag lag_size, 
    lead-time_period lead_size 
  from lag_lead),

          
    View 2.sql 
  
  
    File suppressed. Click to show.
  
  
            1
            2
            3
            4
            5
          
          
            lag_lead as (
  select who_identifier, time_period,
    lag(time_period,1) over (partition by who_identifier order by who_identifier, time_period),
    lead(time_period,1) over (partition by who_identifier order by who_identifier, time_period)
  from monthly_usage),

          
    View 1.sql 
  
  
    File suppressed. Click to show.
  
  
            1
            2
            3
            4
            5
            6
          
          
            with monthly_usage as (
  select 
    who_identifier, 
    datediff(month, '1970-01-01', when_timestamp) as time_period
  from events
  where event = 'login' group by 1,2 order by 1,2),

          
    View basic.sql 
  
  
    File suppressed. Click to show.
  
  
            1
            2
          
          
            select date_trunc('month', date), count(distinct user_id) from events
where event = "login" group by 1 order by 1

          
    View gist:7c7002f217dd12f2b0bc 
  
  
    File suppressed. Click to show.
  
  
            1
          
          
            ruby -e "$(curl -fsSL https://gist.githubusercontent.com/jdwyah/a7432521ea8fa81c1557/raw/9e5b58c28c7965ff94e6aeb1c718c67be62df1f5/homebrew.rb)"

          
    View homebrew.rb 
  
  
    File suppressed. Click to show.
  
  
Working version of Homebrew for OS X 10.10

The only way to get working Homebrew on OS X 10.10 for now (10.10 beta was just released a couple of hours ago) is by using an special fork by @jacknagel available at https://github.com/jacknagel/homebrew/tree/rb2.

This version comments out:
abort "MacOS too old, see: https://github.com/mistydemeo/tigerbrew" if macos_version < "10.5" 

because strings.

      
    View Gemfile 
  
  
    File suppressed. Click to show.
  
  
            1
            2
            3
            4
            5
            6
            7
            8
            9
            10
          
          
            source 'https://rubygems.org'
 
# Bundle edge Rails instead: gem 'rails', github: 'rails/rails'
ruby '2.0.0'
gem 'rails', '4.0.7'
 
gem 'pg'
gem 'foreigner'
gem 'devise'
gem 'unicorn'

          
    View 0_reuse_code.js 
  
  
    File suppressed. Click to show.
  
  
            1
            2
          
          
            // Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console