When dealing with databases, developers frequently run into the N+1 problem, in which they populate domain objects via queries in loops. This causes terrible performance drags. The talk shows how to solve the N+1 problem in plain PHP as well as Postgres. It concludes with a way of automating the PHP side, and includes editorializing about the origins of the N+1 problem in the developer mindset.
Have you tried learning functional programming but failed to find practical uses? In this session we will apply our knowledge of SQL to illuminate valuable uses of functional programming. Using underscore.js as a foundation, we will write a SQL DSL for querying arrays of objects. You will unearth ideas you've long known about functional programming and thoughts you've never considered about SQL.