fast_count
Quickly get a count estimation for large tables (>99% of accuracy for PostgreSQL). (by fatkodima)
pluck_in_batches
A faster alternative to the custom use of `in_batches` with `pluck` (by fatkodima)
fast_count | pluck_in_batches | |
---|---|---|
2 | 2 | |
211 | 132 | |
- | - | |
6.4 | 5.6 | |
7 months ago | 7 months 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.
fast_count
Posts with mentions or reviews of fast_count.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-12-07.
-
Everyday performance rules for Ruby on Rails developers
Counts can also be made blazingly fast (but estimate with > 99% accuracy) via https://github.com/fatkodima/fast_count.
-
Announcing fast_count - a new gem to quickly get an accurate count estimation for large tables
I released a new gem - https://github.com/fatkodima/fast_count.
pluck_in_batches
Posts with mentions or reviews of pluck_in_batches.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-12-07.
-
Everyday performance rules for Ruby on Rails developers
And for an example with generating CSV with pluck, https://github.com/fatkodima/pluck_in_batches can be utilized to make it faster.
-
Announcing pluck_in_batches - a new gem providing a faster alternative to the custom use of `in_batches` with `pluck`
I released a new gem (https://github.com/fatkodima/pluck_in_batches) - a faster alternative to the custom use of in_batches with pluck. It performs half of the number of SQL queries, allocates up to half of the memory and is up to 2x faster (or more, depending on how far is your database from the application) than the available alternative:
What are some alternatives?
When comparing fast_count and pluck_in_batches you can also consider the following projects:
mysql-binuuid-rails - Store UUIDs in binary MySQL database columns. Saves storage, and increases performance.
Lol DBA - lol_dba is a small package of rake tasks that scan your application models and displays a list of columns that probably should be indexed. Also, it can generate .sql migration scripts.
premailer-rails - CSS styled emails without the hassle.
Ruby on Rails - Ruby on Rails
online_migrations - Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).
acts_as_nosql - Allows to treat JSON fields of postgres and mysql as real fields