Where can I find a list of data types that can be used in Ruby on Rails 4? Such as
textstringintegerfloatdate
I keep learning about new ones and I'd love to have a list I could easily refer to.
426
votes
possible duplicate of Where is the documentation page for ActiveRecord data types?
– Mark Thomas
@MarkThomas: Not a duplicate. My question here is specifically for Rails 4.
– Nicolas Raoul
The accepted answer in that question is essentially the same as your accepted answer. Both point to the Rails 4 docs. Also, it's a moot point because ActiveRecord datatypes didn't change from Rails 3 to Rails 4.
– Mark Thomas
I for one did not know AR datatypes didn't change between rails 3 and 4 so I'm thankful this question/answer is here.
– Dty
5 Answers
697
votes
Here are all the Rails 4 (ActiveRecord migration) datatypes:
:binary:boolean:date:datetime:decimal:float:integer:bigint:primary_key:references:string:text:time:timestamp
Source: http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/SchemaStatements.html#method-i-add_column
These are the same as with Rails 3.
If you use PostgreSQL, you can also take advantage of these:
:hstore:json:jsonb:array:cidr_address:ip_address:mac_address
They are stored as strings if you run your app with a not-PostgreSQL database.
Edit, 2016-Sep-19:
There's a lot more postgres specific datatypes in Rails 4 and even more in Rails 5.
260
votes
You might also find it useful to know generally what these data types are used for:
:string- is for small data types such as a title. (Should you choose string or text?):text- is for longer pieces of textual data, such as a paragraph of information:binary- is for storing data such as images, audio, or movies.:boolean- is for storing true or false values.:date- store only the date:datetime- store the date and time into a column.:time- is for time only:timestamp- for storing date and time into a column.(What's the difference between datetime and timestamp?):decimal- is for decimals (example of how to use decimals).:float- is for decimals. (What's the difference between decimal and float?):integer- is for whole numbers.:primary_key- unique key that can uniquely identify each row in a table
There's also references used to create associations. But, I'm not sure this is an actual data type.
New Rails 4 datatypes available in PostgreSQL:
:hstore- storing key/value pairs within a single value (learn more about this new data type):array- an arrangement of numbers or strings in a particular row (learn more about it and see examples):cidr_address- used for IPv4 or IPv6 host addresses:inet_address- used for IPv4 or IPv6 host addresses, same as cidr_address but it also accepts values with nonzero bits to the right of the netmask:mac_address- used for MAC host addresses
Learn more about the address datatypes here and here.
Also, here's the official guide on migrations: http://edgeguides.rubyonrails.org/migrations.html
161
votes
It is important to know not only the types but the mapping of these types to the database types, too:
Source added - Agile Web Development with Rails 4
86
votes
5
votes
Rails4 has some added datatypes for Postgres.
For example, railscast #400 names two of them:
Rails 4 has support for native datatypes in Postgres and we’ll show two of these here, although a lot more are supported: array and hstore. We can store arrays in a string-type column and specify the type for hstore.
Besides, you can also use cidr, inet and macaddr. For more information:
