attr_json VS jsonb_accessor

https://github.com/jrochkind/attr_json (by me)

I myself maintain one solution meant for rails attributes stored in a json column, at https://github.com/jrochkind/attr_json

One of these two should do the trick: https://github.com/jrochkind/attr_json https://github.com/DmitryTsepelev/store_model

I also have a similar "competing" in some ways gem at: https://github.com/jrochkind/attr_json

Some relational databases like Postgres and MySQL support JSON columns. This is useful if, for example, you want to create an ecommerce application with a products table with many variations - what is called Single Table Inheritance (STI). You can have some regular columns for the common attributes, and a JSON column for the specific ones.

If your app is built with Rails, you can use this library to help you on that (I'm not affiliated with it): https://github.com/jrochkind/attr_json

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

jsonb_accessor

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

jsonb_accessor seems to be the most active and popular gem with regards to working with jsonb data and Postgres.

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.