Rails PG Extras
Awesome Nested Set
Our great sponsors
| Rails PG Extras | Awesome Nested Set | |
|---|---|---|
| 11 | 2 | |
| 1,072 | 2,375 | |
| - | 0.1% | |
| 5.7 | 5.5 | |
| 2 months 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.
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
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
Ex https://github.com/collectiveidea/awesome_nested_set
What are some alternatives?
Enumerize - Enumerated attributes with I18n and ActiveRecord/Mongoid support
Ancestry - Organise ActiveRecord model into a tree structure
marginalia - Attach comments to ActiveRecord's SQL queries
Closure Tree - Easily and efficiently make your ActiveRecord models support hierarchies
Apartment - Database multi-tenancy for Rack (and Rails) applications
ActsAsTree - ActsAsTree -- Extends ActiveRecord to add simple support for organizing items into parent–children relationships.
ActsAsList - An ActiveRecord plugin for managing lists.
Mongoid Tree - A tree structure for Mongoid documents using the materialized path pattern
Audited - Audited (formerly acts_as_audited) is an ORM extension that logs all changes to your Rails models.
rails_or - Cleaner syntax for writing OR Query in Rails 5, 6. And also add #or support to Rails 3 and 4.
LeftJoins - Backport left_joins method from Rails 5 for Rails 3 and 4