Multitenent presentation

schema seperation in postgresql

http://aac2009.confreaks.com/videos/06-feb-2009-14-30-writing-multi-tenant-applications-in-rails-guy-naor-small.mp4

Skip ahead to 22:55

Here is my retype of the application control logic to switch schemas using search paths in postgresql.

class ApplicationController < ActionController::Base

	before_filter :set_account
	after_filter :clear_account

	protected

	def set_account
		SchemaUtils.add_schema_to_path
		Account.find_by_subdomain(request.subdomains.last).db_schema
	end

	def clear_account
	  SchemaUtils.reset_search_path
	end  	
end