pg_easy_replicate
jsonb_accessor
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 |
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
-
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
- 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?
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