[Please excuse me as I'm trying to get my blogging form back... With the life juggling I've been doing lately, I've not been able to really devote myself to blogging the way I would like to]
I had a friend of mine remind me about Eric's Domain Manager Pattern (which is found here). I had yet to read the info on it, until today. I'm still processing it. There are a couple things I see:
1) He manages to segment out the database calls in a separate object (something that is a must IMHO). He also manages to couple things together so that relationships between the various tiers (for lack of a better word) are evident.
2) As I look at the pattern I keep thinking that there ought to be a better way to handle the various actions... CRUD shouldn't be all that you could do with this pattern. Sometimes I have situations where I might not have a delete, but I have 2 different update queries and 1 select for the particular object (making this up as I go... though I could probably dig up some real code). I think there ought to be a way to morph the pattern to handle actions that live outside of the typical CRUD pattern... Of course this is probably all crap... it's just the way my mind has been working lately...