News for hackers. Stuff that matters.
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by gdulli on Thursday June 18, 2015 @12:09PM (#9739527)
There's no way you're "supposed to" do it. There are tradeoffs and you pick the approach you like most given those tradeoffs.
Re:“Fashion Is Hard. PostgreSQL Is Easy” [video] by spacecowboy_lon on Friday June 19, 2015 @04:03AM (#9743514)
Not sure id agree 100% with you for standard LOB CRUD applications the use of Sprocs is best practice.

Obviously if your just writing a tool that will be used 2 or 3 times that - you can make trade offs - but you should never use $sql = "SELECT * FROM tblBobbins"