Stefan Urbanek Stiivi

Sublime Text 2 – Useful Shortcuts (Mac OS X)

Do your part to resist Government surveillance and take back your privacy:

Browser Privacy: HTTPS Everywhere, AdBlock Plus + EasyList, Disconnect, NoScript (FireFox), NotScript (Chrome)
VPNs: Private Internet Access (US), BTGuard (Canada), ItsHidden (Africa), Ipredator (Sweden), Faceless.me (Cyprus / Netherlands)
Internet Anonymization: Tor, Tor Browser Bundle, I2P
Disk Encryption: TrueCrypt (Windows / OSX / Linux), File Vault

	#!/usr/bin/env sh

	##
	# This is script with usefull tips taken from:
	# https://github.com/mathiasbynens/dotfiles/blob/master/.osx
	#
	# install it:
	# curl -sL https://raw.github.com/gist/2108403/hack.sh \| sh
	#

	-- PostgreSQL 9.2 beta (for the new JSON datatype)
	-- You can actually use an earlier version and a TEXT type too
	-- PL/V8 http://code.google.com/p/plv8js/wiki/PLV8

	-- Inspired by
	-- http://people.planetpostgresql.org/andrew/index.php?/archives/249-Using-PLV8-to-index-JSON.html
	-- http://ssql-pgaustin.herokuapp.com/#1

	-- JSON Types need to be mapped into corresponding PG types
	--

	Latency Comparison Numbers (~2012)
	----------------------------------
	L1 cache reference 0.5 ns
	Branch mispredict 5 ns
	L2 cache reference 7 ns 14x L1 cache
	Mutex lock/unlock 25 ns
	Main memory reference 100 ns 20x L2 cache, 200x L1 cache
	Compress 1K bytes with Zippy 3,000 ns 3 us
	Send 1K bytes over 1 Gbps network 10,000 ns 10 us
	Read 4K randomly from SSD* 150,000 ns 150 us ~1GB/sec SSD

	#!/bin/sh

	###
	# SOME COMMANDS WILL NOT WORK ON macOS (Sierra or newer)
	# For Sierra or newer, see https://github.com/mathiasbynens/dotfiles/blob/master/.macos
	###

	# Alot of these configs have been taken from the various places
	# on the web, most from here
	# https://github.com/mathiasbynens/dotfiles/blob/5b3c8418ed42d93af2e647dc9d122f25cc034871/.osx

	\usepackage{wasysym}
	\usepackage{moresize}
	\usepackage{multicol}
	\usepackage[Sonny]{fncychap}
	\usepackage[margin=1in, paperwidth=6.69in, paperheight=9.61in]{geometry}
	\usepackage[protrusion=true,expansion=true]{microtype}
	\usepackage{xltxtra}
	\setmainfont[Mapping=tex-text]{Minion Pro}
	\setmonofont[Mapping=tex-text,Scale=0.85]{Inconsolata}
	%\setmonofont[Mapping=tex-text,Scale=0.75]{DejaVu Sans Mono}

	-- Structure:

	-- src_customers: id, name, address
	-- dim_customers: id, name, address

	-- Find new records

	DROP TABLE IF EXISTS tmp_new;

	CREATE TABLE tmp_new AS

	# Demo:
	#
	# Aggregate population per independence type for every year
	# Sources: Population and Country Codes datasets
	#

	from bubbles import Pipeline
	from bubbles import get_logger

	logger = get_logger()

	[diff "iworkpages"]
	textconv = xsltproc $GIT_DIR/Pages.xsl