activerecord-slotted_counters VS pg_party

Compare activerecord-slotted_counters vs pg_party and see what are their differences.

activerecord-slotted_counters

Active Record extension providing slotted counters support (by evilmartians)

pg_party

ActiveRecord PostgreSQL Partitioning (by rkrage)
Our great sponsors
  • PopRuby - Clothing and Accessories for Ruby Developers
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
activerecord-slotted_counters pg_party
1 1
93 440
- -
7.1 4.6
5 months ago 6 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.

activerecord-slotted_counters

Posts with mentions or reviews of activerecord-slotted_counters. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-11-29.
  • counter_culture VS activerecord-slotted_counters - a user suggested alternative
    2 projects | 29 Nov 2022
    Introducing Active Record slotted counters gem—not-so-blocking counter caches for your models! This gem adds slotted counters support to Active Record counter cache. Slotted counters help to reduce contention on a single row update in case you have many concurrent operations (like updating a page views counter during traffic spikes). Details: [here](https://planetscale.com/blog/the-slotted-counter-pattern)

pg_party

Posts with mentions or reviews of pg_party. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-01-07.
  • Rails: Postgres Native Partitioning
    2 projects | /r/ruby | 7 Jan 2022
    Great post! There is also the pg_party gem that has some nice Rails-based utilities for dealing with partitions. It might help clean up some of the raw SQL in your PartitionByDay class.

What are some alternatives?

When comparing activerecord-slotted_counters and pg_party you can also consider the following projects:

pg-online-schema-change - Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL [Moved to: https://github.com/shayonj/pg-osc]

Mobility - Pluggable Ruby translation framework

Ruby on Rails - Ruby on Rails

timescaledb - The timescaledb gem. Pack of helpers to work with TimescaleDB extension in Ruby.

pg_easy_replicate - Easily setup logical replication and switchover to new database with minimal downtime

counter_culture - Turbo-charged counter caches for your Rails app.

Rails PG Extras - Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

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).

Logidze - Database changes log for Rails

Scenic - Versioned database views for Rails

acts_as_recursive_tree - Make use of recursive queries in Rails when using Postgresql or SQLite