activerecord-summarize
Transparently combine many reporting queries (on the same tables) into one fast query—even when queries have different groups or scopes. (by midnightmonster)
prefixed_ids
Friendly Prefixed IDs for your Ruby on Rails models (by excid3)
| activerecord-summarize | prefixed_ids | |
|---|---|---|
| 5 | 2 | |
| 120 | 291 | |
| - | - | |
| 4.9 | 7.0 | |
| 9 months ago | 20 days ago | |
| Ruby | Ruby | |
| MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
activerecord-summarize
Posts with mentions or reviews of activerecord-summarize.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-12-02.
-
Show HN: I wrote a free eBook about many lesser-known/secret database tricks
This is cool! Re: multiple aggregates in one query, I wrote a Ruby gem that adds an even-more-powerful and multi-database-compatible version to ActiveRecord. (I have tested Postgres, MySQL, and SQLite are tested; others probably work, too.)
https://github.com/midnightmonster/activerecord-summarize
-
Enumerable#tally is so underused
I made activerecord-summarize because this sort of reporting is something I end up needing over and over. From a reading, writing, and maintenance perspective, I like the way you just use normal ActiveRecord methods, and the shape of the data in the block is the shape of the data in the output. You can mostly write each part of the query as if it were the only thing you were querying.
-
Building a dashboard in our portal that will be making heavy-ish queries to supply data to various bars/charts - would elasticsearch suffice to maximize query efficiency, or is there another best practice.
If you need to perform multiple counts and/or sums on the same table, perhaps with different groupings and filters applied, activerecord-summarize can do many aggregate operations in one pass.
- activerecord-summarize, a gem that parallelizes related .count/.sum queries by automatically building a single query to answer all of them at once
- Feedback? I made a gem that lets you run multiple ActiveRecord calculations at once to speed up your dashboards (almost) without changing your code
prefixed_ids
Posts with mentions or reviews of prefixed_ids.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-10-20.
-
Friendly IDs for Ruby on Rails
The magic is provided by Chris Oliver's prefixed_ids rubygem.
-
Designing APIs for humans: Object IDs
Hopefully this article has convinced you of the benefits of prefixing your IDs. If you’re curious on how to effectively implement them (and happen to be working in Ruby), Chris Oliver built a gem that makes adding this to your systems trivial.
What are some alternatives?
When comparing activerecord-summarize and prefixed_ids you can also consider the following projects:
SQL-Server-First-Responder-Kit - sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.
DatabaseConsistency - The tool to avoid various issues due to inconsistencies and inefficiencies between a database schema and application models.
active-record-query-trace - Rails plugin that logs/displays a backtrace of all SQL queries executed by Active Record
active_record-events - Manage timestamps in ActiveRecord models
rails-utils
ransack - Object-based searching.
ibis - A PHP tool that helps you write eBooks in markdown and convert to PDF.
model_probe - ActiveRecord schema visualization and model organization made easy
rubygems - Library packaging and distribution for Ruby.
mobility-actiontext - Translate Rails Action Text rich text with Mobility.
activerecord-summarize vs SQL-Server-First-Responder-Kit
prefixed_ids vs DatabaseConsistency
activerecord-summarize vs active-record-query-trace
prefixed_ids vs active_record-events
activerecord-summarize vs rails-utils
prefixed_ids vs ransack
activerecord-summarize vs ibis
prefixed_ids vs model_probe
activerecord-summarize vs ransack
activerecord-summarize vs rubygems
activerecord-summarize vs mobility-actiontext
activerecord-summarize vs model_probe