jtbonhomme

Cheatseet assumes you're just playing around on a not clustered ClickHouse server.

docker run -it yandex/clickhouse-client --host your.toy.server.host --port 9500 --user default --password password123 --multiline

SHOW DATABASES

SHOW TABLES (in current database)

SHOW DICTIONARIES (in current database)

jtbonhomme

# Save this into .git/hooks/pre-push, then chmod +x .git/hooks/pre-push
if [[ `grep 'DO-NOT-PUSH.*'` ]]; then
  echo "You really don't want to push this branch. Aborting."
  exit 1
fi

jtbonhomme

tmux Cheat Sheet

Table of Contents

• General Usage
• Shortcuts
• Commands
• Scripting tmux
• Configuring tmux

jtbonhomme

# First install tmux
brew install tmux

# For mouse support (for switching panes and windows)
# Only needed if you are using Terminal.app (iTerm has mouse support)
Install http://www.culater.net/software/SIMBL/SIMBL.php
Then install https://bitheap.org/mouseterm/

# More on mouse support http://floriancrouzat.net/2010/07/run-tmux-with-mouse-support-in-mac-os-x-terminal-app/

jtbonhomme

Getting GCP access token from a service account key

Use your service account's key JSON file to get an access token to call Google APIs.

Good for seeing how things work, including the creation of JWT token.

To create a JWT token, you can replace create-jwt-token.sh script with tools like step.

If you just want to get an access token for a service account,

jtbonhomme

#
# Configuration for Autoscaling group.
#
resource "aws_launch_template" "eks-cluster-worker-nodes" {
  iam_instance_profile        = { name = "${aws_iam_instance_profile.eks-cluster-worker-nodes.name}" }
  image_id                    = "${data.aws_ami.eks-worker.id}"
  name                        = "${var.cluster-name}-eks-cluster-worker-nodes"
  vpc_security_group_ids      = ["${aws_security_group.eks-cluster-worker-nodes.id}"]
  key_name                    = "${var.ssh-key-name}"
  instance_type               = "${local.host-types[0]}"

jtbonhomme

echo "Creating an SSH key for you..."
ssh-keygen -t rsa

echo "Please add this public key to Github \n"
echo "https://github.com/account/ssh \n"
read -p "Press [Enter] key after this..."

echo "Installing xcode-stuff"
xcode-select --install

jtbonhomme

package main

import (
	"log"
	"net"
	"os"
	"os/signal"
	"sync"
	"syscall"
	"time"

jtbonhomme

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

jtbonhomme

package main

import (
    "crypto/rand"
    "fmt"
)

func main() {
    c := 10
    b := make([]byte, c)