Mats codemix

Mats codemix

A little c#, a litte .NET and throw in some c++ and you get a nice Spaghetti

Mats codemix RSS Feed
 
 
 
 

Archive for Rants

Disadvantage with having code in Database

I suddenly realized one big disadvantage about having code in the database (stored procedures etc) - Restoring
Restoring a database disrupts the versioning. Code and data are not versioned together. Database structure and code are usually tied together.
Say i have a procedure i want to modify.

I edit the SP,
update it in the database
run it.

I find an [...]

June 11th, 2010 | Tags: , , | Category: Programming, Rants, SQL | Leave a comment

About stored procedures

I found some articles about stored procedures and…
I agree with most of the arguments written in them
My pet peeve about SPs is that its not a good programming language for dealing with logic and control flow. Not at all!
http://statestreetgang.net/post/2008/04/My-Statement-on-Stored-Procedures.aspx
http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx
http://home.comcast.net/~eichler2/misc/AntiSP.htm
http://blog.platinumsolutions.com/node/77

June 17th, 2009 | Category: Note to self, Rants, SQL | Comments (1)