This plugin allows using json type columns in sequel, even in mysql where the database doesn't support them.
Add the plugin to all models in the following way:
class Sequel::Model
plugin :json_columns
end
Then flag individual columns as containing json data with the json_column class method.
class User < Sequel::Model
json_column :metadata
# ...
end
The content of these columns will be automatically parsed as json, so you can access the data as a hash, array etc
user = User.first
user.metadata # => {:name => 'dave', :age => 22}
user.metadata[:age] += 1
user.save_changess
Add this line to your application's Gemfile:
gem 'sequel-json_columns'Or install it yourself as:
$ gem install sequel-json_columns
The gem is available as open source under the terms of the MIT License.