To celebrate this milestone I thought I'd share the story of how this package came about, how it's grown, and how I couldn't have reached this milestone without the PHP community's help.
PHP 7.2 is slated for release in November 2017, but you don't have to wait until then to start testing your applications! We can easily use Docker to test against the latest pre-release versions of 7.2.
PHP 7.2 Pre-Release Images
I recently needed the ability to perform a
RIGHT JOIN in a Symfony project. While Doctrine's DBAL library seems to support this, the ORM's QueryBuilder does not. Unfortunately, the suggested workaround of inverting the query wouldn't work in my situation. I also didn't feel like rewriting the query into DQL, so I ultimately hacked in my own support by duplicating the
LEFT JOIN functionality. I figured I'd share my patch in case it helps others facing a similar issue.
Open-source development is more than big new features and major releases. Small contributions are just as important to the success of open-source projects! Any improvement, no matter how small, can help both the project and other developers.
I was playing Tetris over the weekend when I realized it's a great metaphor for managing technical debt.
Home Assistant uses the open-zwave library to control Z-Wave home automation devices like light switches and door sensors. Unfortunately, this library's last release (1.5) was back in August 2016 and doesn't include configurations for many Z-Wave devices I use (like the Linear NGDZ00-4 Garage Door).
Using a shared cache volume across all of our Docker-based Gitlab CI jobs has allowed us to drastically improve our build speeds.
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: