Rails Pacific - Multitenancy with Rails

Transcript

1. lifx.co

2. #21 Not #21

3. Multitenancy with Rails Ryan Bigg

4. None
5. None

6. Multitenancy?

7. None
8. None
9. None

10. Organization Team Repos

11. User Repos

12. None

13. …

14. DOGLIFEBETA! Garçon Fluffy Brutus “Like Facebook, but for dogs”

15. Multitenancy with Rails?

16. None

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

23. None

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.”
28. None

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>

34. None
35. None
36. None

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

44. None

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

71. None

72. Part 3: Subscriptions

73. None

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

78. None

79. PayPal

80. None

81. “Stripe makes recurring and subscription-based billing easy.”

82. None
83. None
84. None

85. :CreateRecurringPaymentsProfileRequestDetails PayPal

86. None

87. “My company makes your life easy.”

88. doglife.com/sign_up plan = Basic ($9.99) Feature #3: User subscribes to

    a plan
89. None

90. me@ryanbigg.com me@ryanbigg.com ⁉ me@ryanbigg.com

91. leanpub.com/multi-tenancy-rails/c/railspacific $10 off