bemi-rails
Closure Tree
bemi-rails | Closure Tree | |
---|---|---|
- | 2 | |
65 | 1,826 | |
- | 0.4% | |
6.7 | 5.7 | |
about 1 month ago | 3 months ago | |
Ruby | Ruby | |
GNU Lesser General Public License v3.0 only | 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.
bemi-rails
We haven't tracked posts mentioning bemi-rails yet.
Tracking mentions began in Dec 2020.
Closure Tree
-
Hierarchical Structures in PostgreSQL
I'm actually using materialized views and CTE with PhotoStructure (where hierarchies are arguably the cornerstone of the product).
It's pretty funny that I landed on this implementation, given that I spent a couple years building https://github.com/ClosureTree/closure_tree (one of the most popular acts-as-hierarchy ActiveRecord gems), as it (unsurprisingly) uses closure trees.
When CTE isn't available, closure trees are nice, but boy howdy, does that closure tree table get gigantic with deeper graphs.
If CTE is available, closure trees don't even come close in performance and simplicity.
(Hint: materialized paths should use a unique separator: ASCII 0x1F is applicable: https://en.wikipedia.org/wiki/C0_and_C1_control_codes#Field_...)
-
Find all objects of a chain of associations on the same table
I’ve used this for that https://github.com/ClosureTree/closure_tree
What are some alternatives?
Ancestry - Organise ActiveRecord model into a tree structure
Awesome Nested Set - An awesome replacement for acts_as_nested_set and better_nested_set.
ActsAsTree - ActsAsTree -- Extends ActiveRecord to add simple support for organizing items into parent–children relationships.
rails_or - Cleaner syntax for writing OR Query in Rails 5, 6. And also add #or support to Rails 3 and 4.
Mongoid Tree - A tree structure for Mongoid documents using the materialized path pattern
DbTextSearch - A unified interface on top of ActiveRecord for case-insensitive string-in-set and prefix querying, and full-text search on SQLite, MySQL, and PostgreSQL.
ActiveRecordExtended - Adds additional postgres functionality to an ActiveRecord / Rails application
Rails PG Extras - Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
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
Atomically - An ActiveRecord extension for writing commonly useful atomic SQL statements to avoid race condition.
LeftJoins - Backport left_joins method from Rails 5 for Rails 3 and 4