Multi-Tenancy with Rails & Postgres

Short talk I did at the Groningen.rb meetup about multi tenant rails apps.

Some links to stuff I mentioned:
Postgres Schema's: http://www.postgresql.org/docs/9.3/static/ddl-schemas.html
Apartment gem: https://github.com/influitive/apartment
Example app: https://github.com/DefactoSoftware/Hours

Transcript

1. MULTI-TENANCY WITH RAILS & POSTGRES jurre stender @jurretweet github.com/jurre
2. WHAT’S MULTI-TENANCY?
3. “Multi-tenancy refers to a principle in software architecture where a single instance of the software runs on a server, serving multiple client- organizations (tenants)” - Wikipedia
4. So, can’t we just…
5. # app/models/user.rb class User < ActiveRecord::Base belongs_to :account end ! # app/models/category.rb class Category < ActiveRecord::Base belongs_to :account end ! # app/models/account.rb class Account < ActiveRecord::Base has_many :users has_many :categories end ! # app/controllers/categories_controller.rb class CategoriesController < ApplicationController def index @categories = current_account.categories end ! private def current_account current_user.account end end
6. WOULDN’T IT BE NICE
7. # app/models/user.rb class User < ActiveRecord::Base end ! # app/models/category.rb class Category < ActiveRecord::Base end ! # app/models/account.rb class Account < ActiveRecord::Base end ! # app/controllers/categories_controller.rb class CategoriesController < ApplicationController def index @categories = Category.all end end
8. SCHEMA’S
9. database (hours_production) ! accounts ! id subdomain created_at updated_at ! ! ! users ! id name encypted_password account_id created_at updated_at ! ! categories ! id name created_at updated_at ! ! entries ! id hours user_id category_id created_at updated_at ! ! schema (defacto) ! users ! id name encypted_password account_id created_at updated_at ! ! categories ! id name created_at updated_at ! ! entries ! id hours user_id category_id created_at updated_at ! ! schema (grunnrb) !
10. APARTMENT
11. QUESTIONS?