I am a .net guy with 6 years of experience. Recently I started working on ROR project and realized that stored procedures/sql functions are not being used at all. On inquiring about it I got to know that it is common practice and in general nobody in team writes a sql queries at all, everything is done using ActiveRecord.
I googled about any possible reasons for this but didn't find much information. So I am just curios to know
- Is it common practice that stored procedures/sql functions are not preferred to use?
- What are pros and cons of using stored procedures?