Daniel Agans phwelo

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)

export KUBE_EDITOR='code --wait'

Running k edit ... will open up the yaml using Visual Studio Code.

This document was created back in 2020 and might not be actual nowadays. It is not supported anymore, so use thise information at your own risk.

Download WSL2 Kernel
run wsl --set-default-version 2 in windows command line, so that all future WSL machine will use WSL2.

	require "net/https"

	url = URI.parse("https://api.pushover.net/1/messages")
	req = Net::HTTP::Post.new(url.path)
	req.set_form_data({
	:token => "abc123",
	:user => "user123",
	:message => "hello world",
	})
	res = Net::HTTP.new(url.host, url.port)

	# In Chef, when a resource is defined all its variables are evaluated during
	# compile time and the execution of the resource takes place in converge phase.
	# So if the value of a particular attribute is changed in converge
	# (and not in compile) the resource will be executed with the old value.

	# Example problem:
	# Let's consider this situation where there are two steps involved in a recipe
	# Step 1 is a Ruby block that changes a node attribute. Rubyblocks get executed
	# in converge phase
	# Step 2 is a Chef resource that makes use of the node attribute that was

	function ProcessingAnimation($scriptBlock) {
	$cursorTop = [Console]::CursorTop

	try {
	[Console]::CursorVisible = $false

	$counter = 0
	$frames = '\|', '/', '-', '\'
	$jobName = Start-Job -ScriptBlock $scriptBlock

	<powershell>
	winrm quickconfig -q
	winrm set winrm/config/winrs '@{MaxMemoryPerShellMB="300"}'
	winrm set winrm/config '@{MaxTimeoutms="1800000"}'
	winrm set winrm/config/service '@{AllowUnencrypted="true"}'
	winrm set winrm/config/service/auth '@{Basic="true"}'

	netsh advfirewall firewall add rule name="WinRM 5985" protocol=TCP dir=in localport=5985 action=allow
	netsh advfirewall firewall add rule name="WinRM 5986" protocol=TCP dir=in localport=5986 action=allow

	a4b.amazonaws.com
	access-analyzer.amazonaws.com
	account.amazonaws.com
	acm-pca.amazonaws.com
	acm.amazonaws.com
	airflow-env.amazonaws.com
	airflow.amazonaws.com
	alexa-appkit.amazon.com
	alexa-connectedhome.amazon.com
	amazonmq.amazonaws.com

	c.content.user_stylesheets = ['/path/to/reddit.user.css']

	# or if you have a directory with .user.css files:

	import glob

	c.content.user_stylesheets = glob.glob('/path/to/*.user.css')

	import boto3
	from boto3.session import Session


	def assume_role(arn, session_name):
	"""aws sts assume-role --role-arn arn:aws:iam::00000000000000:role/example-role --role-session-name example-role"""

	client = boto3.client('sts')
	account_id = client.get_caller_identity()["Account"]
	print(account_id)