del.icio.us/dossy (RSS) links since February 5, 2007 at 09:00 AM:
-
Oh, I think I’m in love with Katheryn Winnick. *swoon*
-
Only approximately. Heh.
-
Phil gives the “State of Photo.net” address, going into great detail as to who does what now, and what the strategy is moving forward. Sounds like Photo.net could give Flickr a run for its money, if done right. I’m glad to hear they’re still on AOLserve
-
Great book since it provides actual solutions in standard SQL. Of course, if you’re using Oracle, “CONNECT BY … PRIOR” makes this problem go away.
-
Singingfish.com now redirects to video.aol.com. Deck chairs are still being rearranged, it seems.
-
Quest Software, maker of the famous database software tool “Toad,” now offers “Toad for MySQL Freeware.”
Programmer, husband, father, singer, guitarist, tinkerer, reverse engineer, strange, and living in New Jersey. 
I don’t trust Celko. He had an error in his nested set model for trees that had been duplicated for over ten years before I caught the error, corrected it, and got the most wonderful response, “Shit. You’re right.” It was in books, magazines, emails, forum posts, pretty much anything he touched would have the exact same erroneous examples. The sad thing is that he rarely delves into why the particular queries do what they do.
Havard: Exactly what was the error and is the correction in the latest edition and/or the errata for the publications?
I never assume that anything I read is completely without error. It is definitely an exercise to the reader to understand the concepts–which means identifying any fallacies or mistakes in them as they’re presented.
The net effect here is that Joe Celko’s writing describes some very useful techniques that any reasonable programmer ought to learn and understand at some level. Any mistakes in the presentation of such knowledge are mostly irrelevant–as long as you understand the concepts, your own implementation will hopefully not include those mistakes and/or you’ll make your own unique ones. :-)