Rails: Best practice to store user settings?

Question

I'm wondering what the best way is to store user settings? For a web 2.0 app I want users to be able to select certain settings. At the moment is it only when to receive email notifications.

The easiest way would be to just create a Model "Settings" and have a column for every setting and then have a 1-1 relationship with users.

But is there a pattern to solve this better? Is it maybe better to store the info in the user table itself? Or should I use a table with "settings_name" and "settings_value" to be completely open about the type of settings stored there (without having to run any migrations when adding options)?

What is your opinion?

Thanks

score 13 · Answer 1 · answered Aug 12 '13 at 07:03

13

If you use PostgreSQL, the best solution is to use https://github.com/diogob/activerecord-postgres-hstore/. It's a simple, fast and reliable way to store hashes in the database. Since it's not just a serialised text field, you can search on it also, and you don't need to create a new table, as in HasEasy.

def User
  serialize :preferences, ActiveRecord::Coders::Hstore
end

user = User.create preferences: { theme: "navy" }
user.preferences['theme']

answered Aug 12 '13 at 07:03

joaomilho

585
4
8

8

You don't need a gem for it any longer on rails4! Check [this how-to](http://mikecoutermarsh.com/using-hstore-with-rails-4/) – fotanus May 04 '14 at 00:10

score 11 · Answer 2 · answered Nov 05 '09 at 17:14

11

The "open" table approach makes it difficult to model with AR, since you have to worry about the types of the data (boolean, int, string, etc). I've always added prefs as columns on the users table, and then move them out to a user_preferences table if there are "too many" of them. It's simple, and it's easy to work with.

answered Nov 05 '09 at 17:14

Jonathan Julian

12,163
2
42
48

this is how i'm modeling a current project, however, i wonder, how are you accessing the User preferences site-wide? I've been reading lots of posts about how it's bad to try to access the current user within a model, that all session data should be managed in the controller. in my case though I have models/views that depend on the current user. For instance, if Current-User is browsing over Cars, I always want to show the car tank size as either "Liters" or "Gallons" depending on current user settings. Is it really necessary to do this everytime I want to see @car.tank_size(current_user)? – FireDragon Feb 22 '13 at 20:59

bantic · Answer 3 · 2010-04-16T04:44:32.407

10

If the user settings are not meant to be findable (via a User.find_by_x_preference, e.g.) you could also store them in a serialized column as a hash. This is the use case described in the rails docs (http://www.railsbrain.com/api/rails-2.3.2/doc/index.html?a=M002334&name=serialize#), actually.

class User < ActiveRecord::Base
  serialize :preferences
end

u = User.new
u.preferences = {:favorite_color => "green", :favorite_book => "Moby Dick"}

edited Apr 16 '10 at 04:44

answered Nov 05 '09 at 20:05

bantic

4,886
4
29
34

2

nice and clean but it's a "lookup + parse" instead of just "lookup". if you're using the settings frequently for app logic this could slow you down. – brittohalloran Nov 22 '11 at 13:45
it would be cool if this can integrate well with form builder – lulalala Mar 28 '12 at 02:27
3

The problem I've run into with this technique is that when you add a new preference i.e. ```:favorite_food => pizza``` there is no simple way to set default settings for all users, which there would be if there were a straightforward DB column. – earnold Feb 07 '13 at 19:45
@earnold you could just make a method when loading the settings, to check if the new setting exists otherwise add it and save it. Not beautiful, but a way to do it. – Dofs Oct 17 '14 at 08:46

scottd · Accepted Answer · 2009-11-05T21:26:48.400

7

We use the helpful plugin called HasEasy. It stores the data in a vertical table, but allows you to add validations, pre/post storage processing, types, etc.

edited Nov 05 '09 at 21:26

answered Nov 05 '09 at 17:17

scottd

7,364
1
24
27

That sounds interesting, but the link you posted is dead. Also Google didn't help. Any hints on where to find the plugin? – Ole Spaarmann Nov 05 '09 at 17:20
1

Ok, I have no clue why the link doesn't work the first time. You refresh the page after you get the page not found and it goes right to it. – scottd Nov 05 '09 at 21:29
1

@tokland I was hoping maintained meant updated every week or so. It hasn't been updated in 4 years.. – FloatingRock Oct 25 '14 at 12:15

score 3 · Answer 5 · answered Nov 28 '19 at 20:58

Rails 6 supports ActiveRecordStore that can be used to solve this problem. The gem that improves ActiveRecordStore, by adding type definition, is activerecord-typedstore.

Define attributes in your model:

class User < ApplicationRecord
  typed_store :settings do |s|
    s.boolean :public, default: false, null: false
    s.string :email
    s.datetime :publish_at
    s.integer :age, null: false
  end
end

And use can use it:

shop = Shop.new(email: 'george@cyclim.se')
shop.public?        # => false
shop.email          # => 'george@cyclim.se'
shop.published_at   # => nil

Rails: Best practice to store user settings?

5 Answers5

Linked