Catch up on stories from the past week (and beyond) at the Slashdot story archive

 



Forgot your password?
typodupeerror
Get HideMyAss! VPN, PC Mag's Top 10 VPNs of 2016 for 55% off for a Limited Time ×

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

"Never ascribe to malice that which is caused by greed and ignorance." -- Cal Keegan

Working...