Rails PG Extras
Closure Tree
Our great sponsors
| Rails PG Extras | Closure Tree | |
|---|---|---|
| 11 | 2 | |
| 1,072 | 1,816 | |
| - | 0.1% | |
| 5.7 | 5.7 | |
| about 2 months 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.
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
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?
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
Awesome Nested Set - An awesome replacement for acts_as_nested_set and better_nested_set.
Apartment - Database multi-tenancy for Rack (and Rails) applications
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.
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.
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.