Re: Architecture patterns in PHP

On Tue, Dec 30, 2008 at 1:07 PM, Robert Cummings <robert@interjinn.com> wrote: > On Tue, 2008-12-30 at 12:53 -0500, Eric Butera wrote: >> On Tue, Dec 30, 2008 at 12:42 PM, Nathan Nobbe >> >> I was following the blog tutorial on cake and here's what I got from >> hitting the post/index page: >> >> 081230 12:51:55 316 Connect root@localhost on >> 316 Init DB cake >> 316 Query SHOW TABLES FROM cake >> 316 Query DESCRIBE posts >> 316 Query SELECT >> Post.id, PostWñ >> ó–¿ÊbÙ¸“¿tuP‘.title, >> Post.body, >> Post.created, >> Post.modified FROM >> posts AS >> Post WHERE 1 = 1 >> 316 Quit > > A good framework will allow you to replace the introspection step with a > static definition of the database table, thus easily bypassing the extra > queries. Although, I can't fathom why they've requested all the tables. > > Cheers, > Rob. > -- > http://www.interjinn.com > Application and Templating Framework for PHP > To be fair cake did "cache" the show tables/describe magically for a few seconds if I sat there refreshing the page. :) I always generate my Gateways & VO's from table definitions & hand-code any non-crud statements. I've never really dealt with this stuff before but it is a little disheartening. I would rather take the 5 minutes re-generating a few files for an updated table versus infinite amounts of computer power wasted trying to just make it work.