News for hackers. Stuff that matters.
Re:PostgREST – REST API from any PostgreSQL database by adamors on Wednesday July 22, 2015 @06:34AM (#9928736)
Well, you cannot isolate the code, you cannot unit test it, you cannot use a debugger, cannot set breakpoint, have stack traces etc. You are tied to the database at all times.

In my experience, every stored procedure that is larger than 2-3 lines is a headache.

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.