nicerobot

#!/usr/bin/env bash
# This tries to make sure that tmuxinator is always installed into local GEM_PATHS
gems=$(cd $(dirname $(readlink ${0} || echo .)) >/dev/null 2>&1; pwd -P)
mkdir -p ${gems}
cd ${gems}
gem install --user-install tmuxinator
[[ -L .latest ]] && rm ./.latest
install_dir=$(gem env | awk '/USER INSTALLATION DIRECTORY/ {print $NF}')
ln -s ${install_dir#${gems}/} .latest
[[ -L bin ]] || ln -s .latest/bin

nicerobot

SELECT 
    blocked_locks.pid AS blocked_pid,
    blocked_activity.usename AS blocked_user,
    blocking_locks.pid AS blocking_pid,
    blocking_activity.usename AS blocking_user,
    blocked_activity.query AS blocked_statement,
    blocking_activity.query AS current_statement_in_blocking_process,
    blocked_activity.application_name AS blocked_application,
    blocking_activity.application_name AS blocking_application
FROM pg_catalog.pg_locks blocked_locks

nicerobot

DELETE FROM <table> a USING (
SELECT MIN(ctid) as ctid, var1, var2
  FROM <same_table> b
  GROUP BY 2,3 HAVING COUNT(*) > 1
) b
WHERE a.var1 = b.var1
and a.var2 = b.var2
AND a.ctid <> b.ctid

nicerobot

jsfiddle

nicerobot

jsfiddle

nicerobot

jsfiddle

nicerobot

#!/bin/sh

alias dm='docker-machine'
alias dmx='docker-machine ssh'
alias dk='docker'
alias dki='docker images'
alias dks='docker service'
alias dkrm='docker rm'
alias dkl='docker logs'
alias dklf='docker logs -f'

nicerobot

openssl s_client -connect ${1:-google.com}:${2:-443} </dev/null | openssl x509 -in /dev/stdin -noout -text

nicerobot

#!/usr/bin/env bash
# Useful for, for example, versioning docker images built from subdirectories in a mono-repo.
cd ${1:-.} || exit
git ls-tree -r --name-only $(git rev-parse --symbolic-full-name --abbrev-ref HEAD) \
| while read f; do [[ -d "${f}" ]] || [[ -f "${f}" ]] && echo ${f}; done \
| sort -fd \
| tr '\n' '\0' \
| xargs -0 openssl sha1 \
| openssl sha1

nicerobot

#!/usr/bin/env bash
sourced() { [ 'bash' = "${0:-i}" ] || [ "${BASH_SOURCE[0]}" != "${0:-i}" ]; }
sourced && {
	SELF=$(
		[ "${ZSH_VERSION}" ]     && echo "${(%):-%N}" \
		|| [ "${BASH_VERSION}" ] && echo "${BASH_SOURCE[0]}" \
		||                          echo "${0}"
	)

	export SCRIPT_HOME=$(cd $(dirname ${SELF})/..; pwd)