marginalia
Rails PG Extras
Our great sponsors
| marginalia | Rails PG Extras | |
|---|---|---|
| - | 11 | |
| 1,715 | 1,074 | |
| 0.7% | - | |
| 3.5 | 5.7 | |
| about 2 months ago | 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.
marginalia
We haven't tracked posts mentioning marginalia yet.
Tracking mentions began in Dec 2020.
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?
ActsAsParanoid - ActiveRecord plugin allowing you to hide and restore records without actually deleting them.
Enumerize - Enumerated attributes with I18n and ActiveRecord/Mongoid support
Logidze - Database changes log for Rails
Apartment - Database multi-tenancy for Rack (and Rails) applications
pluck_all - A more efficient way to get data from database. Like #pluck method but return array of hashes instead.
Awesome Nested Set - An awesome replacement for acts_as_nested_set and better_nested_set.
Espinita - Audit activerecord models like a boss (and works with rails 4!)
ActsAsList - An ActiveRecord plugin for managing lists.
PaperTrail - Track changes to your rails models
Audited - Audited (formerly acts_as_audited) is an ORM extension that logs all changes to your Rails models.
Discard - 🃏🗑 Soft deletes for ActiveRecord done right
Closure Tree - Easily and efficiently make your ActiveRecord models support hierarchies