scott hamilton shamil614

Arel Cheatsheet on Steroids

A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.

Tables

posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord

Table alias

Visual Studio Code and Elixir

Here I wanted to share my own configuration of Visual Studio Code that I currently use when programming in Elixir. The section about Tasks and Shortcut is taken from this post: Running Elixir Tests in Visual Studio Code/ElixirLS.

Required extensions

vscode-elixir

Custom tasks

Kubernetes cheatsheet

Kubernetes cheatsheet
Everything is an object - persistent entities

If you'd like to experiment with Terraform on macOS locally, a great provider for doing so is the Docker provider. You can get set up in a few simple steps, like so:

1. Install Docker

Install Docker for Mac if you have not already.

	explain (analyze, buffers)
	SELECT
	pg_get_userbyid(userid) as user,
	pg_database.datname,
	pg_stat_statements.queryid,
	pg_stat_statements.calls as calls_total,
	pg_stat_statements.total_exec_time / 1000.0 as seconds_total,
	pg_stat_statements.rows as rows_total,
	pg_stat_statements.blk_read_time / 1000.0 as block_read_seconds_total,
	pg_stat_statements.blk_write_time / 1000.0 as block_write_seconds_total

	SELECT
	pg_stat_statements.query as query,
	round(pg_stat_statements.total_exec_time::numeric, 2) AS total_time,
	pg_stat_statements.calls,
	round(pg_stat_statements.mean_exec_time::numeric, 2) AS mean,
	round((100 * pg_stat_statements.total_exec_time /
	sum(pg_stat_statements.total_exec_time::numeric) OVER ())::numeric, 2) AS percentage_cpu,
	round((100 * pg_stat_statements.calls /
	sum(pg_stat_statements.calls::numeric) OVER ())::numeric, 2) AS percentage_calls,
	pg_user.usename as username,

	-- table + index sizes
	SELECT
	table_name,
	pg_size_pretty(table_size) AS table_size,
	pg_size_pretty(indexes_size) AS indexes_size,
	pg_size_pretty(total_size) AS total_size
	FROM (
	SELECT
	table_name,
	pg_table_size(table_name) AS table_size,

	psql -h <host> -U <user> -W -d postgres

	SELECT * from pg_stat_activity;
	SELECT * from pg_stat_database;

	# Queries running during >5 minutes
	SELECT
	pid,
	datname,
	query,

	# Makefile for PlantUML
	# Author: Devin Weaver (@sukima) <[email protected]>
	# GistID: 52eacde54bf7861b19ee66a07b864583
	#
	# This handles SVGs PNGs and ASCII outputs.
	# It handles included files with the .iuml extension: !include foo.iuml
	# All diagrams have the .uml extension and reside in the diagrams directory
	# All output is saved to the output directory
	#
	# make svg - (default) build all diagrams as SVGs

	sudo yum update
	sudo amazon-linux-extras enable postgresql11
	sudo yum install postgresql postgresql-devel