Read more

Active Record and PostgreSQL — Ruby on Rails Guides

Arne Hartherz
January 08, 2015Software engineer at makandra GmbH

Rails guide that covers PostgreSQL-specific column types and usages for Active Record.

Illustration online protection

Rails Long Term Support

Rails LTS provides security patches for old versions of Ruby on Rails (2.3, 3.2, 4.2 and 5.2)

  • Prevents you from data breaches and liability risks
  • Upgrade at your own pace
  • Works with modern Rubies
Read more Show archive.org snapshot

You should especially keep in mind the special datatypes that PostgreSQL offers. \
Types like json and array take away a lot of the pain that you had on MySQL projects.

Example use cases for array are tags or storing foreign keys (instead of a join model). You can even index them.

Posted by Arne Hartherz to makandra dev (2015-01-08 15:06)