Amos Lanka amoslanka

## update_column_type.sql
BEGIN;
LOCK table_name;
ALTER TABLE table_name ADD COLUMN column_new column_type;
UPDATE table_name SET column_new = column_name;
ALTER TABLE table_name DROP column_name;
ALTER TABLE table_name RENAME column_new TO column_name;
END;

-- varchar -> integer
--   UPDATE cpvbeacon_dev SET column_new = CAST (nullif(column_name, '') AS INTEGER);

## Gemfile
# etc ...

group :development do
  # etc ...

  # Sprites:
  gem 'sprite-factory'
  gem 'rmagick'
  gem 'piet' # image optimization
end

## struck-postgres.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              1 star
            
          
                amoslanka
                / struck-postgres.md
            
            
              Created
              August 3, 2012 15:43
            
              
                Postgres in Struck Development
              
          
    Postgres in Struck Development

Installation

Option 1: Postgres.app (recommended):

http://postgresapp.com/
Option 2: Install it yourself:


## Gemfile
source :rubygems
gem 'sinatra'
gem 'httparty'
gem 'nokogiri'

## deploy.rb
set :sync_directories, ["public/assets", "public/galleries"]
set :sync_backups, 3

## etc_init.d_unicorn_example.co.uk
#! /bin/bash

### BEGIN INIT INFO
# Provides:          unicorn
# Required-Start:    $local_fs $remote_fs $network $syslog
# Required-Stop:     $local_fs $remote_fs $network $syslog
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: starts the unicorn web server
# Description:       starts unicorn

## README.md

      
              1 file
            
          
              3 forks
            
          
              0 comments
            
          
              12 stars
            
          
                chrisjacob
                / README.md
            
            
              Created
              September 1, 2011 12:08
            
              
                Node.js Install + CoffeeScript + LESS (+TextMate Bundles)
              
          
    Install Homebrew
http://mxcl.github.com/homebrew/
/usr/bin/ruby -e "$(curl -fsSL https://raw.github.com/gist/323731)"
brew help
cd ~
mate .bashrc


## setup-statsd.sh
# install git
sudo apt-get install g++ curl libssl-dev apache2-utils
sudo apt-get install git-core
# download the Node source, compile and install it
git clone https://github.com/joyent/node.git
cd node
./configure
make
sudo make install
# install the Node package manager for later use

## deploy.rb
set :sync_directories, ["public/assets", "public/galleries"]
set :sync_backups, 3
	BEGIN;
	LOCK table_name;
	ALTER TABLE table_name ADD COLUMN column_new column_type;
	UPDATE table_name SET column_new = column_name;
	ALTER TABLE table_name DROP column_name;
	ALTER TABLE table_name RENAME column_new TO column_name;
	END;

	-- varchar -> integer
	-- UPDATE cpvbeacon_dev SET column_new = CAST (nullif(column_name, '') AS INTEGER);
	# etc ...

	group :development do
	# etc ...

	# Sprites:
	gem 'sprite-factory'
	gem 'rmagick'
	gem 'piet' # image optimization
	end
	set :sync_directories, ["public/assets", "public/galleries"]
	set :sync_backups, 3
	#! /bin/bash

	### BEGIN INIT INFO
	# Provides: unicorn
	# Required-Start: $local_fs $remote_fs $network $syslog
	# Required-Stop: $local_fs $remote_fs $network $syslog
	# Default-Start: 2 3 4 5
	# Default-Stop: 0 1 6
	# Short-Description: starts the unicorn web server
	# Description: starts unicorn
	# install git
	sudo apt-get install g++ curl libssl-dev apache2-utils
	sudo apt-get install git-core
	# download the Node source, compile and install it
	git clone https://github.com/joyent/node.git
	cd node
	./configure
	make
	sudo make install
	# install the Node package manager for later use