tuxtitlan

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

tuxtitlan

import base64

from django.core.files.base import ContentFile
from rest_framework import serializers


class Base64ImageField(serializers.ImageField):
    def from_native(self, data):
        if isinstance(data, basestring) and data.startswith('data:image'):
            # base64 encoded image - decode

tuxtitlan

import _ from 'lodash'

var httpStatusCodeFnMap = {
  200: success,
  201: success,
  300: redirection,
  400: clientError,
  500: serverError
}

tuxtitlan

<?php
$filename = 'https://upload.wikimedia.org/wikipedia/commons/9/9a/PNG_transparency_demonstration_2.png'; 
$handler = fopen($filename, "rb");
$content = '';

while (!feof($handler)) {
    $content .= fread($handler, 8192);
}

$encoded = base64_encode($content);