AlexSJ

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

AlexSJ

Here is a high level overview for what you need to do to get most of an Android environment setup and maintained.

Prerequisites (for Homebrew at a minimum, lots of other tools need these too):

• XCode is installed (via the App Store)
• XCode command line tools are installed (xcode-select --install will prompt up a dialog)
• Java

Install Homebrew:

AlexSJ

'use strict';

const http = require('http');
const cpf = process.argv[2];

const url = 'http://dabsistemas.saude.gov.br/sistemas/sadab/js/buscar_cpf_dbpessoa.json.php?cpf='

const consult = `${url}${cpf}`;

http.get(consult, res => {

AlexSJ

library(httr)
library(rvest)
library(dplyr)
library(stringr)
library(tidyr)


universal_pags <- function() {
  universal_pag <- function(pag) {
    link <- sprintf('http://www.universal.org/enderecos/busca/brasil/todas/%04d/', pag)

AlexSJ

Install php7.0-fpm

# remove php5 modules
apt-get autoremove --purge php5-*
# add php-7.0 source list by [Ondřej Surý](https://github.com/oerdnj)
add-apt-repository ppa:ondrej/php
# Update index
apt-get update
# Install php7.0-fpm with needed extensions

AlexSJ

#Teclas de atalhos do PHPStorm com funções semelhantes ao Sublime Text, e outras interessantes.

Sublime Text	PHPStorm	Função
CMD+P	CMD+Shift+O	Busca por arquivos no projeto
CMD+R	CMD+F12 (1)	Lista os métodos da classe e outros símbolos
CMD+F	CMD+F	Busca no arquivo
CMD+Option+F	CMD+R	Busca e troca os valores no arquivo
CMD+Shift+F	CMD+Shift+F	Busca, busca e troca e outros em um determinado caminho com várias regras.
CMD+D (2)	Option+Up (2)	Seleciona palavra