Rails 4 List of available datatypes

Question

Where can I find a list of data types that can be used in Ruby on Rails 4   Such as    text  string  integer  float  date     I keep learning about new ones and I d love to have a list I could easily refer to

User · Answer

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:

https://blog.engineyard.com/2013/new-in-rails-4

User · Answer

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

User · Answer

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

User · Answer

You can access this list everytime you want  even if you don t have Internet access  through   rails generate model -h

User · Answer

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

[ruby-on-rails] Rails 4: List of available datatypes

Examples related to ruby-on-rails

Examples related to ruby

Examples related to ruby-on-rails-4

Examples related to rails-activerecord