| # 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() |
Do your part to resist Government surveillance and take back your privacy:
| -- 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 |
| \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} |
| #!/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 |
| 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 |
| -- 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 | |
| -- |
| #!/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 | |
| # |
| [diff "iworkpages"] | |
| textconv = xsltproc $GIT_DIR/Pages.xsl |
