Command: heroku pgbackups:capture --remote production
Response: >>> HEROKU_POSTGRESQL_COLOR_URL (DATABASE_URL) ----backup---> a712
Command: heroku pgbackups:url [db_key] --remote production
#!/usr/bin/env ruby | |
require 'nokogiri' | |
require 'open-uri' | |
require 'etc' | |
# home user path | |
home_path = Etc.getpwnam(Etc.getlogin).dir | |
wallpaper_folder = "#{home_path}/Pictures/wallpapers" |
class Api::UploadsController < ApiController | |
def create | |
@upload = Upload.new(upload_params) | |
ensure | |
clean_tempfile | |
end | |
private |
WITH table_scans as ( | |
SELECT relid, | |
tables.idx_scan + tables.seq_scan as all_scans, | |
( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes, | |
pg_relation_size(relid) as table_size | |
FROM pg_stat_user_tables as tables | |
), | |
all_writes as ( | |
SELECT sum(writes) as total_writes | |
FROM table_scans |
ActiveSupport::Notifications.subscribe('deprecation.rails') do |name, start, finish, id, payload| | |
Honeybadger.notify( | |
error_class: "DEPRECATION WARNING", | |
error_message: payload[:message], | |
backtrace: payload[:callstack] | |
) | |
end |
#!/bin/bash | |
# Convert a MDB file (Access) to SQL | |
# Needs mdbtools[http://mdbtools.sourceforge.net/] | |
# run 'aptitude install mdbtools' on Debian/Ubuntu | |
# Created by Álvaro Justen <https://github.com/turicas> | |
# License: GPLv2 | |
mdb=$1 | |
sql=$2 |
RED="\[\033[0;31m\]" | |
YELLOW="\[\033[0;33m\]" | |
GREEN="\[\033[0;32m\]" | |
BLUE="\[\033[0;34m\]" | |
LIGHT_RED="\[\033[1;31m\]" | |
LIGHT_GREEN="\[\033[1;32m\]" | |
WHITE="\[\033[1;37m\]" | |
LIGHT_GRAY="\[\033[0;37m\]" | |
COLOR_NONE="\[\e[0m\]" |