Storing arrays in database : JSON vs. serialized array

by

You can store Arrays and Hashes using ActiveRecord’s serialize declaration:

class Comment < ActiveRecord::Base
  serialize :stuff
end

comment = Comment.new  # stuff: nil
comment.stuff = ['some', 'stuff', 'as array']
comment.save
comment.stuff # => ['some', 'stuff', 'as array']

You can specify the class name that the object type should equal to (in this case Array). This is more explicit and a bit safer. You also won’t have to create the array when you assign the first value, since you’ll be able to append to the existing (empty) array.

class Comment < ActiveRecord::Base
  serialize :stuff, Array
end

comment = Comment.new  # stuff: []
comment.stuff << 'some' << 'stuff' << 'as array'

You can even use a neater version called store: http://api.rubyonrails.org/classes/ActiveRecord/Store.html

This should handle your use case using a built in method.

More Related Contents:

  1. Randomly output text from array to view – RAILS [closed]
  2. how to permit an array with strong parameters
  3. How do I parse JSON with Ruby on Rails? [duplicate]
  4. How to “pretty” format JSON output in Ruby on Rails
  5. How to override to_json in Rails?
  6. How to determine if one array contains all elements of another array
  7. In Rails, how do you render JSON using a view?
  8. Ruby on Rails: Submitting an array in a form
  9. Add virtual attribute to json output
  10. How to convert a ruby hash object to JSON?
  11. POST JSON to API using Rails and HTTParty
  12. POST json to rails server
  13. rails dates with json
  14. New data not persisting to Rails array column on Postgres
  15. Rails not decoding JSON from jQuery correctly (array becoming a hash with integer keys)
  16. Include associated model when rendering JSON in Rails
  17. How to check for a JSON response using RSpec?
  18. Uniq by object attribute in Ruby
  19. ActiveRecord serialize using JSON instead of YAML
  20. JSON encoding wrongly escaped (Rails 3, Ruby 1.9.2)
  21. How to set request headers in rspec request spec?
  22. Rails Object Relationships and JSON Rendering
  23. How to get started on TDD with Ruby on Rails? [closed]
  24. What is the difference between pluck and collect in Rails?
  25. Looking for suggestions for building a secure REST API within Ruby on Rails
  26. How can I disable logging in Ruby on Rails on a per-action basis?
  27. Template is missing
  28. How to integrate a Wrap Bootstrap theme into an Rails application?
  29. Is the server running on host “localhost” (::1) and accepting TCP/IP connections on port 5432?
  30. How to programmatically list all controllers in Rails

Leave a Comment