Re: [chiPHPug-discuss] Data Models

[junkmail <jun...@2z...>]

Thanks for the great tips Arlo & Matt!

I've thought about the class based idea for a little while now, but I 
was hoping maybe there was something else. I guess a tried and true 
design pattern exist for a reason, right?

I think I'm probably doing to end up with a hybrid model consisting of a 
class-based data model with hard coded sql for sticky stuff, and a 
moderately complex CRUD sql generator to handle basic joins across a few 
tables.

My end goal is to have a relational database schema / ui that can be 
user modifiable. Each domain will have hard coded operations that are 
domain specific, while allowing the user to create additional 
fields/entities for their liking. That is where the dynamic SQL comes 
into play, but for the domain specific stuff the class based model makes 
more sense.

Any more thoughts on the subject?