activerecord-multi-tenant
Apartment
| activerecord-multi-tenant | Apartment | |
|---|---|---|
| 1 | 5 | |
| 695 | 2,649 | |
| 0.3% | 0.4% | |
| 6.2 | 0.0 | |
| about 1 month ago | 2 months ago | |
| Ruby | Ruby | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
activerecord-multi-tenant
-
Nile, Serverless Postgres for Modern SaaS
Yup! I lean towards a tenant ID approach. I ALWAYS use a library that enforces these tenant checks on queries. Ruby (https://github.com/citusdata/activerecord-multi-tenant) and Elixir (I wrote https://github.com/sb8244/ecto_tenancy_enforcer) are the ones I have experience with.
Apartment
-
Figma's Databases team lived to tell the scale
I recall a popular rails gem[1] once upon a time that provided multi-tenancy via postgres schemas.
As it turns out, even the company the initially developed the gem ended up ditching the approach due to some of the issues you outlined above.
Managing separate schemas feels like one of those nefarious decisions that make things simple _initially_ but get you into a world of hurt when you need to scale. The company is since defunct but they have an article where they discuss why they ditched the approach [2], TL;DR it's too difficult to maintain and scale
[1] https://github.com/influitive/apartment#tenants-on-different...
-
Is there a way to have rails return a different set of data depending on the hostname?
Looks like you're trying to implement multi-tenancy. You might also want to look at the apartment gem.
-
Create views to display all data managed by apartment gem
One strategy of the apartment gem is to store tenant data in dedicated schemas in a Postgres database.
- restart rails app from controller action
-
How we found and fixed a rare race condition in our session handling - The GitHub Blog
The other issue I think was with Apartment tenant switching and ActiveRecord's column cache. Some tenants had the updated columns and others didn't. Also with Puma. People love them some Puma! Me, I go with Passenger. Well, if the requirements are right that is...
What are some alternatives?
Acts As Tennant - Easy multi-tenancy for Rails in a shared database setup.
Milia - Easy multi-tenanting for Rails5 (or Rails4) + Devise
multi-tenant-support - Build a highly secure, no data leak, multi-tenant rails app
rails_or - Cleaner syntax for writing OR Query in Rails 5, 6. And also add #or support to Rails 3 and 4.
n1_loader - Loader to solve N+1 issues for good. Highly recommended for GraphQL API.
pluck_all - A more efficient way to get data from database. Like #pluck method but return array of hashes instead.
ArLazyPreload - Lazy loading associations for the ActiveRecord models
SanitizeSqlLike - Backport #sanitize_sql_like method from Rails 4 for Rails 3. Sanitizes a string so that it is safe to use within an SQL LIKE statement.
BabySqueel - :pig: An expressive query DSL for Active Record