Stored Procedures don't get a lot of love and that's because very often parts of the app that should be in the app find their way into the queries. Or because sometimes if all we do is simple CRUD it's seen as additional complication. But they have their place and I'm a firm believer in them. I use them mainly for security, isolation, performance, and centralization. Not every kind of query is suited for a stored procedure, tho. I work with realtime analytical data and while we can do it with stored procedures we can achieve more more interesting results much easier with other methods.
And beside, I do not like building queries but joining a bunch of strings in the app, and I am not a fan or ORMs.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Stored Procedures don't get a lot of love and that's because very often parts of the app that should be in the app find their way into the queries. Or because sometimes if all we do is simple CRUD it's seen as additional complication. But they have their place and I'm a firm believer in them. I use them mainly for security, isolation, performance, and centralization. Not every kind of query is suited for a stored procedure, tho. I work with realtime analytical data and while we can do it with stored procedures we can achieve more more interesting results much easier with other methods.
And beside, I do not like building queries but joining a bunch of strings in the app, and I am not a fan or ORMs.