Rails PG Extras
ActsAsList
Our great sponsors
| Rails PG Extras | ActsAsList | |
|---|---|---|
| 11 | 4 | |
| 1,072 | 2,013 | |
| - | - | |
| 5.7 | 4.6 | |
| 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
ActsAsList
-
Adding position columns based on category
You can use acts_as_list gem.
-
Best way to represent a "sequence" column in a relational database.
You can take a look at one of the longest running ruby gems, that is still part of many people's default toolbox: acts_as_list. If you don't want to use the gem, you can take a look at how they implemented the resorting.
-
Using acts_as_list for easy ordering of items
Sources: Github
-
Awesome Ruby and Rails Open Source applications
I saw your sort request in the TODO. Check out the acts_as_list gem. It makes sorting lists incredibly easy.
What are some alternatives?
Enumerize - Enumerated attributes with I18n and ActiveRecord/Mongoid support
ranked-model - An acts_as_sortable/acts_as_list replacement built for Rails 4+
marginalia - Attach comments to ActiveRecord's SQL queries
FindWithOrder - Provides a simple way to find records in the same order of input array. Has better performance than manually sorting. (Support both PostgreSQL and MySQL)
Apartment - Database multi-tenancy for Rack (and Rails) applications
rails_or - Cleaner syntax for writing OR Query in Rails 5, 6. And also add #or support to Rails 3 and 4.
Awesome Nested Set - An awesome replacement for acts_as_nested_set and better_nested_set.
Priora - An Object Prioritization Utility for Ruby
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.
Closure Tree - Easily and efficiently make your ActiveRecord models support hierarchies
Filtered - Filters ActiveRecord queries in a nice way