Rails 3 Application/User Settings best practice?

I have a current need for allowing both admin configurable global settings as well as per-user configurable settings within a Rails 3 app.

Are there any gems or best practices that work well for this situation?

I've found a couple of gems and blog posts but they all date back to 2006-08 a开发者_高级运维nd are no longer maintained. Any pointers would be appreciated, thanks.

Note: I have seen this question with the serialised hash response but in my particular case the ability to query the database for users based on their settings is required - I don't think a serialized hash would work well in that situation.

As always right after asking for help my search bears fruit. Found Georg Ledermann's fork of rails-settings that looks like it will do just what I need.

Not sure I would look for a library for this function.

For global settings, I would create a config/application.yml file and read it in environment.rb and set it to an APP_CONFIG global. Then, I would override those settings on a per-user basis by adding a text column to the user table with json-encoded settings hash. Add a method to the user model that grabs APP_CONFIG and does a deep merge on the decoded user settings.

Another option would be to create a settings table, with a user_id column, and columns for each setting. One row with a null user_id would represent global settings. If a row exists for the current user, any non-nil values would override the global settings row.

May also want to look at https://github.com/railsjedi/rails_config. Amongst it's many features:

• Global settings.yml
• Per-environment settings files (settings/development.yml, settings/production.yml etc.)
• Local settings files (settings.local.yml, settings/development.local.yml, etc. )
• Embedded ERB support
• Rails 3 / Padrino / Sinatra support

For rails 4, if you are using postgresql, you can use HStore, which is just like a serializable attribute, but you do SQL queries with it.

For rails 3, you can use activerecord-postgres-hstore gem.