rgreenjr

-- 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%' 

buchanansc

/**
 * Custom.css
 * WebKit Inspector styles for Google Chrome
 *
 * by Scott Buchanan <[email protected]>
 * http://wafflesnatcha.github.com
 *
 * Fugue Icons by Yusuke Kamiyamane
 * http://p.yusukekamiyamane.com
 */

johnpolacek

<script language="javascript">
    // set viewport to zoom to 1200px wide on viewports > 640px wide
    var viewPortTag = document.createElement('meta');
    viewPortTag.id = 'viewport';
    viewPortTag.name = 'viewport';
    if (screen.width > 640) {
        viewPortTag.content = 'width=1200';
    } else {
        viewPortTag.content = 'width=device-width';
    }

roxlu

#include <Blur.h>

#define ASSERT_BLUR_SETUP() {                   \
    if(!is_setup) {                             \
      printf("ERROR: not setup.\n");            \
      return;                                   \
    }                                           \
  }          
                                   
Blur::Blur() 

msort.py

def scan_forward( fp ):
  for line in fp:
		if line==[]:
			return True
	return False

def rowcmp(a,b):
	if a==[]:
		return 1
	if b==[]:

bmander

/* I, Brandon Martin-Anderson, release this into the public domain or whatever. */


BufferedReader reader;
double ll, bb, rr, tt;

float A = 1000.0;

GlobalMercator proj = new GlobalMercator();

dergachev

OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

ngryman

intellij javascript live templates

Just a dump of handy live templates I use with IntelliJ. They should also work with WebStorm.

How to

• Go to settings.
• Search for live templates.
• Under the javascript section you should be able to manage your templates.

a2ndrade

# download
wget http://downloads.datomic.com/0.8.3848/datomic-pro-0.8.3848.zip
unzip datomic-pro-X.X.zip & cd datomic-pro-X.X

# install as a maven artifact
./bin/maven-install

# configure transactor.properties
cp config/samples/sql-transactor-template.properties transactor.properties
# protocol=sql

miguelbermudez

#!/bin/bash

# log into your server 
ssh root@[server ipaddress]

# change root password 
passwd

# update all packages and operating system
apt-get update && apt-get --yes upgrade