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