André Durão andredurao

I hereby claim:

I am andredurao on github.
I am andredurao (https://keybase.io/andredurao) on keybase.
I have a public key whose fingerprint is 57C1 38F4 CEB6 CAB4 2875 6290 57D4 DD9E AF79 3F75

To claim this, I am signing this object:

I hereby claim:

I am andredurao on github.
I am andredurao (https://keybase.io/andredurao) on keybase.
I have a public key whose fingerprint is 6FB2 E288 BC5F AC94 30A6 FF15 6ACB 69DE 1FC6 798C

To claim this, I am signing this object:

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)

$ cd /path/to/Dockerfile
$ sudo docker build .

View running processes

The figure below calls out

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	"dbus-send --print-reply --dest=org.mpris.MediaPlayer2.spotify /org/mpris/MediaPlayer2 org.mpris.MediaPlayer2.Player.PlayPause" XF86AudioPlay
	"dbus-send --print-reply --dest=org.mpris.MediaPlayer2.spotify /org/mpris/MediaPlayer2 org.mpris.MediaPlayer2.Player.Stop" XF86AudioStop
	"dbus-send --print-reply --dest=org.mpris.MediaPlayer2.spotify /org/mpris/MediaPlayer2 org.mpris.MediaPlayer2.Player.Next" XF86AudioNext
	"dbus-send --print-reply --dest=org.mpris.MediaPlayer2.spotify /org/mpris/MediaPlayer2 org.mpris.MediaPlayer2.Player.Previous" XF86AudioPrevious

	require 'nokogiri'
	require 'open-uri'

	# Get a Nokogiri::HTML:Document for the page we're interested in...

	doc = Nokogiri::HTML(open('http://www.google.com/search?q=tenderlove'))

	# Do funky things with it using Nokogiri::XML::Node methods...

	####