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

jezdez

"""
module mydjangolib.bigint_patch

A fix for the rather well-known ticket #399 in the django project.

Create and link to auto-incrementing primary keys of type bigint without
having to reload the model instance after saving it to get the ID set in
the instance.

Logs:

NicolasT

'''
Demonstration of using `splice` with non-blocking IO

Lots of code is similar to 'splice.py', take a look at that module for more
documentation.
'''

import os
import os.path
import errno

santiagobasulto

Time complexity

This page documents the time-complexity (aka "Big O" or "Big Oh") of various operations in current CPython. Other Python implementations (or older or still-under development versions of CPython) may have slightly different performance characteristics. However, it is generally safe to assume that they are not slower by more than a factor of O(log n).

Generally, 'n' is the number of elements currently in the container. 'k' is either the value of a parameter or the number of elements in the parameter.

list

The Average Case assumes parameters generated uniformly at random.

lbolla

import sys
import tornado.ioloop
import psycopg2
import psycopg2.extensions

io_loop = tornado.ioloop.IOLoop.instance()
conn = psycopg2.connect('dbname=mytest user=lbolla password=secret')
conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT)

vegasje

PLEASE DO NOT USE THIS. See http://userium.com/ instead.

Usability Checklist

User Experience

• Personalized features. Currency, language, country specific deals, taxes, or delivery options are changed based on user's location.
• Registering provides value to users. For example a "Free Trial" button communicates a clear benefit, but a "Register" button doesn't. Unnecessary registration is avoided.

aras-p

// Just before switching jobs:
// Add one of these.
// Preferably into the same commit where you do a large merge.
//
// This started as a tweet with a joke of "C++ pro-tip: #define private public",
// and then it quickly escalated into more and more evil suggestions.
// I've tried to capture interesting suggestions here.
//
// Contributors: @r2d2rigo, @joeldevahl, @msinilo, @_Humus_,
// @YuriyODonnell, @rygorous, @cmuratori, @mike_acton, @grumpygiant,

OddBloke

# The MIT License (MIT)
# 
# Copyright (c) 2013  Daniel Watkins <daniel@daniel-watkins.co.uk>
# 
# Permission is hereby granted, free of charge, to any person obtaining a copy of
# this software and associated documentation files (the Software), to deal in
# the Software without restriction, including without limitation the rights to
# use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of
# the Software, and to permit persons to whom the Software is furnished to do so,
# subject to the following conditions:

ionelmc

#!/bin/bash -eEx

if ! which gpg-agent; then
    sudo apt-get install gnupg-agent
fi
if ! which pull-lp-source; then
    sudo apt-get install ubuntu-dev-tools
fi

gpg-agent || eval `gpg-agent --daemon`

ionelmc

import sys
try:
    from sqlparse import format as sqlformat
except ImportError:
    sqlformat = lambda s, reindent=None: s
from traceback import format_stack

class WithStacktrace(object):
    def __init__(self, skip=[], limit=5):
        self.skip = [__name__, 'logging']