January 3, 2023 By Matthew Rathbone *

Rails migrations are a way to manage changes to the structure of a database in a Ruby on Rails application. One important aspect of migrations is data types, which determine the kind of values that a column in a database table can hold.

A Database Manager That Is Modern, Fast, & Easy To Use

Tried a few tools. Beekeeper was the only one that I found that felt right. Most had a very 1990's feel to them - Allan

I built Beekeeper Studio because, like Allan, I wanted something more intuitive and modern than all the existing clunky apps I could find. My customers agree - they love using Beekeeper and they tell me every day! Give it a try, I bet you'll like it too.

download Download for Desktop
Beekeeper's Linux version is 100% full-featured, no cut corners, no feature compromises.

There are several data types available in Rails migrations, including:

  • :string: This data type is used to store text values. By default, strings have a maximum length of 255 characters, but this can be changed by specifying a limit option when creating the column. For example, to create a string column with a maximum length of 50 characters, you could use the following syntax: t.string :name, limit: 50

  • :text: This data type is similar to :string, but it is designed to store longer text values (up to 65,535 characters). As with strings, you can specify a limit option if you want to restrict the length of the text values.

  • :integer: This data type is used to store whole numbers. By default, integers can hold values from -2147483648 to 2147483647. If you need to store larger or smaller values, you can specify a limit option to change the range of values that the column can hold. For example, to create an integer column that can hold values from -32768 to 32767, you could use the following syntax: t.integer :age, limit: 2

  • :float: This data type is used to store decimal values. By default, floats are stored using 8 bytes of memory, which allows them to store a wide range of values with high precision.

  • :decimal: This data type is similar to :float, but it allows you to specify the precision (i.e., the number of digits after the decimal point) of the decimal values. This can be useful if you need to store financial data with a high level of precision.

  • :datetime: This data type is used to store date and time values. It stores the date and time as a single timestamp, which allows you to easily compare and manipulate dates and times.

  • :timestamp: This data type is similar to :datetime, but it also stores a record of when the record was created and last updated. This can be useful for keeping track of when records were added or modified.

  • :boolean: This data type is used to store true/false values. It is often used to represent the status of something (e.g., a user’s account is active or inactive).

In addition to these data types, Rails also provides several specialized data types for storing specific types of data, such as binary data (:binary), geographical data (:point, :line_string, :polygon, etc.), and JSON data (:json, :jsonb).

When creating columns in a migration, you can also specify various options to customize the way the data is stored and displayed. For example, you can specify a default value for a column, which will be used if no value is provided when a new record is created. You can also specify a null option to allow or disallow NULL values in the column.

In summary, data types in Rails migrations are an important aspect of database design, as they determine the kind of values that a column can hold and how they are stored and displayed. By choosing the appropriate data types and options for your columns, you can ensure that your database is able to store and manage your