| -- 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%' |
When times get tough and people get nasty, you’ll need more than a killer smile. You’ll need a killer contract.
Used by 1000s of designers and developers Clarify what’s expected on both sides Helps build great relationships between you and your clients Plain and simple, no legal jargon Customisable to suit your business Used on countless web projects since 2008
…………………………
| # to generate your dhparam.pem file, run in the terminal | |
| openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048 |
| #!/bin/bash | |
| usage() { | |
| cat << EOF | |
| Usage: $0 [OPTION]... COMMAND | |
| Execute the given command in a way that works safely with cron. This should | |
| typically be used inside of a cron job definition like so: | |
| * * * * * $(which "$0") [OPTION]... COMMAND | |
| Arguments: |
| library(dplyr) | |
| library(tidyr) | |
| library(magrittr) | |
| library(ggplot2) | |
| "http://academic.udayton.edu/kissock/http/Weather/gsod95-current/NYNEWYOR.txt" %>% | |
| read.table() %>% data.frame %>% tbl_df -> data | |
| names(data) <- c("month", "day", "year", "temp") | |
| data %>% | |
| group_by(year, month) %>% |
| #http://rpubs.com/bradleyboehmke/median_income_trends | |
| # Preprocessing & summarizing data | |
| library(dplyr) | |
| library(tidyr) | |
| library(RCurl) | |
| library(XLConnect) | |
| library(magrittr) | |
| appURL <- "https://www.census.gov/hhes/www/income/data/historical/household/2013/h08.xls" | |
| f = CFILE("exfile.xls", mode="wb") | |
| curlPerform(url = appURL, writedata = f@ref, ssl.verifypeer = FALSE) |
| #!/bin/bash | |
| # AUTHOR: Bob Rudis <bob@rudis.net> (@hrbrmstr) | |
| # LICENSE: MIT + file zLICENSE | |
| TODAY=`date +%Y-%m-%d` | |
| TODAY_MD=`date +%B\ %d,\ %Y` | |
| YEAR=`date +%Y` | |
| PACKAGENAME=$1 |
This is an example Shiny app to use a dynamic Leaflet map like a selectInput. To run the app, install the necessary packages then enter the command shiny::runGist('4988b5164258917687cb').
Currently, there is an explosion of tools that aim to manage secrets for automated, cloud native infrastructure management. Daniel Somerfield did some work classifying the various approaches, but (as far as I know) no one has made a recent effort to summarize the various tools.
This is an attempt to give a quick overview of what can be found out there. The list is alphabetical. There will be tools that are missing, and some of the facts might be wrong--I welcome your corrections. For the purpose, I can be reached via @maxvt on Twitter, or just leave me a comment here.
There is a companion feature matrix of various tools. Comments are welcome in the same manner.
