Rails PG Extras
Paranoia
Our great sponsors
| Rails PG Extras | Paranoia | |
|---|---|---|
| 11 | 2 | |
| 1,072 | 2,847 | |
| - | 0.6% | |
| 5.7 | 5.7 | |
| 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
Paranoia
-
We lost 54k GitHub stars
https://github.com/rubysherpas/paranoia is enough to solve problems at very large scales.
There is nothing about Rails or MVC preventing someone from doing this. This is a very common design principle for all kind of ERP and BPM systems: don't ever delete anything.
-
RoR Gems: Pin To Plane For Developing RoR Application
3. Paranoia
What are some alternatives?
Enumerize - Enumerated attributes with I18n and ActiveRecord/Mongoid support
PaperTrail - Track changes to your rails models
marginalia - Attach comments to ActiveRecord's SQL queries
Discard - 🃏🗑 Soft deletes for ActiveRecord done right
Apartment - Database multi-tenancy for Rack (and Rails) applications
ActsAsParanoid - ActiveRecord plugin allowing you to hide and restore records without actually deleting them.
Awesome Nested Set - An awesome replacement for acts_as_nested_set and better_nested_set.
Audited - Audited (formerly acts_as_audited) is an ORM extension that logs all changes to your Rails models.
ActsAsList - An ActiveRecord plugin for managing lists.
Destroyed At - ActiveRecord Mixin for Safe Destroys
mongoid-history - Multi-user non-linear history tracking, auditing, undo, redo for mongoid.