Awesome Nested Set
Rails PG Extras
Our great sponsors
| Awesome Nested Set | Rails PG Extras | |
|---|---|---|
| 2 | 11 | |
| 2,375 | 1,072 | |
| 0.1% | - | |
| 5.5 | 5.7 | |
| about 1 month ago | about 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.
Awesome Nested Set
-
Active record: how to recursively load children of children of children in one query?
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
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
- rails-pg-extras introduces new API for measuring SQL queries generated by any Ruby snippet
-
Effective Queries with Rails and PostgreSQL
Your first impression may be that it's better to add indexes to every field in a database. However, first of all, only one of the defined indexes is working here (see the compound index section). Furthermore, indexes can slow down queries if there are not many records in the database, and each index takes up space in a computer's memory. Often, the size of the indexes may be larger than the amount of the data stored in a database. You can install the "rails-pg-extras" gem to get more information. I recommend that you carefully study the documentation of this gem, as it contains many useful functions that will make your work with the database as efficient as possible.
-
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.
- rails-pg-extras: a new release adds built-in dashboard interface
- rails-pg-extras - new release adds 'table_info' and 'index_info' methods displaying summary of useful metadata
- rails-pg-extras: new release allows generating a healthcheck report of your PostgreSQL database
What are some alternatives?
Ancestry - Organise ActiveRecord model into a tree structure
Enumerize - Enumerated attributes with I18n and ActiveRecord/Mongoid support
Closure Tree - Easily and efficiently make your ActiveRecord models support hierarchies
marginalia - Attach comments to ActiveRecord's SQL queries
ActsAsTree - ActsAsTree -- Extends ActiveRecord to add simple support for organizing items into parent–children relationships.
Apartment - Database multi-tenancy for Rack (and Rails) applications
Mongoid Tree - A tree structure for Mongoid documents using the materialized path pattern
ActsAsList - An ActiveRecord plugin for managing lists.
rails_or - Cleaner syntax for writing OR Query in Rails 5, 6. And also add #or support to Rails 3 and 4.
Audited - Audited (formerly acts_as_audited) is an ORM extension that logs all changes to your Rails models.
LeftJoins - Backport left_joins method from Rails 5 for Rails 3 and 4