edonosotti

# -------------------------------------------------------------------
# Reverse US GeoCoding in BigQuery using public datasets - counties
#
# WARNING: This query uses the OLD public datasets.
# Find the NEW version at:
# https://gist.github.com/edonosotti/f842c0868e663f3beb85133a75bdecca
# -------------------------------------------------------------------

# Create a temporary, in memory table
WITH IconicUSLocations AS (

edonosotti

# -------------------------------------------------------------------
# Reverse US GeoCoding in BigQuery using public datasets - cities
#
# WARNING: This query uses the OLD public datasets.
# Find the NEW version at:
# https://gist.github.com/edonosotti/10b9e642f3cc74e9dd2d026dd556486f
# -------------------------------------------------------------------

# Create a temporary, in memory table
WITH IconicUSLocations AS (

edonosotti

alias ls='ls -G'

# The next line updates PATH for the Google Cloud SDK.
if [ -f '/Users/enosotti/Tools/google-cloud-sdk/path.zsh.inc' ]; then . '/Users/enosotti/Tools/google-cloud-sdk/path.zsh.inc'; fi

# The next line enables shell command completion for gcloud.
if [ -f '/Users/enosotti/Tools/google-cloud-sdk/completion.zsh.inc' ]; then . '/Users/enosotti/Tools/google-cloud-sdk/completion.zsh.inc'; fi

# >>> conda initialize >>>
# !! Contents within this block are managed by 'conda init' !!

edonosotti

# This file is:  ~/.ssh/config

# You may have other (non-CodeCommit) SSH credentials stored in this
# config file – in addition to the CodeCommit settings shown below.

# NOTE: Make sure to run [ chmod 600 ~/.ssh/config ] after creating this file!

# Credentials for Account1
Host awscc-account1                                 # 'awscc-account1' is a name you pick
  Hostname git-codecommit.us-east-1.amazonaws.com   # This points to CodeCommit in the 'US East' region

edonosotti

#!/bin/bash

# Scenario: the database server is running outside of Kubernetes
# and it is in a private network.
# The database connection string is stored into a ConfigMap named:
# `MY_CONFIG_MAP` and its variable name is: `DATABASE_CONNECTION_STRING`.
# We don't want to copy & paste the connection string into the
# command line, we want it to be automatically pulled from the config and
# piped into the command.

edonosotti

#!/bin/bash
utmpdump /var/log/wtmp* | awk '$4~"root" {print}'

edonosotti

#!/bin/bash
dd if=/dev/urandom | gzip -9 >> /dev/null &

edonosotti

# NOT MY CODE! TAKEN FROM THE OFFICIAL DOCS:
# https://www.terraform.io/docs/providers/aws/r/api_gateway_account.html
# and saved here as a backup.

resource "aws_api_gateway_account" "demo" {
  cloudwatch_role_arn = "${aws_iam_role.cloudwatch.arn}"
}

resource "aws_iam_role" "cloudwatch" {
  name = "api_gateway_cloudwatch_global"

edonosotti

Enable SSH at boot on Raspberry Pi, Raspbian

Description

SSH is not enabled by default on Raspbian at the time of writing.

Tested on:

• Version:November 2018
• Release date: 2018-11-13

edonosotti

#!/bin/bash

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/*