pg_party
ActiveRecord PostgreSQL Partitioning (by rkrage)
pg_party
Automatic partitioning on date-timestamp columns for PostgreSQL v9.1+ (by derkan)
Our great sponsors
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.
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
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.
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
I see. In the post you link to https://github.com/derkan/pg_party which is a bash script so I was confused
What are some alternatives?
When comparing pg_party 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
activerecord-slotted_counters - Active Record extension providing slotted counters support
pg_easy_replicate - Easily setup logical replication and switchover to new database with minimal downtime
Scenic - Versioned database views for Rails
acts_as_recursive_tree - Make use of recursive queries in Rails when using Postgresql or SQLite