Andrew Weir andruu

😎

What is this?

josegonzalez / deploy.rb

Created October 23, 2010 16:40

Capistrano Deploy Script for CakePHP applications using GIT (Update the $config hash))

	$config = {
	"application" => "DOMAIN.TLD",
	"repository" => "git@GITHOST:USERNAME/REPOSITORYNAME.git",
	"remoteusername" => "REMOTEUSERNAME",
	"cake_folder" => "/PATH/TO/CAKE",
	"cake_version" => "cakephp1.3",
	"plugin_dir" => "plugins",
	"servers" => {
	"prod" => {
	"server" => "APPLICATION.TLD",

predominant / ubuntu-1104-nginx-base.sh

Created October 5, 2011 15:19

Install Ubuntu 11.04 Nginx based web server with PHP-FPM, MySQL and MongoDB

	#!/bin/bash

	###
	#
	# Copyright (c) 2011 Cake Development Corporation (http://cakedc.com)
	#
	# Ubuntu 11.04 based web server installation script
	# Run this by executing the following from a fresh install of Ubuntu 11.04 server:
	#
	# bash -c "$(curl -fsSL https://raw.github.com/gist/1264701)" <mysqlPassword>

rgreenjr / postgres_queries_and_commands.sql

Last active November 14, 2024 09:13

Useful PostgreSQL Queries and Commands

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

leighhalliday / output.txt

Created May 9, 2015 18:45

Recursive "Carnac" solution in Ruby