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

chrisnew

#!/usr/bin/env bash
# postfix-wrapper.sh, version 0.1.0 
#
# You cannot start postfix in some foreground mode and 
# it's more or less important that docker doesn't kill 
# postfix and its chilren if you stop the container.
#
# Use this script with supervisord and it will take 
# care about starting and stopping postfix correctly.
#

oprudkyi

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Swift_Mailer;
use \Swift_Plugins_Logger;
use \Swift_Plugins_LoggerPlugin;

class DebugMailServiceProvider extends ServiceProvider implements Swift_Plugins_Logger

loilo

Back up and restore an IndexedDB database

This gist is an ES module which provides functions to import and export data from an IndexedDB database as JSON. It's based on Justin Emery's indexeddb-export-import package, but applies some adjustments that reflect better on the current browser landscape (i.e. better developer ergonomics but no support for Internet Explorer).

Usage

For each of the provided functionalities, you need a connected IDBDatabase instance.

Export Data

import { idb } from 'some-database'

eduardo-mior

CREATE TABLE orgao_expedidor(
   id    int       PRIMARY KEY,
   sigla varchar(8)   NOT NULL,
   nome  varchar(128) NOT NULL,
   tipo  int          NOT NULL -- 1 Orgão Federal -- 2 Orgão Regional -- 3 Orgão Municipal -- 4 Estrangeiro / Outro
);

CREATE INDEX idx_sigla ON orgao_expedidor (sigla);
CREATE INDEX idx_nome  ON orgao_expedidor (nome) ;

eduardo-mior

ABNC - Academia Brasileira de Neurocirurgia
AGU - Advocacia-Geral da União
ANAC - Agência Nacional de Aviação Civil
CAER - Clube de Aeronáutica
CAU - Conselho de Arquitetura e Urbanismo
CBM - Corpo de Bombeiro Militar
CFA - Conselho Federal Administração
CFB - Conselho Federal de Biblioteconomia
CFBIO - Conselho Federal de Biologia
CFBM - Conselho Federal de Biomedicina