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)
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%' |