News for hackers. Stuff that matters.
Re:Databases always have a schema (2018) by nathan_long on Tuesday February 26, 2019 @10:10AM (#19254843)
Whatever terminology you use, every place you loop through records doing stuff with them, you'll either have to decide what to do with oddly-shaped records or implicitly decide to let exceptions occur at that point. Whereas if PostgreSQL tells you that `user` has a `email character varying(255) NOT NULL`, you can be sure that every `user` does. The only place you need a conditional related to that is when trying to insert an invalid record.

There are no comments on this comment yet.