This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2018

Constraints: a Developer's Secret Weapon

Date: 2018-10-25
Time: 12:50–13:40
Room: Berlin
Level: Intermediate

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.


Will Leinweber