Awesome Nested Set
Our great sponsors
|Awesome Nested Set||LeftJoins|
|10 months ago||about 2 years ago|
|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.
Awesome Nested Set
Active record: how to recursively load children of children of children in one query?
2 projects | reddit.com/r/rails | 1 Apr 2022
Another option is to use something like AwesomeNestedSet which does basically the same thing as the previous suggestion but with a whole lot more flexibility (and likely more reliably performant).
The surprisingly difficult problem of user-defined order in SQL
2 projects | news.ycombinator.com | 15 Jan 2021
We haven't tracked posts mentioning LeftJoins yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
Ancestry - Organise ActiveRecord model into a tree structure
Closure Tree - Easily and efficiently make your ActiveRecord models support hierarchies
ActsAsTree - ActsAsTree -- Extends ActiveRecord to add simple support for organizing items into parent–children relationships.
Mongoid Tree - A tree structure for Mongoid documents using the materialized path pattern
rails_or - Cleaner syntax for writing OR Query in Rails 5, 6. And also add #or support to Rails 3 and 4.
Filtered - Filters ActiveRecord queries in a nice way
BabySqueel - :pig: An expressive query DSL for Active Record
Rails PG Extras - Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
FindWithOrder - Provides a simple way to find records in the same order of input array. Has better performance than manually sorting. (Support both PostgreSQL and MySQL)
Atomically - An ActiveRecord extension for writing commonly useful atomic SQL statements to avoid race condition.
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.
Acts As Tennant - Easy multi-tenancy for Rails in a shared database setup.