Code with Jason

160 - PostgreSQL with Andrew Atkinson


Listen Later

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
...more
View all episodesView all episodes
Download on the App Store

Code with JasonBy Jason Swett

  • 5
  • 5
  • 5
  • 5
  • 5

5

15 ratings


More shows like Code with Jason

View all
The Changelog: Software Development, Open Source by Changelog Media

The Changelog: Software Development, Open Source

289 Listeners

The Bike Shed by thoughtbot

The Bike Shed

121 Listeners

Startups For the Rest of Us by Rob Walling

Startups For the Rest of Us

710 Listeners

Ruby Rogues by Charles M Wood

Ruby Rogues

21 Listeners

Tech Brew Ride Home by Morning Brew

Tech Brew Ride Home

973 Listeners

Remote Ruby by Chris Oliver, Andrew Mason, David Hill

Remote Ruby

34 Listeners

Maintainable by Robby Russell

Maintainable

32 Listeners

The Weekly Show with Jon Stewart by Comedy Central

The Weekly Show with Jon Stewart

10,954 Listeners

Mostly Technical by Ian Landsman and Aaron Francis

Mostly Technical

26 Listeners

Code and the Coding Coders who Code it by Drew Bragg

Code and the Coding Coders who Code it

6 Listeners

Rails Business by Brendan Buckingham & Ryan Frisch

Rails Business

0 Listeners