Sql conference sessions

11:30am–12:10pm Thursday, 07/19/2012
Paul Jones (http://paul-m-jones.com/)
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.
11:50am–12:30pm Friday, 07/20/2012
Kris Jordan (New Media Campaigns)
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.


For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at (707) 827-7065 or scordesse@oreilly.com.

View a complete list of OSCON contacts