The long and winding road III
December 15, 2006 3 Comments
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….
Pingback: The long and winding road II « OraStory
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.
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.