venning

// NOTE requires lodash v3.4.0+ (for _.sum) and Node 4.0+ (for arrow function)

var _ = require('lodash');

function σ (array) {
    var avg = _.sum(array) / array.length;
    return Math.sqrt(_.sum(_.map(array, (i) => Math.pow((i - avg), 2))) / array.length);
};

henrysher

Slides for Re:Invent conference

• Re:Invent 2016
• Re:Invent 2015
• Re:Invent 2014
• Re:Invent 2013
• Re:Invent 2012

patmanv

----------------------------------------------------------------------------------------------------
-- <<< system tables >>>
----------------------------------------------------------------------------------------------------
 
-- get RED meta data tables
SELECT  *
FROM    sys.objects
WHERE   (name LIKE 'ws_%' or name LIKE 'dss_%ac%' )
        AND type = 'U'
ORDER BY 1

rgreenjr

-- 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%' 

zhengjia

=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')
    click_button('Save')
    click('Link Text') # Click either a link or a button
    click('Button Value')