Constraints: a Developer's Secret Weapon
Will is a Principal Engineer at Citus Data on the Citus Cloud database team, where he focuses on security and scaling out Postgres horizontally. Before Citus, he was a principal member of the core Heroku Postgres team. He graduated with an M.S. in bioengineering from the University of Illinois at Urbana-Champaign. Please don't try to right-click and steal the source for his WebSite bitfission.com.
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 EDT
- 50 min
- PostgresConf US 2018