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