I create websites, applications and e-commerce solutions at Unleashed Technologies. When I'm not solving tough problems for clients, you can find me speaking at conferences all around the world. In my free time, I also like to tinker with Arduino and Android; I've helped root the enTourage eDGe and have a few sound effect widgets available on Google Play.
For Pi Day 2017 I created a really fun project - the PHPUnicorn!
A simple PHPUnit listener collects test results and sends them to a Raspberry Pi Zero Wireless device in real-time. As the device receives the stats it lights up LEDs green, red, or orange to visualize the progress and results of your unit tests.
TIL that Doctrine 2 doesn't support
LIMITs within subqueries which can be frustrating. In my case, I wanted to
LEFT JOIN on a table using a subquery with a single result - something like this:
$dqb->from('MyAppBundle:Foo', 'foo') ->leftJoin('foo.bar', 'bar', 'WITH', 'bar = (SELECT b FROM MyAppBundle:Bar b WHERE b.foo = foo AND b.published_date >= :now ORDER BY t.startDate LIMIT 1)');
But Doctrine kept throwing this error:
PHP UK 2017
Software bugs are inevitable; some are especially difficult to track down, causing you to waste countless hours before throwing your hands up in defeat. It doesn't have to be this way! The mental fatigue and wasted time can be avoided by using strategies like identifying the most-appropriate tool, taking a logical & objective approach, challenging assumptions, listening to variables, isolating the code path, and reinforcing code with automated tests.