Corys
I got a new video up on doing multi tenancy in phoenix 1.3 using Apartmentex.
Lemme know if any questions. 
Where Next?
Trending in Screencasts
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Catch errors, track performance, monitor hosts and more.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixir-ls
- #ai
- #elixirconf-us
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
Producing high quality Elixir screencasts since 2017.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 5- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
marciol
Hi @Corys, great post. I have been working with this kind of approach for some time, but after read a blog post by Influitive, the creators of gem Apartment, which inspired the Apartmentex Hex Package, I started to think if this is the best approach.
After some research I found a new feature in postgreSQL that could be an alternative, Row Security Level, and a great post by 2ndQuadrant
Let us know what do you think.
OvermindDL1
Now wha? PostgreSQL finally added RSL? I’ve been wanting that for years! Whoo hoo! I like its implementation!
brightball
It’s a good approach, but one of the big perks of the apartment approach with schema per tenant is total separation of indexes across all tables in addition to just the isolation aspect. The approach of schema per tenant also makes it a lot easier for you to scale horizontally by tenant, or even breaking things into entirely regionalized zones. When the tenant doesn’t need access to other tenant info it’s a big perk.
You don’t necessarily need Apartment to do it, but the approach has a lot of benefits.
marciol
Yes, in Phoenix is straightforward to achieve this without the help of any package.
andre1sk
It’s in since 9.5