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

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

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

henrysher

Slides for Re:Invent conference

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

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);
};

tonysneed

- Open Automator 
- File -> New -> Service 
- Change "Service Receives" to "files or folders" in "Finder" 
- Add a "Run Shell Script" action 
- Change "Pass input" to "as arguments" 
- Paste the following in the shell script box: open -n -b "com.microsoft.VSCode" --args "$*" 
- Save it as something like "Open in Visual Studio Code"

erikbern

import contextlib
import OpenSSL.crypto
import os
import requests
import ssl
import tempfile

@contextlib.contextmanager
def pfx_to_pem(pfx_path, pfx_password):
    ''' Decrypts the .pfx file to be used with requests. '''

criccomini

; Configuration for Airflow webserver and scheduler in Supervisor

[program:airflow]
command=/bin/airflow webserver
stopsignal=QUIT
stopasgroup=true
user=airflow
stdout_logfile=/var/log/airflow/airflow-stdout.log
stderr_logfile=/var/log/airflow/airflow-stderr.log
environment=HOME="/home/airflow",AIRFLOW_HOME="/etc/airflow",TMPDIR="/storage/airflow_tmp"

dwilkie

Build docker image

$ cd /path/to/Dockerfile
$ sudo docker build .

View running processes

nvquanghuy

create table books (tags varchar(1000));

insert into books values
	('A, B, C, D'),
	('D, E'),
	('F'),
	('G, G, H')
;

select