All Fields Become Optional
As your dataset grows, exceptions creep in. There’s not enough research time to fill in all your company profiles, there’s one guy in Guam when you expected everyone to be in a U.S. state, there’s data missing from the page you’re scraping, you have to pull updates from a new source.
Every field eventually loses that beautiful NOT NULL sheen, your code gets filled up with guard clauses of one kind or another and every
in your template is wrapped by an if statement. And this happens to foreign keys, too, so OR IS (NOT) NULL sneaks in and left joins mutate into outer joins.Posted in Server.
Theoretically here to serve as a Google magnet so people can find me, though this also serves as a place for me to gather interesting things I mean to work on later when I find time. It is undistinguished in any meaningful way from the trillions of navel-gazing blogs out there and I am in no way recommending you actually read it.My public github projects, sorrowfully waylaid by always more-pressing matters...
Tags
air applications bio-engineering classifier database emacs expression-engine flex git greasemonkey mindhack mysql networking python rack rails ruby security spam xml
0 Responses
Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.
You must be logged in to post a comment.