amitu

WITH query_stat AS (
  SELECT
      relname, 100 * idx_scan / (seq_scan + idx_scan) percent_of_times_index_used, 
      n_live_tup rows_in_table, idx_scan, seq_scan
  FROM
     pg_stat_user_tables
  WHERE
     seq_scan + idx_scan > 0
  ORDER BY
  	 seq_scan DESC

amitu

with table_stats as (
select psut.relname,
  psut.n_live_tup,
  1.0 * psut.idx_scan / greatest(1, psut.seq_scan + psut.idx_scan) as index_use_ratio
from pg_stat_user_tables psut
order by psut.n_live_tup desc
),
table_io as (
select psiut.relname,
  sum(psiut.heap_blks_read) as table_page_read,

amitu

import luigi


class SimpleTask(luigi.Task):
    name = luigi.Parameter()

    def output(self):
        return luigi.LocalTarget(self.name)

    def run(self):

amitu

\pset linestyle unicode
\pset border 2
\set PROMPT1 '%[%033[33;1m%]%x%[%033[0m%]%[%033[1m%]%/%[%033[0m%]%R%# '
\pset pager off
\timing
\pset format wrapped

amitu

build:
	sassc  -I foundation/scss scss/main.scss > css/main.css
	osascript reload-chrome.applescript

watch:
	make build
	fswatch -e main.css scss | xargs -n1 make build

amitu

There is plenty we can do with strings, we have already seen .upper() in previous chapter.

>>> message = u"hello world"
>>> message.upper()
u'HELLO WORLD'

amitu

#!/bin/sh

set -e

pandoc -s -r html $1 -o /tmp/e.text

if [[ -t 1 ]]; then
        less /tmp/e.text
else
        cat /tmp/e.text

amitu

// $ npm install q
// $ node --harmony tyield.js

var Q = require("q");

function timeoutPromose(delay) {
	var d = Q.defer();
	setTimeout(function(){
		d.resolve("done");
	}, delay);

amitu

diff --git a/talk/app/webrtc/peerconnection.cc b/talk/app/webrtc/peerconnection.cc
index 5226041..4e5daea 100644
--- a/talk/app/webrtc/peerconnection.cc
+++ b/talk/app/webrtc/peerconnection.cc
@@ -41,6 +41,8 @@
 #include "webrtc/base/stringencode.h"
 #include "webrtc/system_wrappers/interface/field_trial.h"
 
+// extern void (*go_Println)(const char*);
+

amitu

var webrtc = require('..');

var RTCPeerConnection     = webrtc.RTCPeerConnection;
var RTCSessionDescription = webrtc.RTCSessionDescription;
var RTCIceCandidate       = webrtc.RTCIceCandidate;

var pc1 = new RTCPeerConnection();
var pc2 = new RTCPeerConnection();

var d = "";