In this episode I talk with Andrew Atkinson about PostgreSQL and databases. We talk about check constraints, foreign keys, and other PostgreSQL/database concepts.

  • Andy Atkinson.com
  • Andrew Atkinson on Twitter
  • Andrew Atkinson on GitHub
  • Creating a constraint that is initially "not valid"
  • Slides 16 & 17 of this presentation also deal with "not valid" constraints
  • The Strong Migrations gem at Github
  • Lucas Fittl's pganalyze
  • Haki Benita's post on adding constraints without validating immediately