Rails Pacific - Multitenancy with Rails

Covers the lessons learned about Multitenancy with Rails in the process of writing my book.

Transcript

1. lifx.co
2. #21 Not #21
3. Multitenancy with Rails Ryan Bigg
6. Multitenancy?
10. Organization Team Repos
11. User Repos
13. …
14. DOGLIFEBETA! Garçon Fluffy Brutus “Like Facebook, but for dogs”
15. Multitenancy with Rails?
17. Is it… ✔ well maintained ✔ well documented ✔ clean code
18. acts_as_tenant ✔ well documented
19. acts_as_tenant ✔ well maintained ✔ 140 commits, 19 contributors, low issue count ✔ CI on Travis
20. acts_as_tenant ✔ clean code
21. acts_as_tenant
22. RequestStore.store
24. Thread.current Thread.current
25. apartment ✔ well documented ✔ well maintained ✔ clean code
26. “If you are using PostgreSQL, Apartment by default will set up a new schema and migrate into there.”
27. “If you are using PostgreSQL, Apartment by default will set up a new schema and migrate into there.”
29. “A database contains one or more named schemas, which in turn contain tables.” “There are several reasons why one might want to use schemas: * To allow many users to use one database without interfering with each other.”
30. “To allow many users to use one database without interfering with each other.”
31. ryanbigg=# SHOW search_path; search_path ---------------- "$user",public (1 row) "$user",public
32. fluffy.doglife.com garcon.doglife.com DOGLIFE BETA! brutus.doglife.com 1 2 3
33. (1.4ms) CREATE SCHEMA "garcon" <more tables go here>
37. DEPLOY IT!
38. Heroku Postgres
39. Backup time 24 hours
40. PostgreSQL is great
41. PostgreSQL with too many schemas
42. Part 2: Schema-less Multitenancy
43. Apartment
45. TEST ALL THE TIME
46. TEST ALL THE TIME?
47. TEST ALL THE TIME
48. Are you testing right now? No?
49. TEST ALL THE TIME OR ELSE
50. A codebase without tests
51. fluffy.doglife.com Fluffy’s Posts current_account = Fluffy @posts = current_account.posts fluffy.doglife.com/posts Feature #1: Viewing Posts
52. A guest on Account A’s subdomain should only see Account A’s posts Expected to not see “<Account B’s post>” Feature #1: Viewing Posts
53. Feature #1: Viewing Posts
54. Feature #1: Viewing Posts
55. Feature #1: Viewing Posts
56. A guest on Account A’s subdomain should only see Account A’s posts Feature #1: Viewing Posts
57. fluffy.doglife.com Fluffy’s Posts current_account = Fluffy @posts = current_account.posts fluffy.doglife.com/posts Feature #1: Viewing Posts
58. fluffy.doglife.com Fluffy’s Albums current_account = Fluffy @albums = current_account.albums fluffy.doglife.com/albums Fluffy’s First Birthday Pictures @pictures = @album.pictures fluffy.doglife.com/albums/1/pictures Feature #2: Viewing Pictures
59. A guest on Account A’s subdomain should only see Account A’s albums Expected to not see “<Account B’s album>” Feature #2: Viewing Pictures
60. Feature #2: Viewing Pictures
61. Feature #2: Viewing Pictures
62. A guest on Account A’s subdomain should only see Account A’s albums Feature #2: Viewing Pictures
63. A guest on Account A’s subdomain viewing an album shows pictures from that album Expected to not see “<Account B’s picture>” Feature #2: Viewing Pictures
64. Feature #2: Viewing Pictures
65. Feature #2: Viewing Pictures
66. A guest on Account A’s subdomain viewing an album shows pictures from that album Feature #2: Viewing Pictures
67. fluffy.doglife.com Fluffy’s Albums current_account = Fluffy @albums = current_account.albums fluffy.doglife.com/albums Fluffy’s First Birthday Pictures @pictures = @album.pictures fluffy.doglife.com/albums/1/pictures Feature #2: Viewing Pictures
68. Feature #2: Viewing Pictures
69. REGRESSION TEST ALL THE TIME
70. Feature #2: Viewing Pictures
72. Part 3: Subscriptions
74. doglife.com/sign_up plan = Basic ($9.99) Feature #3: User subscribes to a plan ???
75. “Writing code to manage subscriptions is easy.” - nobody, ever
76. Your subscriptions code
77. PayPal
79. PayPal
81. “Stripe makes recurring and subscription-based billing easy.”
85. :CreateRecurringPaymentsProfileRequestDetails PayPal
87. “My company makes your life easy.”
88. doglife.com/sign_up plan = Basic ($9.99) Feature #3: User subscribes to a plan
90. me@ryanbigg.com me@ryanbigg.com ⁉ me@ryanbigg.com
91. leanpub.com/multi-tenancy-rails/c/railspacific $10 off