David Chun dchun

Indie Dev building Saas apps and a bunch of Google Worspace Apps

merqlove / optimization.rake

Created January 9, 2015 13:55

PostgreSQL optimization tasks for ActiveRecord

	namespace :optimization do
	desc "Provide DB vacuum for production environment"
	task :vacuum => :environment do
	begin
	tables = ActiveRecord::Base.connection.tables
	tables.each do \|table\|
	ActiveRecord::Base.connection.execute("VACUUM FULL ANALYZE #{table};")
	end
	rescue Exception => exc
	Rails.logger.error("Database VACUUM error: #{exc.message}")

ivanvanderbyl / gist:4222308

Created December 6, 2012 06:55

Postgres 9.1 to 9.2 upgrade guide for Ubuntu 12.04

	sudo add-apt-repository ppa:pitti/postgresql
	sudo apt-get update
	sudo apt-get install postgresql-9.2 postgresql-server-dev-9.2 postgresql-contrib-9.2

	sudo su -l postgres
	psql -d template1 -p 5433
	CREATE EXTENSION IF NOT EXISTS hstore;
	CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
	service postgresql stop
	/usr/lib/postgresql/9.2/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin -B /usr/lib/postgresql/9.2/bin -d /var/lib/postgresql/9.1/main/ -D /var/lib/postgresql/9.2/main/ -O "-c config_file=/etc/postgresql/9.2/main/postgresql.conf" -o "-c config_file=/etc/postgresql/9.1/main/postgresql.conf"

equivalent / app-assets-javascript-datepicker.js.coffee

Created July 5, 2012 12:24

Simple Form custom input for "Datepicker for Twitter Bootstrap" running under Ruby on Rails with Ransack search

	# install and make run basic bootstrap date-picker functionality described here http://www.eyecon.ro/bootstrap-datepicker/

	# app/assets/javascript/datepicker.js.coffee
	$(document).on 'pageChanged', ->

	# datepicker for simple_form & Ransack
	$(".custom_datepicker_selector").datepicker().on 'changeDate', (en) ->
	correct_format = en.date.getFullYear() + '-' + ('0' + (en.date.getMonth() + 1)).slice(-2) + '-' + ('0' + en.date.getDate()).slice(-2) # date format yyyy-mm-dd
	$(this).parent().find("input[type=hidden]").val(correct_format)

brennandunn / gist:2001303

Created March 8, 2012 14:45

	# This file is used by Rack-based servers to start the application.

	require ::File.expand_path('../config/environment', __FILE__)
	require 'toto'

	Toto::Paths[:templates] = 'blog/templates'
	Toto::Paths[:pages] = 'blog/templates/pages'
	Toto::Paths[:articles] = 'blog/articles'

	toto = Toto::Server.new do

jacobbubu / ioslocaleidentifiers.csv

Created February 15, 2012 14:41

iOS Locale Identifiers

We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.