Tuesday, June 30, 2009

Why web developers shouldn't do systems

I stumbled into the google code blog the other day and there was a post about performance improvement for mobile html5.

There was a section about database performance which was just ridiculous. I won't go too deep into this, but I reacted strongly to the suggestion to "Use Triggers whenever possible". With some experience in application maintenance I can recommend this if you will do the maintenance on this application until its end of life. The reason is simple, putting application logic in the database is hard to debug and cannot be versioned in any simple way. So please, don't do this. Microsoft used to recommend similar things (stored procedures instead of OR mapping) and I think they're trying really hard to forget that now.