Jay Fredlund jayfredlund

Ruby on Ales 2016

Ted's notes (@thesleepyvegan)

Ruby on Ales schedule. Notes are in order from almost all the sessions. I didn't see Choices by Ernie Miller.

Twitternets: #roa2016

Mike Moore (@blowmage)

	{
	"alert_email": "email address where you want automated warnings to go",
	"backup_interval": "int value for db backups, configurable on dashboard",
	"backup_window": "int value for db backups, configurable on dashboard",
	"ruby_version": "Ruby 1.9.3 - could be 2.0.0 or something else",
	"db_host": "internal hostname of your database master",
	"db_slaves": [
	"db replica hosts appear here. only works with [Postgre\|My]SQL"
	],
	"user_ssh_key": [

	# Here's a contrived example of a LEFT JOIN using ARel. This is an example of
	# the mechanics, not a real-world use case.

	# NOTE: In the gist comments, @ozydingo linked their general-purpose ActiveRecord
	# extension that works for any named association. That's what I really wanted!
	# Go use that! Go: https://gist.github.com/ozydingo/70de96ad57ab69003446

	# == DEFINITIONS
	# - A Taxi is a car for hire. A taxi has_many :passengers.
	# - A Passenger records one person riding in one taxi one time. It belongs_to :taxi.

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), 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(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'