Hanefi Onaldi hanefi

UPDATE a fork of this gist has been used as a starting point for a community-maintained "awesome" list: machine-learning-with-ruby Please look here for the most up-to-date info!

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)

	SELECT count(*) FROM users_table;

	SELECT pg_sleep((random() * 10)::int), count(*) from users_Table;

	SELECT pg_sleep(2), count(*) from users_Table;

	SET citus.force_max_query_parallelization TO ON;
	SELECT count(*) FROM users_table;

	SET citus.force_max_query_parallelization TO ON;

	# Make mouse useful in copy mode
	setw -g mode-mouse on

	# Allow mouse to select which pane to use
	set -g mouse-select-pane on

	# Allow mouse dragging to resize panes
	set -g mouse-resize-pane on

	# Allow mouse to select windows

	#!/bin/sh

	###
	# SOME COMMANDS WILL NOT WORK ON macOS (Sierra or newer)
	# For Sierra or newer, see https://github.com/mathiasbynens/dotfiles/blob/master/.macos
	###

	# Alot of these configs have been taken from the various places
	# on the web, most from here
	# https://github.com/mathiasbynens/dotfiles/blob/5b3c8418ed42d93af2e647dc9d122f25cc034871/.osx

	javascript:
	document.querySelectorAll('.load-diff-button').forEach(node => node.click())