Rails 4 - How to store an array on postgres

Question

I need to save this array:

params[:products]

The array contains these information:

[{"'name'"=>"Product Name 1 ", "'id'"=>"2", "'quantity'"=>"2", "'accessory'"=>{"'id'"=>"8", "'name'"=>"Accessory Name 1"}}, {"'name'"=>"Product Name 2 ", "'id'"=>"5", "'quantity'"=>"1", "'accessory'"=>{"'id'"=>"40", "'name'"=>"Accessory Name 2"}}]

As you can see, accessory is another array.

The process is this: A front-end guy is givin me that array, So I want to store all data on order.rb model.

So, I have a couple of questions:

Do I need to have "array type field" on database?.
Which fields do I need?

I was looking for some examples and I've been trying this on my order model:

serialize :product

order = Order.new
order.product = [:product]
order.save
order.product

I red about this method too: http://api.rubyonrails.org/classes/ActiveRecord/Store.html

Maybe this is a basic question but I really don't know how to solve it. As you can see, I don't have code in any controller because I really don't know what I need to write.

Thank you for your help.

Store it in a text field and add this to your model: store :products, coder: JSON — Bart
– Bart, Commented Jun 5, 2016 at 3:20

mastazi · Accepted Answer · 2016-06-04 00:21:51Z

Besides hstore, another solution would be JSON, specifically I suggest you use the PostgreSQL type "jsonb" because it's more efficient, see the documentation:

There are two JSON data types: json and jsonb. They accept almost identical sets of values as input. The major practical difference is one of efficiency. The json data type stores an exact copy of the input text, which processing functions must reparse on each execution; while jsonb data is stored in a decomposed binary format that makes it slightly slower to input due to added conversion overhead, but significantly faster to process, since no reparsing is needed. jsonb also supports indexing, which can be a significant advantage.

(more info here https://www.postgresql.org/docs/current/static/datatype-json.html )

So you have, similarly to hstore, a data structure that you can execute queries against, and this queries are quite fast as you can read above. This is a significant advantage over other strategies, e.g. serializing a Ruby hash and saving it directly in the DB.

evgeny · Accepted Answer · 2016-06-03 23:55:13Z

1

Charles,

I suggest you to consider using hstore type of your postgres. There are few benefits of using it (performance, indexing of objects etc..).

enable_extension 'hstore'

This actually enables your PSQL have this support.

Your migration is going to be like this:

class AddRecommendationsToPages < ActiveRecord::Migration
  def change
    add_column :pages, :recommendations, :hstore
  end
end

And after that you can pass into your hstore anything you want..

irb(main):020:0> Page.last.recommendations
  Page Load (0.8ms)  SELECT  "pages".* FROM "pages"  ORDER BY "pages"."id" DESC LIMIT 1
=> {"products"=>"34,32"}
irb(main):021:0> Page
=> Page(id: integer, block: string, name: string, slug: string, title: string, h1: string, annotation: text, article: text, created_at: datetime, updated_at: datetime, position: integer, parent: integer, show: boolean, recommendations: hstore)
irb(main):022:0> Page.last.recommendations["products"]
  Page Load (0.6ms)  SELECT  "pages".* FROM "pages"  ORDER BY "pages"."id" DESC LIMIT 1
=> "34,32"
irb(main):023:0>

edited Jun 3, 2016 at 23:55

answered Jun 3, 2016 at 23:01

evgeny

1,1902 gold badges11 silver badges29 bronze badges

2 Comments

Charles Magnussen Over a year ago

I'm reading about 'hstore' (blog.arkency.com/2014/10/…) I can see that this is more a model level stuff. I will try with this. In my first intent, I have user_id, product_id and accessory_id in my order.rb model. So, I think I just need one field "product" for example and in this field I will save all my array, hash or json. This is correct @Evgeny ?

evgeny Over a year ago

Check the above example. This is from working project where my recommendations field is hstore and it has massive different arrays (in the above example it just points at "products" array), however I can add others .. I am sure there can be even nested things inside. I've read about it before I did not find any issues to use it. Might be good to hear from someone with massive traffic to their website and overall performance, however I am happy with this..

Collectives™ on Stack Overflow

Rails 4 - How to store an array on 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