The long and winding road III

Of course, what you could do in this situation is write a set of encapsulating functions that return the conditions of the WHERE clause. But then you’re probably sacrificing some degree of maintainability and visibility/simplicity of code.

I was reminded of the quote from Pulp Fiction, well really from the Bible of course (Ezekial 25:17), which one could try to adapt in a pathetic attempt at geeky humour:

“Blessed is he, who in the name of relational databases and set operations, shepherds the weak through the valley of ORM mapping tools for he is truly his brother’s keeper, and the finder of lost database developers.

And I will strike down upon thee with great wait events and furious hit ratios, those who poison and destory my database efficiency.

And you will know my name is Oracle, when I lay my buffer cache upon thee.”

… oh dear….


3 Responses to The long and winding road III

  1. Pingback: The long and winding road II « OraStory

  2. Scot says:

    Hello. I was reading this about pipelines and started playing with them. I haven’t used them much if at all. Thanks for getting me thinking about them, and for not using create types.

    I wanted to send you two scripts: one that is a modification of yours from part 2, which I think simplifies it, and the other is a demo on pipelines for anyone, including my future self for when I forget.

    But I’m not sure if you will see this? This is an older article, and I’m not seeing an obvious way to contact you.

  3. dombrooks says:

    Thanks for your comments.
    Please feel free to send your scripts to my email address and I’ll have a look and a think about how to best put them up.

    Thanks also for pointing out that there’s no information about how to contact me other than via the comments. I’ll put my email address on my about page.

    Thanks again for the feedback.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: