Rails 5中.to_yaml对数组列的作用及替代方案咨询

Hey there! Let's unpack what's going on with your Rails 5 migration issue and the fixes available.

Why Did default: [] Throw an Error? #

When you tried setting default: [] for your array column, Rails 5's PostgreSQL adapter couldn't figure out how to convert the Ruby Array object into a format the database understands. PostgreSQL expects native array syntax (like '{}' for an empty array) instead of a raw Ruby object, which is why you hit the TypeError: can't quote Array error.

What Does .to_yaml Do? #

Using default: [].to_yaml converts your empty Ruby array into a YAML-formatted string (it looks like --- []\n under the hood). The database stores this string as the column's default value, and Rails automatically parses it back into a Ruby array when you retrieve records later.

That said, this is a workaround, not the ideal approach. You're essentially serializing the array into a string instead of using PostgreSQL's native array type. This means you lose access to PostgreSQL's powerful array-specific features—like array-based queries, indexes, and validations—and you'll have to handle the data as a plain string if you ever need to interact with the database directly.

Better Alternatives #

1. Use PostgreSQL's Native Empty Array Syntax #

PostgreSQL's native way to represent an empty array is '{}'. Update your migration to use this as the default, and Rails will handle the conversion between PostgreSQL's array format and Ruby's Array seamlessly:

add_column :videos, :thumbnails, :string, array: true, default: '{}'

This lets you use all of PostgreSQL's array features, like querying for records where the array contains a specific value, which isn't possible with the YAML workaround.

2. Split the Migration into up and down Steps #

If the first method still gives you trouble, you can split the column addition and default value setup into separate steps in your migration:

class AddThumbnailsToVideos < ActiveRecord::Migration[5.2]
  def up
    add_column :videos, :thumbnails, :string, array: true
    change_column_default :videos, :thumbnails, []
  end

  def down
    remove_column :videos, :thumbnails
  end
end

By adding the column first without a default, then setting the default afterward, you avoid the adapter trying to quote the Ruby array directly.

3. Confirm You're Using PostgreSQL (and Not Another Database) #

Rails' array: true attribute is primarily designed for PostgreSQL. If you're using a different database like MySQL, you'll need to use serialization (via serialize :thumbnails, Array in your model) instead, but for PostgreSQL, sticking with the native array type is always the best choice.

内容的提问来源于stack exchange，提问作者sarri xx