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

SlaunchaMan

CGColorSpaceRef colorSpace = CGColorSpaceCreateDeviceRGB();

size_t numberOfComponents = CGColorSpaceGetNumberOfComponents(colorSpace) + 1; // Add 1 for the alpha channel
size_t bitsPerComponent = 8;
size_t bytesPerPixel = (bitsPerComponent * numberOfComponents) / 8;
size_t bytesPerRow = bytesPerPixel * width;

uint8_t *rawData = (uint8_t*)calloc(width * height * numberOfComponents, sizeof(uint8_t));

CGContextRef context = CGBitmapContextCreate(rawData,

jboner

Latency Comparison Numbers (~2012)
----------------------------------
L1 cache reference                           0.5 ns
Branch mispredict                            5   ns
L2 cache reference                           7   ns                      14x L1 cache
Mutex lock/unlock                           25   ns
Main memory reference                      100   ns                      20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy             3,000   ns        3 us
Send 1K bytes over 1 Gbps network       10,000   ns       10 us
Read 4K randomly from SSD*             150,000   ns      150 us          ~1GB/sec SSD

mabroor

web: gunicorn -w4 -b0.0.0.0:$PORT app:app

rennerocha

== Instructions ==

https://docs.djangoproject.com/en/1.4/howto/custom-management-commands/

Commands:
- python manage.py sqlproject
- python manage.py sqlallproject

chriseppstein

if environment == :production
  on_stylesheet_saved do |file|
    # pretty logging output when making a gzipp'ed file
    gz_file = Pathname.new("#{file}.gz").relative_path_from(Pathname.new(project_path))
    Compass::Logger.new.record(:create, gz_file)
    # This generates a file of the same name but ending in .gz
    `gzip -f #{file}`
  end
end

jcroft

#content-wrapper
  +container

  #about

    // Default (smallest screens)
    +column(100%)
    background-color: #ccc

    // Respond to other screen widths

lukeredpath

#define MAYBE_NULL(value) (value == [NSNull null] ? nil : value)

self.myProperty = MAYBE_NULL([dict objectForKey:@"might_be_null"]);

rolo

#!/bin/bash
#
# Install Postgres 9.1, PostGIS and create PostGIS template on a clean Ubuntu 11.10 Oneiric Ocelot box
# http://wildfish.com

# add the ubuntu gis ppa
sudo apt-get -y install python-software-properties
sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable 
sudo apt-get update 

justinvoss

#!/usr/bin/env python

import sys
import subprocess


def runserver_bonjour(service_name, service_type, port):

  django_process = subprocess.Popen(
    ['python', 'manage.py', 'runserver', '0.0.0.0:%s' % port],