Posts for the 13th January 2004 (1 entry)

Rudy Limeback

13th January 2004, early afternoon | Comments (14)

My Grandma came over yesterday:

Dunstan
Hey Grandma.
Grandma
Hello darling, what are you up to?
Dunstan
Ugh, well, I’m stuck. I’m trying to understand adjacent lists, modified pre-order tree traversal and x-depth recursive nested queries, to get this SQL statement to work.
Grandma
Hmm, have you tried limiting your query loops to a set depth? That’s what your Grandad and I always do. Or a four-way left outer self join might do it, to show the current level, plus 3 levels of the tree?
Dunstan
Well that’s just it, I don’t want to go that route. It’s too limiting.
Grandma
Yes… tricky. Well, why don’t you give that nice foreign man, Rudy Steinbeck a call, dear. He’s always been very helpful in the past hasn’t he?
Dunstan
It’s ‘Limeback’ Grandma, ‘Steinbeck’ was the Of Mice and Men chap. But good point, old thing, I’ll give Rudy a buzz.

And you know what, she was right. She might not have the first clue about appropriate SQL statements ("a four-way left outer self join" — I ask you!) but she surely knows her database gurus…

View this post in full (463 words, 1 image).