willm

redis-cli --raw keys "$PATTERN" | xargs redis-cli del

willm

mysqldump --user=drupal --password=''--host='' --opt 'DB_NAME' > database.sql

willm

ifconfig | grep -oE "\b([0-9]{1,3}\.){3}[0-9]{1,3}\b"

willm

docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
docker volume rm $(docker volume ls |awk '{print $2}')
rm -rf ~/Library/Containers/com.docker.docker/Data/*

willm

Kill all sessions for a db

select pg_terminate_backend(pid)
from pg_stat_activity
where datname = 'doomed_database'

willm

:%!python -m json.tool

willm

curl -s -w "%{time_total}\n" -o /dev/null http://www.google.com/

willm

Querying google datasstore

const datastore = require('@google-cloud/datastore')({
      projectId: 'captureappprod',
      keyFilename: '/path/to/key.json' // key optained from App engine / IAM admin / service accounts
});
function deviceCount(start, count=0) {
    const batchSize = 300;
    const query = datastore.createQuery('Device') // Device is the 'kind'

willm

(New-Object System.DirectoryServices.DirectorySearcher("(&(objectCategory=User)(samAccountName=$($env:username)))")).FindOne().GetDirectoryEntry().memberOf

willm

# from  linux guest OS
killall VBoxClient
VBoxClient-all