I will comment on the database part of your app.
I am in favor of using stored procedures for the following reasons (if they apply to your web app) They provide a greater degree of security between your web app and the DB. (you can restrict the web applications communication to the DB to be only through stored procedures) Can run one procedure and get multiple results. allows more logic to be performed on the DB which can reduce load on PHP. Can provide a level of abstraction for your programmers. (So one or two of your programmers can be more involved with the specifics of the DB. Such as requiring that the design is correct, calls are optimized and such. Where your other programmers can focus more on the web app.) On a side note: I know that some of the frameworks out there have DB objects codded into them (specificaly I tried SPs in CakePHP) and they may play that nicely with using Stored Procedures. Good luck. Andrew Cluff --- On Wed, 7/22/09, Chad Sollis <[email protected]> wrote: > From: Chad Sollis <[email protected]> > Subject: [UPHPU] looking for opinions/ideas > To: [email protected] > Date: Wednesday, July 22, 2009, 10:53 AM > Greetings, > > I am scoping a new enterprise grade web application. > I am simply in > research mode right now, but interested in any feedback > from the group as it > relates to ideas on technology, scale, cost efficiency, > development, > performance, etc, in addition to creating an environment > that talented > engineers could enter and find their way around very > easily. > > I am planning on using PHP for a variety of reasons using > AOSD/SOA style of > architecture. I am open to other > suggestions if the consensus indicates > that is not the right route. > > I know this is kind of broad question, if you have > experience in even one of > the areas, any feedback is appreciated. > > Ideas under consideration: > > - Frameworks / ORM (performance, scale, > and customization): > - Zend > - Cake > - Codeigniter > - Doctrine - Project > - Propel > - Database (triggers, procedures, speed > and scale) > - MySQL > - Postgres > - Netezza > - Amazon SimpleDB > - Architecture (scale) > - EC2 > - Mosso > - Terremark > - Managed Servers > > Many Many Thanks for your ideas and suggestions. > > ~SOL > > _______________________________________________ > > UPHPU mailing list > [email protected] > http://uphpu.org/mailman/listinfo/uphpu > IRC: #uphpu on irc.freenode.net > _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
