eadz

# For turning heroku DB logs into a CSV 
# getting the logs from papertrail:
# you need your papertrail token available
# echo "token: xxxxxxxx" > ~/.papertrail.yml
# papertrail -S pg_load --min-time "30 days ago" > logs.txt
# where `pg_load` is a saved search which finds the postgres status logs 

txt = File.read("./logs.txt")
require 'csv'
CSV.open("logs.csv", "wb") do |csv|

eadz

CREATE TABLE accounts(
	id serial PRIMARY KEY,
	name VARCHAR(256) NOT NULL
);

CREATE TABLE entries(
	id serial PRIMARY KEY,
	description VARCHAR(1024) NOT NULL,
	amount NUMERIC(20, 2) NOT NULL CHECK (amount > 0.0),
	-- Every entry is a credit to one account...

eadz

# No Downtime Deploys
# to setup
# clone your app in ~/app-a and ~/app-b
# use the following caddy server config
# yourdomain.com {
# reverse_proxy * {
#    to http://127.0.0.1:4210 http://127.0.0.1:4220
#    header_up +Host yourdomain.com
#    header_up -X-Forwarded-Host
#    health_uri /up