mbarkhau

Sublime Text 3 - Useful Shortcuts (Windows)

R Markdown

Use a productive notebook interface to weave together narrative text and code to produce elegantly formatted output. Use multiple languages including R, Python, and SQL.

Pweave

Pweave is a scientific report generator and a literate programming tool for Python. It can capture the results and plots from data analysis and works well with numpy, scipy and matplotlib.
podoc

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

	<html>
	<body>

	<!-- ----------------------------------------------- -->
	<!-- inline script block with commented code inside: -->
	<!-- ----------------------------------------------- -->

	<script id="myjscode">
	/*
	(function(h,v){function q(b){if(""===m)return b;

	# Add the following 'help' target to your Makefile
	# And add help text after each target name starting with '\#\#'

	help: ## Show this help.
	@fgrep -h "##" $(MAKEFILE_LIST) \| fgrep -v fgrep \| sed -e 's/\\$$//' \| sed -e 's/##//'

	# Everything below is an example

	target00: ## This message will show up when typing 'make help'
	@echo does nothing

	import sys

	def getarg(argname, args=sys.argv[1:]):
	long_arg = '--' + argname
	short_arg = '-' + argname[:1]

	for idx, arg in enumerate(args):
	if arg.startswith(long_arg):
	if arg == long_arg:
	# check for parameter

	#!/usr/bin/env bash

	set -euo pipefail

	for BRANCH in $(git branch \| grep -E -v "^(\* \| (develop\|master\|main)$)"); do
	if [[ -z $(git --no-pager log develop..$BRANCH --author=$(git config user.email)) ]]; then
	git branch -D $BRANCH
	fi
	done

	-- Table information like sortkeys, unsorted percentage
	-- see http://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html
	SELECT * FROM svv_table_info;

	-- Table sizes in GB
	SELECT t.name, COUNT(tbl) / 1000.0 AS gb
	FROM (
	SELECT DISTINCT datname, id, name
	FROM stv_tbl_perm
	JOIN pg_database ON pg_database.oid = db_id