martintsch

Sublime Text 2 – Useful Shortcuts (Mac OS X)

General

⌘T	go to file
⌘⌃P	go to project
⌘R	go to methods
⌃G	go to line
⌘KB	toggle side bar
⌘⇧P	command prompt

martintsch

#!/usr/bin/env bash

##
# @author Jay Taylor <outtatime@gmail.com>
#
# @date 2011-10-20
#
# @description Copies MySQL database to ramdisk then runs supplied shell script
# or command. The ramdisk version of the database is then copied back to the
# filesystem. Speeds up IO-intensive operations (e.g. loading heavily indexed

martintsch

build_package_patch_ruby_railsexpress() {
  fetch_git rvm-patchsets git://github.com/skaes/rvm-patchsets.git master
 
  for p in rvm-patchsets/patches/ruby/1.9.3/p484/railsexpress/* ; do
    patch -p1 < $p
  done
}
 
install_package "yaml-0.1.4" "http://pyyaml.org/download/libyaml/yaml-0.1.4.tar.gz#36c852831d02cf90508c29852361d01b"
install_package "ruby-1.9.3-p484" "http://ftp.ruby-lang.org/pub/ruby/1.9/ruby-1.9.3-p484.tar.gz#8ac0dee72fe12d75c8b2d0ef5d0c2968" patch_ruby_railsexpress autoconf standard

martintsch

build_package_patch_ruby_railsexpress() {
  fetch_git rvm-patchsets git://github.com/jhbabon/rvm-patchsets.git fix-2.1.1-backport

  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/01-current-2.1.1-fixes.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/02-zero-broken-tests.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/03-improve-gc-stats.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/04-display-more-detailed-stack-trace.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/05-show-full-backtrace-on-stack-overflow.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/06-fix-missing-c-return-event.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/07-backport-006e66b6680f60adfb434ee7397f0dbc77de7873.patch

martintsch

build_package_reconfigure() {
  test -f configure || autoconf
}

build_package_patch_ruby_railsexpress() {
  fetch_git rvm-patchsets git://github.com/skaes/rvm-patchsets.git master

  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/01-current-2.1.1-fixes.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/02-zero-broken-tests.patch
  patch -p1 < rvm-patchsets/patches/ruby/2.1.0/railsexpress/03-improve-gc-stats.patch

martintsch

curl -X PURGE “http://sharoo.com/.*” ; wp cache flush

martintsch

SELECT * FROM locations l INNER JOIN (SELECT u.first_name, u.last_name, u.id as user_id, t1.id as vehicle_id, t1.regno FROM users u INNER JOIN (SELECT * FROM vehicles v WHERE sak_activated_at IS NOT NULL AND sak_deactivated_at IS NULL) t1 ON t1.user_id = u.id) t2 ON l.vehicle_id = t2.vehicle_id;

martintsch

# This is a skeleton for testing models including examples of validations, callbacks,
# scopes, instance & class methods, associations, and more.
# Pick and choose what you want, as all models don't NEED to be tested at this depth.
#
# I'm always eager to hear new tips & suggestions as I'm still new to testing,
# so if you have any, please share!
#
# @kyletcarlson
#
# This skeleton also assumes you're using the following gems: 

martintsch

This will create a proxy server in whatever your availability zone your VPC is in. For me, that's us-east-1b. For you, that may be something different. Steps 10+ should more or less work regardless of your provider since those steps cover the setup and configuration of TinyProxy.

1. Click the Launch Instance button.
2. Choose Ubuntu Server 14.04 LTS (HVM), SSD Volume Type. This isn't strictly necessary. If you choose another OS, check its documentation for how to install new packages.
3. On the Choose an Instance Type screen, select t2.micro. It's Free Tier eligible.
4. Click the Next: ... buttons until you reach the Configure Security Group screen.
   • You may wish to reduce the amount of storage on the Add Storage screen. This is optional.
   • You may wish to add a tag on the Tag Instance screen. This is also optional.
5. On the Configure Security Group screen:

• Select Create a new security group.

martintsch

1 - Download the RDS certificates (root plus region-specific intermediate ones) bundle:

wget -O config/rds-combined-ca-bundle.pem https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem

2 - Add config/rds-combined-ca-bundle.pem to the repository and redeploy to Heroku.

3 - Update the DATABASE_URL env var: