pg_party
acts_as_recursive_tree
Our great sponsors
pg_party | acts_as_recursive_tree | |
---|---|---|
1 | 1 | |
442 | 18 | |
- | - | |
3.8 | 5.1 | |
23 days ago | 9 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.
pg_party
-
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.
acts_as_recursive_tree
-
Are Exclusive Arcs Evil?
The other option is to use something like the acts_as_recursive_tree gem, which is a much narrower implementation. The upside is that you get your tree pretty easily and you can make use of pretty performant SQL. The downside is that it's more rigid, which means that if/when your requirements change you may end up having to either figure out how to modify this thing or rewrite meaningful sections from scratch.
What are some alternatives?
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]
activerecord-exclusive-arc - :dizzy: An ActiveRecord extension for implementing polymorphic relationships as exclusive arcs
Mobility - Pluggable Ruby translation framework
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).
Ruby on Rails - Ruby on Rails
textacular - Textacular exposes full text search capabilities from PostgreSQL, and allows you to declare full text indexes. Textacular will extend ActiveRecord with named_scope methods making searching easy and fun!
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
branch_base - Turn your Git Repository into a SQLite Database
Scenic - Versioned database views for Rails