Juan Antonio Plaza jplaza

jamesmacaulay / Clojure.sublime-settings

Last active January 18, 2021 19:01

Clojure stuff for Sublime Text 2. Files live in ~/Application Support/Sublime Text 2/Packages/User

rgreenjr / postgres_queries_and_commands.sql

Last active April 30, 2025 08:16

Useful PostgreSQL Queries and Commands

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

burin / each_with_index.coffee

Created June 27, 2011 14:33

each_with_index handlebars helper, adds an {{index}} prop accessible from within the block

	Handlebars.registerHelper 'each_with_index', (array, fn) ->
	buffer = ''
	for i in array
	item = i
	item.index = _i
	buffer += fn(item)
	buffer