Skip to content

Instantly share code, notes, and snippets.

View tuxtitlan's full-sized avatar

Victor Andres Carlos tuxtitlan

  • Aguascalientes, Mexico
  • 14:59 (UTC -06:00)
View GitHub Profile
@tuxtitlan
tuxtitlan / postgres_queries_and_commands.sql
Created September 5, 2019 01:51 — forked from rgreenjr/postgres_queries_and_commands.sql
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%'
@tuxtitlan
tuxtitlan / fields.py
Created May 1, 2017 23:34 — forked from yprez/fields.py
Django rest framework - Base64 image field
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