Blog

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:

Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got 'LIMIT'

Installing PHP 7.0 is easier than ever. Here are instructions for installing the latest version on different platforms:

With the imminent release of PHP 7 on the horizon, I thought it would be cool to check out some of the lesser-known features coming with the 7.0.0 release:

1. Array constants in define()

PHP 5.6 added the ability to define array constants on classes by using the const keyword:

const LUCKY_NUMBERS = [4, 8, 15, 16, 23, 42];

PHP 7 brings this same functionality to the define() function:

This post demonstrates how Blackfire was used to identify slowness in the league/commonmark parser. These findings were then used to implement two simple optimizations resulting in a 53% performance boost!

Creating manual backups of a website can be a time-consuming task. Using Linux, you can automate the entire download/transfer using the handy utility known as wget (Ubuntu users: install it with sudo apt-get install wget)

Here’s the command to use for downloading your backup:

wget ftp://yourwebsite.com/some/directory -nv -r -N -l inf -nH --ftp-user='username' --ftp-password='password'