NYCPHP Meetup

[matt at atopia.net]

Hi all,

I'm working on a new project and I'm having a bit of trouble deciding what should go in the code vs. Database for this project. 

The database is a forum type schema, so there are a lot of transactions going on. For instance, when a record is inserted into a post table, two counters elsewhere also need to be updated. I was going to use triggers for this functionality, but we have 3 front ends to the site as well. So that has made me want to use stored procedures, but that will limit us to this specific database software (mysql). 

What balance have people found to work well for projects where there are multiple front ends and multiple developers?  Do stored procedures work well for things like that?  

Thanks,

Matt