Jean-Thierry BONHOMME 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)

tmux Cheat Sheet

Table of Contents

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,

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)

	# 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

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

	#
	# 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]}"

	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