Apartment
Rails PG Extras
Our great sponsors
Apartment | Rails PG Extras | |
---|---|---|
5 | 11 | |
2,638 | 1,062 | |
0.5% | - | |
0.0 | 5.7 | |
25 days ago | about 1 month 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.
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...
Rails PG Extras
-
What are your favourite approaches to keeping on top of Postgres health?
I use either PgHero or Rails PG Extras on every project
-
Best way to learn query optimization?
https://github.com/pawurb/rails-pg-extras is useful for identifying slow queries and generally things that could make queries slow.
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
activerecord-multi-tenant - Rails/ActiveRecord support for distributed multi-tenant databases like Postgres+Citus
rails_or - Cleaner syntax for writing OR Query in Rails 5, 6. And also add #or support to Rails 3 and 4.
pluck_all - A more efficient way to get data from database. Like #pluck method but return array of hashes instead.
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.
multi-tenant-support - Build a highly secure, no data leak, multi-tenant rails app
Enumerize - Enumerated attributes with I18n and ActiveRecord/Mongoid support
marginalia - Attach comments to ActiveRecord's SQL queries
Awesome Nested Set - An awesome replacement for acts_as_nested_set and better_nested_set.
Filtered - Filters ActiveRecord queries in a nice way
ActsAsList - An ActiveRecord plugin for managing lists.