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.
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).