Brian Pickens

Recent Blog Comments By Brian Pickens

• Win A FREE Ticket To CFUNITED 2009

  Posted on Jul 31, 2009 at 3:15 PM

  Sorry, trying to get it to quit emailing me by un-checking subscribe to entry and re-posting...... read more »

• Win A FREE Ticket To CFUNITED 2009

  Posted on Jul 31, 2009 at 2:43 PM

  I would like to attend "Introduction to OO modeling and design" with Brian Kotek. I don't have a sophisticated computer engineering degree, so I want to learn as much as I can about OO concepts, especially how to design them before trying to implement code right away.... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 3:47 PM

  @ Hal Wouldn't another good reason to pull that query out be to have your queries in a central location for easier editing in many circumstances? Obviously small applications it wouldn't matter, but the larger they get, the more buried your queries my become.... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 3:18 PM

  I've definitely been following these comments and I have to say this is all very interesting stuff to see everyone's different approach to accomplishing the same basic tasks. Getting data from the database in the easiest way and fastest way possible is really is what this is all about. @ Ben Trying... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 12:36 PM

  @David I disagree with you. A method should have only one purpose. As soon as you do as you suggest your method now has multiple purposes. In other words the method should used the passed in data to perform a task, rather than use the passed in data to decide which task to perform. That logic belong... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 12:32 PM

  @ Ben I do a combination of what Hatem and David suggest. Actually this is what I am developing at the moment, and feel free everyone to comment on this. For each "object" of data i need, for instance, user or article, I have a separate package named as such, with each containing a CRUD, and a Gatew... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 12:07 PM

  @ brandon Sure, and I would love to do it this way but since I work for an organization where not only i am told to do it in this certain manner, but it makes sense to write very specific queries because of the sheer traffic our sites get to where we need all the database performance we can sqeeze o... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 11:58 AM

  @ Ben/Tony Yes Ben this is exactly the case. @ David Is this now where we enter into ORM territory? And speaking of nHybernate, is this similar to the Hibernate that is slated for cf9?... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 11:03 AM

  Yep, and so I end up with many getArticlesBy*() functions. And yes I realize this is pretty much an inherent issue we must live with, but I am for sure looking forward to the day where query performance on a database server makes this issue much more moot.... read more »

• Why My Queries Hate Application Service Layers

  Posted on Jun 18, 2009 at 10:46 AM

  I have struggled with this one a bit myself in creating an OO application and trying to keep the queries as reusable as possible. But my biggest hurdle has been more of a query performance issue. For example if I have an article table and at some point I want to retrieve articles based on date, and... read more »