Pau Pérez Fabregat sauloperez

Description

Heroku is a simple way to publish your Rails app, and a powerful platform that will allow it to scale. In this episode, Jay McGavren gets you started with your first Heroku app.

Set up your Rails app

Isolate your gem environment

You WANT Rails to fail locally if a gem isn't in your Gemfile

Introduction

An introduction to curl using GitHub's API.

The Basics

Makes a basic GET request to the specifed URI

curl https://api.github.com/users/caspyin

	1) see re: increasing shmmax http://stackoverflow.com/a/10629164/1283020

	2) add to postgresql.conf:
	shared_preload_libraries = 'pg_stat_statements' # (change requires restart)
	136 pg_stat_statements.max = 1000
	137 pg_stat_statements.track = all

	3) restart postgres

	4) check it out in psql

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

	#!/usr/bin/env ruby

	# Complete rake tasks script for bash
	# Save it somewhere and then add
	# complete -C path/to/script -o default rake
	# to your ~/.bashrc
	# Xavier Shay (http://rhnh.net), combining work from
	# Francis Hwang ( http://fhwang.net/ ) - http://fhwang.net/rb/rake-complete.rb
	# Nicholas Seckar <[email protected]> - http://www.webtypes.com/2006/03/31/rake-completion-script-that-handles-namespaces
	# Saimon Moore <[email protected]>

	# connect to postgres
	psql -h localhost

	# create database
	CREATE DATABASE mydatabase;

	# switch to your database
	\connect mydatabase

	# add postgis extension

	### Nginx upstart script
	### source: http://serverfault.com/a/391737/70451
	### /etc/init/nginx.conf

	description "nginx http daemon"

	start on (filesystem and net-device-up IFACE=lo)
	stop on runlevel [!2345]

	env DAEMON=/usr/local/sbin/nginx

	# goes inside /etc/init/foo.conf
	# Upstart: /etc/init/service_name.conf
	description "start passenger stand-alone"
	author "Me <[email protected]>"

	# Stanzas
	#
	# Stanzas control when and how a process is started and stopped
	# See a list of stanzas here: http://upstart.ubuntu.com/wiki/Stanzas#respawn

	sudo a2enmod proxy_http
	sudo service apache2 restart