How to work with rails form and jsonb postgres

Question

I'm looking at using the new jsonb capability in Rails4.2 and Postgres4.1.

I was looking at creating a model which represents a user profile (i.e. skill sets, etc) and storing the whole thing in a single jsonb dataset.

So the table would have:

id int
profile jsonb
timestamps

I was thinking I could basically store all the profile data in the jsonb structure as follows (this is just an example/concept):

{
  "basics": {
    "name": "John Doe",
    "label": "Programmer",
    "picture": "",
    "email": "[email protected]",
    "phone": "(912) 555-4321",
    "website": "http://johndoe.com",
    "summary": "A summary of John Doe...",
    "location": {
      "address": "2712 Broadway St",
      "postalCode": "CA 94115",
      "city": "San Francisco",
      "countryCode": "US",
      "region": "California"
    },
    "profiles": [{
      "network": "Twitter",
      "username": "john",
      "url": "http://twitter.com/john"
    }]
  },
"skills": [{
    "name": "Web Development",
    "level": "Master",
    "keywords": [
      "HTML",
      "CSS",
      "Javascript"
    ]
  }],
  "languages": [{
    "language": "English",
    "fluency": "Native speaker"
  }],
}

My question is how would I create a basic rails form that would write/read to this structure? I understand how to do it to a traditional relational set of tables, but not sure how to approach when it could all go into a flexible structure like the below?

What would happen at the _form.html.erb and in the controller new/create/edit actions?

I am in the same situation. Have you found any solution ?

medBouzid
– medBouzid

2015-04-05 00:54:40 +00:00
Commented Apr 5, 2015 at 0:54 — medBouzid
– medBouzid, Commented Apr 5, 2015 at 0:54

Dharman · Accepted Answer · 2020-09-04 16:01:43Z

12

I don't know about the previous versions but in Rails 6 from the doc: https://api.rubyonrails.org/classes/ActiveRecord/Store.html

you can use store like this:

class MyModel < ApplicationRecord
    store :my_jsonb_field_name, accessors: [:property1, :property2]
end

Now if you have a form with <%= form.text_field :property1 %> and <%= form.text_field :property2 %> they will be automatically mapped to your json/jsonb field and you will be able to treat them like if they were a regular (varchar/string) fields.

Do Not forget to permit :property1 and property2 etc in your strong parameters, i.e:

params.require(:my_model).permit(:title, [...], :property1, :property2)

edited Sep 4, 2020 at 16:01

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Sep 4, 2020 at 15:56

medBouzid

8,54611 gold badges62 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

lsdr · Accepted Answer · 2015-05-04 20:11:36Z

9

Use store_accessors. Form data is just a Hash, that could be easily converted to a JSON object and persisted in postgresql without major problems.

Assuming your form submits all profile data in a profile[] hash and your models look something like this:

class User < ActiveRecord::Base
  has_one :profile
end

class Profile < ActiveRecord::Base
  belongs_to :user
  store_accessor :profile
end

You could simply do something like:

user.profile = params[:profile]
user.profile.save

In your controller (or anywhere else) and it should work.

answered May 4, 2015 at 20:11

lsdr

1,2351 gold badge15 silver badges28 bronze badges

2 Comments

cman77 Over a year ago

awesome! any downsides or gotchas to watch out for?

lsdr Over a year ago

@cman77 Rails is doing a lot of serializing/deserializing for you without you knowing. As usual with Rails, when it works it looks like magic, but might cause some trouble. Watch out for non-conventional data structures. Everything that can be safely serialized into JSON should work fine, though.

Collectives™ on Stack Overflow

How to work with rails form and jsonb postgres

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related