Constraints: a Developer's Secret Weapon
Will has been building Postgres infrastructure for the last half dozen years.
No video of the event yet, sorry!
Of all my regrets while building database-backed applications, not fully embracing database constraints sooner is one of the bigger ones. For far too long, I treated the db as a little more than a dumb key-value store with joins.
Strong constraints turn your database into the last line of defense against bad data. Applications change several orders of magnitude more often than db schemas, and each change is a chance for corruption.
Constraints in Postgres come in many forms, from literally using the CONSTRAINT keyword to a large choice of datatypes. You'll come away from this talk understanding the pros and cons of type of constraint, and be ready to transform your application into a safer and more resilient system.
- 2018 April 18 10:30
- 50 min
- PostgresConf US 2018