pg_easy_replicate
Easily setup logical replication and switchover to new database with minimal downtime (by shayonj)
jsonb_accessor
Adds typed jsonb backed fields to your ActiveRecord models. (by madeintandem)
| pg_easy_replicate | jsonb_accessor | |
|---|---|---|
| 11 | 10 | |
| 834 | 1,084 | |
| - | 0.7% | |
| 8.7 | 6.5 | |
| 3 days ago | about 1 month 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.
pg_easy_replicate
Posts with mentions or reviews of pg_easy_replicate.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-12-12.
-
Zero Downtime Postgres Upgrades
This is great! I wrote a tool that automates most of the things you came across. If you find it useful or would like to extend it with your feedback/ideas, I'd love to have them! Thanks for sharing
https://github.com/shayonj/pg_easy_replicate
- Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate
-
Zero downtime major PostgreSQL upgrades with pg_easy_replicate
These are great shouts! Thank you so much for sharing. One of the operations I ran with this was ~500GB and yeah it takes a few hours to catchup. For us, it wasn't an issue, especially also since we were on AWS Aurora. However, that said, I can totally see it being not feasible on other database engine/systems. I considered the idea of dropping all the indices and re-creating it once the catch up is complete. I'd like pg_easy_replicate it to support that. It should make the initial COPY lot more swift. On a 200GB large DB it cut down down the total time by 90%.
Re: bi-directional replication, you read my mind :). https://github.com/shayonj/pg_easy_replicate/blob/8df94aa93f...
These two features are top of my list to support in pg_easy_replicate
- Show HN: Minimal downtime PostgreSQL upgrades with pg_easy_replicate
- Minimal Downtime Postgres Upgrades with Pg_easy_replicate
jsonb_accessor
Posts with mentions or reviews of jsonb_accessor.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-03-14.
- How to use store_accessor for nested JSON in rails
-
Is JSONB + Postgres still a viable way of storing varying attributes?
There are some other gems that can do similar things (each with somewhat different design and possibilities) including https://github.com/madeintandem/jsonb_accessor , https://github.com/DmitryTsepelev/store_model , and https://github.com/palkan/store_attribute
-
My project: railstart app
jsonb_accessor
-
Is there a way you can create a base model and your client may add attributes as needed?
Take a look at these gems, and see if they fit your needs: - https://github.com/DmitryTsepelev/store_model - https://github.com/madeintandem/jsonb_accessor
- The Nosql Store That Everyone Ignored
-
attr_json VS jsonb_accessor - a user suggested alternative
2 projects | 8 Aug 2021
jsonb_accessor seems to be the most active and popular gem with regards to working with jsonb data and Postgres.
- jsonb_accessor - typed jsonb backed fields to your ActiveRecord models.
-
How to Create A Flexible, Performant Audit Trail In Ruby on Rails With A GraphQL API
We use the nifty JSONb Accessor gem to create accessor methods for the relevant fields. You can also use anything in ActiveModel including validations. This takes advantage of ActiveRecord's single table inheritance features where the model name, in this case update_post is stored in the type field in TrackedEvent.
What are some alternatives?
When comparing pg_easy_replicate and jsonb_accessor you can also consider the following projects:
spock - Multi-master Extension
attr_json - Serialized json-hash-backed ActiveRecord attributes, super smooth
SearchCop - Search engine like fulltext query support for ActiveRecord
PublicActivity - Easy activity tracking for models - similar to Github's Public Activity
pg_party - ActiveRecord PostgreSQL Partitioning
StoreModel - Work with JSON-backed attributes as ActiveRecord-ish models
flipper - 🐬 Beautiful, performant feature flags for Ruby.
Scenic - Versioned database views for Rails
ActiveRecord Setops - Union, Intersect, and Difference set operations for ActiveRecord (also, SQL's UnionAll).
with_advisory_lock - Advisory locking for ActiveRecord
Mobility - Pluggable Ruby translation framework
pg_easy_replicate vs spock
jsonb_accessor vs attr_json
pg_easy_replicate vs SearchCop
jsonb_accessor vs PublicActivity
pg_easy_replicate vs pg_party
jsonb_accessor vs StoreModel
pg_easy_replicate vs flipper
jsonb_accessor vs SearchCop
pg_easy_replicate vs Scenic
jsonb_accessor vs ActiveRecord Setops
pg_easy_replicate vs with_advisory_lock
jsonb_accessor vs Mobility