Summary
In Ruby on Rails 5.1.0, generated virtual column support was added for MySQL and MariaDB. Using generated and stored columns can leverage heavy calculations to the SQL side.rails database 4:38
Resources
MySQL Reference Manual - https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Ruby on Rails Commit for Virtual/Generated Columns - https://github.com/rails/rails/commit/65bf1c60053e727835e06392d27a2fb49665484c
Source - https://github.com/driftingruby/087-virtual-columns-in-mysql
Ruby on Rails Commit for Virtual/Generated Columns - https://github.com/rails/rails/commit/65bf1c60053e727835e06392d27a2fb49665484c
Source - https://github.com/driftingruby/087-virtual-columns-in-mysql
Summary
# Terminal rails g scaffold users name:string upper_name:virtual name_length:virtual
# 20170703010554_create_users.rb
class CreateUsers < ActiveRecord::Migration[5.1]
def change
create_table :users do |t|
t.string :name
t.virtual :upper_name, type: :string, as: "UPPER(name)"
t.virtual :name_length, type: :integer, as: "LENGTH(name)", stored: true
t.timestamps
end
end
end