September 2010
M T W T F S S
« Aug    
 12345
6789101112
13141516171819
20212223242526
27282930  
The two edged sword of stored procedures and views
The two edged sword of stored procedures and views

Lets start with a couple of items that we should probably agree on before proceding with my mini rant.

  • Dynamic web sites have become the norm.
  • Databases are often part of a dynamic site.
  • Stored procedures and views are often used for high volume sites.
  • Stored procedures and views should be considured source just like php, python. etc.
  • Any developer worth their salt uses some sort of source control as part of their process. The more complicated the project the more critical source control is, right? A web project that is big enough to need stored procedures is probably fairly complicated, right? So why can’t I find any tools to dump schemas, split them up, and stuff them into something like subversion?!

    Stored procedures can make a dramatic improvement in how much traffic a site can handle. So they will be used more and more by people that want to get the most out of existing hardware. Especially in the light of our current economy.

    Unless I am missing some good tools that already exist, I will be working on my own tools to do this.

    Share and Enjoy:
    • Facebook
    • Google Bookmarks
    • StumbleUpon

    Leave a Reply