Slashdot is powered by your submissions, so send in your scoop

 



Forgot your password?
typodupeerror
Compare cell phone plans using Wirefly's innovative plan comparison tool ×

Comment Re:Postgresql (Score 1) 314

What features do stored procedures provide that can't be handled with postgresql functions?

For me database independence is important. Stored procedures let me do that. I can move from MS SQL to MYSQL or even something like HSQLDB if I wanted. All I need to do is write a procedure for said database and point my application to that database. No change in application code.

Hardcoding the SQL in your application marries you to the database you choose. I see stored procedures as a prenup agreement for databases. We get married but if you become a pain in the ass I can easily move on without losing half my stuff.

Slashdot Top Deals

The person who can smile when something goes wrong has thought of someone to blame it on.

Working...