160 - PostgreSQL with Andrew Atkinson

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
• Puny to Powerful PostgreSQL Rails Apps (RailsConf 2022 talk)
• 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
• Lukas Fittl's pganalyze
• Haki Benita's post on adding constraints without validating immediately