Re:PostgREST – REST API from any PostgreSQL database
by bni on Wednesday July 22, 2015 @06:41AM
(#9928759)
All of those are no problem with the right tools. Any database IDE can debug SPs. You can unit test SPs like any other code just use a testrunner.
Re:PostgREST – REST API from any PostgreSQL database
by glogla on Wednesday July 22, 2015 @06:54AM
(#9928797)
Yeah. I suspect that lot of hate of logic in DB is because of bad Oracle setups many years ago, kind of like lot of people think SQL is useless because MySQL is.
Re:PostgREST – REST API from any PostgreSQL database
by arethuza on Wednesday July 22, 2015 @08:57AM
(#9929299)
I'm not a huge fan of stored procedures - but I'm pretty sure you can debug stored procedures in SQL Server pretty easily from Visual Studio - I think you can "step into" the call to SPs while debugging client code.
In my experience, every stored procedure that is larger than 2-3 lines is a headache.