Hanjie Ji jhjwind

jhjwind / gist:c25be1993fc2e17c48c5e51aa341b6be

Created March 21, 2017 03:52 — forked from voidfiles/gist:2860137

Get Pocket Bookmarklet

	// The Bookmarklet
	javascript: (function() %
	7BISRIL_H = '8e7a';
	PKT_D = 'getpocket.com';
	ISRIL_SCRIPT = document.createElement('SCRIPT');
	ISRIL_SCRIPT.type = 'text/javascript';
	ISRIL_SCRIPT.src = 'http://' + PKT_D + '/b/r.js';
	document.getElementsByTagName('head') % 5B0 % 5D.appendChild(ISRIL_SCRIPT) % 7D)();

jhjwind / gist:543d3a7c19369c257054d3216a9572e2

Created March 21, 2017 03:52 — forked from voidfiles/gist:2860137

Get Pocket Bookmarklet

	// The Bookmarklet
	javascript: (function() %
	7BISRIL_H = '8e7a';
	PKT_D = 'getpocket.com';
	ISRIL_SCRIPT = document.createElement('SCRIPT');
	ISRIL_SCRIPT.type = 'text/javascript';
	ISRIL_SCRIPT.src = 'http://' + PKT_D + '/b/r.js';
	document.getElementsByTagName('head') % 5B0 % 5D.appendChild(ISRIL_SCRIPT) % 7D)();

jhjwind / postgres_queries_and_commands.sql

Created September 26, 2017 21:54 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'