A Stitch In Time Saves 9; or Solving the N+1 Problem

January 2014 – EU

Presented by Paul Jones (@pmjones)

Date: January 23, 2014
Time: 20:00 CET

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. There is a solution in plain PHP that makes the number of queries constant to increase performance overall. The talk shows typical PHP code involving the N+1 problem, then shows how to solve the problem in plain PHP (that is, without a framework or ORM), and includes editorializing about the origins of the N+1 problem in the developer mindset.

Paul Jones

Paul M. Jones

Paul is an internationally recognized PHP expert who has worked as everything from junior developer to VP of Engineering in all kinds of organizations (corporate, military, non-profit, educational, medical, and others). Paul’s latest open-source project is the Aura project for PHP. Among his other accomplishments, Paul is the lead developer of the Solar Framework, and the creator of the Savant template system. He has authored a series of authoritative benchmarks on dynamic framework performance, and was a founding contributor to the Zend Framework (the DB, DB_Table, and View components). He was also a member of the Zend PHP 5.3 Certification education advisory board. In a previous career, Paul was an intelligence operations specialist for the US Air Force, and enjoys putting .308 holes in targets at 400 yards.

Purchase video

Mocking Dependencies in PHPUnit

December 2013 – EU

Presented by Matt Frost (@shrtwhitebldguy)

Date: December 19, 2013
Time: 20:00 CET

Writing good unit tests is nearly impossible with out being able to mock your dependencies. This talk will cover why you should mock, when you should mock and a practical approach on how to mock. Learning to mock will add value to your tests as well as your application.

Matt Frost

Matt Frost

Matt is active in the PHP community and a contributor to a handful of Open Source projects. As an active mentor and apprentice, Matt strives to SOLID and testable object oriented code. When Matt is not writing code, he’s probably either running, reading, playing guitar or playing golf.

This meeting is over but you can still learn by purchasing the video.

Purchase video

Introduction to Databases

November 2013 – EU

Presented by Davey Shafik (@dshafik)

Date: November 14, 2013
Time: 20:00 CET

This talk will cover the basics necessary to help you decide what data to store, where, and how.

We will cover PDO — PHP’s Data Object extension, which allows you to talk to a variety of databases, including MySQL.

You will learn how to CRUD — Create, Retrieve, Update and Delete data, database schema, and when to use indexes.

Additionally, we will look at other data storage systems such as memcache, and nosql databases.

Davey Shafik


Davey Shafik is a full time PHP Developer with 12 years experience in PHP and related technologies. A Community Engineer for Engine Yard, he has written three books (so far!), numerous articles and spoken at conferences the globe over. He lives in Central Florida with his wife, son and two cats.

Davey is best known for his books, the Zend PHP 5 Certification Study Guide and PHP Master: Write Cutting Edge Code, and as the originator of PHP Archive (PHAR) for PHP 5.3.

Purchase video

Auth*: Dispelling the Myths

October 2013 – EU

Presented by Chris Cornutt (@enygma)

Date: October 17, 2013
Time: 20:00 CEST

There’s a lot of bad practices and myths floating around about authentication and authorization these days. Using passwords just isn’t good enough anymore. Come with me as I explore and dispel some of these common misconceptions and myths about these two important and often misunderstood topics. I’ll talk about some of the most common techniques and look forward to tools and options that can help make your applications even more secure.

Chris Cornutt


For the last 10+ years, Chris has been involved in the PHP community in one way or another. These days he’s the Senior Editor of PHPDeveloper.org and curator of @phpquickfix, @jsquickfix and @websecquickfix. He’s written for several PHP publications and has spoken at conferences in both the U.S. and Europe and publishes security articles on his site Websec.io. He’s also an organizer of the Dallas PHP User Group and the Lone Star PHP Conference.

Purchase video

Hypermedia ALL THE THINGS! A company’s move from POX to HATEOAS

September 2013 – EU

Presented by Luke Stokes (@lukestokes)

Date: September 26, 2013
Time: 20:00 CEST

You may have been told you’re doing REST “wrong,” but you don’t know why. You may have heard the term “Hypermedia API,” but you’re not really sure what that means. You may also know quite a bit about APIs, but want to see an API that’s done “right.” If so, this talk is for you. We’ll explore FoxyCart’s API move from POX to HATEOAS and some new ways of documenting and thinking about Hypermedia APIs.

Luke Stokes

Luke Stokes

Co-founder and core developer of FoxyCart.com which is an ecommerce shopping cart system built in PHP by developers for developers. Founded in 2007, we serve users around the world and process millions of dollars in transactions each month. With a remote team and a passion to serve customers, I have a real-world perspective on boot strapping a versioned software as a service startup company.

Download this video for free!