Skip to content

Instantly share code, notes, and snippets.

View amitu's full-sized avatar
😀
Building fastn.com

Amit Upadhyay amitu

😀
Building fastn.com
View GitHub Profile
@amitu
amitu / index_usage_bad_ones.sql
Last active January 15, 2016 08:31
DB Performance - Index Usage - Bad Ones
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
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
amitu / luigi_example.py
Created October 14, 2015 13:18
Luigi Example
import luigi
class SimpleTask(luigi.Task):
name = luigi.Parameter()
def output(self):
return luigi.LocalTarget(self.name)
def run(self):
\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
amitu / Makefile
Created July 27, 2015 09:48
reload browser on sass change
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
amitu / 01-datastructures.md
Last active August 29, 2015 14:24
book stuff

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
amitu / v
Created June 26, 2015 07:26
my new browser
#!/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
amitu / tyield.js
Last active August 29, 2015 14:23
node, Q and generators
// $ 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
amitu / c.diff
Created May 25, 2015 15:37
gowrap
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*);
+
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 = "";